运行一下sp_who看看?写出结果。
解决方案 »
- 关于导入excel源的易操作性
- 如何匹配:;,0,;
- T-SQL时间判断问题
- 100年前的第一个月第一天怎么得到
- 这个查询怎么写,谢谢
- 左匹配,右匹配??
- 简单问题,去掉相同数据,求最简单的sql
- vfp里,系统日期时间怎么取呀`!`急~`
- 紧急求助,如何用一个SQL语句完成数据继承?
- 请教该问题如何解决???
- 请教:我在当前数据库(Human)中进行数据库恢复,程序报错.但是,帮助中说可以"不是必须从 master 数据库运行 RESTORE DATABASE 语句,但最好
- 误恢复数据库备份(如:bak)为一个在使用(有用)的数据库(如:pubs),pubs中内容全变为bak数据库中的内容了,急需撤消该操作,怎么办?
------ ---------- ------------ ------------------------------ ----- ---------- ----------------
1 sleeping sa 0 master MIRROR HANDLER
2 sleeping sa 0 master LAZY WRITER
3 sleeping sa 0 master CHECKPOINT SLEEP
4 sleeping sa 0 master RA MANAGER
10 sleeping UHAPP KF 0 hospital AWAITING COMMAND
11 sleeping UHAPP KF 0 hospital AWAITING COMMAND
12 sleeping UHAPP KF 0 hospital AWAITING COMMAND
13 sleeping UHAPP KF 0 hospital AWAITING COMMAND
14 sleeping UHAPP KF 0 hospital AWAITING COMMAND
15 sleeping UHAPP KF 0 hospital AWAITING COMMAND
16 sleeping UHAPP KF 0 hospital AWAITING COMMAND
17 sleeping UHAPP KF 0 hospital AWAITING COMMAND
18 sleeping UHAPP KF 0 hospital AWAITING COMMAND
19 sleeping UHAPP KF 0 hospital AWAITING COMMAND
20 sleeping UHAPP KF 0 hospital EXECUTE
21 sleeping UHAPP KF 0 hospital AWAITING COMMAND
22 sleeping UHAPP KF 0 hospital AWAITING COMMAND
23 sleeping UHAPP KF 0 hospital AWAITING COMMAND
24 sleeping UHAPP KF 0 hospital AWAITING COMMAND
25 sleeping UHAPP 0 hospital AWAITING COMMAND
26 sleeping sa KF 0 master AWAITING COMMAND
27 sleeping UHAPP KF 0 hospital AWAITING COMMAND
28 runnable sa KF 0 hospital SELECT
30 sleeping UHAPP KF 0 hospital AWAITING COMMAND
31 sleeping UHAPP KF 0 hospital EXECUTE
80 sleeping sa MAIN 0 master AWAITING COMMAND (1 row(s) affected)
spid status loginame hostname blk dbname cmd
------ ---------- ------------ ------------------------------ ----- ---------- ----------------
1 sleeping sa 0 master MIRROR HANDLER
2 sleeping sa 0 master LAZY WRITER
3 sleeping sa 0 master CHECKPOINT SLEEP
4 sleeping sa 0 master RA MANAGER
10 sleeping UHAPP KF 0 hospital AWAITING COMMAND
11 sleeping UHAPP KF 0 hospital AWAITING COMMAND
12 sleeping UHAPP KF 0 hospital AWAITING COMMAND
13 sleeping UHAPP KF 0 hospital AWAITING COMMAND
14 sleeping UHAPP KF 0 hospital AWAITING COMMAND
15 sleeping UHAPP KF 0 hospital AWAITING COMMAND
16 sleeping UHAPP KF 0 hospital AWAITING COMMAND
17 sleeping UHAPP KF 0 hospital AWAITING COMMAND
18 sleeping UHAPP KF 0 hospital AWAITING COMMAND
19 sleeping UHAPP KF 0 hospital AWAITING COMMAND
20 sleeping UHAPP KF 0 hospital EXECUTE
21 sleeping UHAPP KF 0 hospital AWAITING COMMAND
22 sleeping UHAPP KF 0 hospital AWAITING COMMAND
23 sleeping UHAPP KF 0 hospital AWAITING COMMAND
24 sleeping UHAPP KF 0 hospital AWAITING COMMAND
25 sleeping UHAPP 0 hospital AWAITING COMMAND
26 sleeping sa KF 0 master AWAITING COMMAND
27 sleeping UHAPP KF 0 hospital AWAITING COMMAND
28 runnable sa KF 0 hospital SELECT
30 sleeping UHAPP KF 0 hospital AWAITING COMMAND
31 sleeping UHAPP KF 0 hospital EXECUTE
80 sleeping sa MAIN 0 master AWAITING COMMAND (1 row(s) affected)
1、你的6.5安装了SP3--SP5没有。
2、你在客户端的EM看看,是不是能看到。重新注册方法:
EM的“SERVER MANAGER”里选择你的SERVER,点右键,选Un-Register,回答“Yes”,就删除了注册。点右键,选Register Server,输入Server,Login ID,Password,点“Register”按钮,就完成了注册。
1.数据库6.5 没有安装sp3--sp5,但我认为不回是这方面的问题,因为一直都好用
2.客户端里也看不到活动用户
3.删除注册并重新注册好几次了,还是不行
4.在不显示活动用户之前,我对数据库配置做了调整,调整了7.8个参数,我不知道调整哪个参数后,活动用户就不显示了,我具体说一下情况机器是 HP LH4 CPU P3(XEON)550*2 1G内存 9G*4硬盘
操作系统 NT4+SP6+IIS4(IIS4没有使用) 数据库 SQL6.5(没有补丁SP包)内存分配: NT 400 SQL6.5 600(其中TEMP DB 300)
6.5数据库参数修改如下: 参数 原配置 现配置
User Connections 300 300
Temp In RAM 200 200
Open Objects 300000 500000
Lock 250000 300000
memory 307200(600M) 307200
*LE Threshold Maximum 200 20000
*LE Threshold Percent 0 100
*Max Text Repl Size 65536 ---307200 --65536其他都是使用默认值1.我的印象中好象是有*号(在最后调整的几项)的调整后,就看不到活动用户了
2.其中(Max Text Repl Size 65536 ---307200)是错误调整,但当时调整后还是可以看到活动用户的,后面我有把该参数调整为默认值:65536
3.请主要分析有*号的调整项
4.有什么办法,使活动用户重现???请高手指点!!!
如果只是这几个参数调整后就有问题,那只能是LE Threshold Percent ,你给改回0重启试试。
1.要停止SQL SERVER 服务要在晚上9:00以后,而且只能停止几分钟,我只能到时候再改动参数并重新启动 SQL SERVER 了,我的印象中,是不需要启动NT服务器的,这没错把?
2.等到晚上我发信息,但愿就是这个原因.