October 6, 2004 at 6:56 am
SP_WHO
1 0 background sa 0 NULL LAZY WRITER
2 0 sleeping sa 0 NULL LOG WRITER
3 0 background sa 0 master SIGNAL HANDLER
4 0 background sa 0 NULL LOCK MONITOR
5 0 background sa 0 master TASK MANAGER
6 0 background sa 0 master TASK MANAGER
7 0 sleeping sa 0 NULL CHECKPOINT SLEEP
8 0 background sa 0 master TASK MANAGER
9 0 background sa 0 master TASK MANAGER
10 0 background sa 0 master TASK MANAGER
11 0 background sa 0 master TASK MANAGER
12 0 background sa 0 master TASK MANAGER
14 0 background sa 0 master TASK MANAGER
15 0 background sa 0 master TASK MANAGER
51 0 sleeping GEdenfield W2KSRV9811A 0 gSchool AWAITING COMMAND
52 0 sleeping SIS\Administrator W2K9000SIS-S 0 BEDB AWAITING COMMAND
53 0 sleeping SIS\Administrator W2K9000SIS-S 0 BEDB AWAITING COMMAND
54 0 sleeping GEdenfield W2KSRV9811A 0 gSchool AWAITING COMMAND
55 0 sleeping leguser DP10869 0 Legacy AWAITING COMMAND
56 0 sleeping SIS\Administrator W2K9000SIS-S 0 BEDB AWAITING COMMAND
57 0 sleeping SIS\Administrator W2K9000SIS-S 0 BEDB AWAITING COMMAND
58 0 sleeping SIS\Administrator W2K9000SIS-S 0 BEDB AWAITING COMMAND
59 0 sleeping GEdenfield W2KSRV9811A 0 gSchool AWAITING COMMAND
60 0 sleeping GEdenfield W2KSRV9811A 0 gSchool AWAITING COMMAND
61 0 sleeping GEdenfield W2KSRV9811A 0 gSchool AWAITING COMMAND
62 0 sleeping SIS\Administrator W2K9000SIS-S 0 msdb AWAITING COMMAND
63 0 sleeping SIS\Administrator W2K9000SIS-S 0 master AWAITING COMMAND
64 0 sleeping leguser DP10869 0 Legacy AWAITING COMMAND
65 0 sleeping POLK-FL\kenneth.courtney DPLAB06 0 gSchool AWAITING COMMAND
66 0 sleeping GEdenfield W2KSRV9811A 0 gSchool AWAITING COMMAND
67 0 sleeping SIS\Administrator W2K9000SIS-S 0 msdb AWAITING COMMAND
68 0 sleeping POLK-FL\kenneth.courtney DPLAB06 0 gSchool AWAITING COMMAND
69 0 sleeping genuser^X-200301 DP-GVANDELLEN 0 gSchool AWAITING COMMAND
70 0 sleeping POLK-FL\gary.vandellen DP-GVANDELLEN 0 gSchool AWAITING COMMAND
71 0 sleeping POLK-FL\jason.cochran DPJCOCHRAN 0 gSchool AWAITING COMMAND
72 0 sleeping genuser^X-200301 DP-GVANDELLEN 0 gSchool AWAITING COMMAND
73 0 sleeping POLK-FL\basil.ottallah DP-BASIL-OTTALL 0 gSchool AWAITING COMMAND
77 0 runnable SIS\Administrator W2K9000SIS-P 0 master SELECT
78 0 sleeping SIS\Administrator W2K9000SIS-P 0 master AWAITING COMMAND
SP_WHO2
1 BACKGROUND sa . . NULL LAZY WRITER 0 0 10/04 10:50:48 1
2 sleeping sa . . NULL LOG WRITER 0 0 10/04 10:50:48 2
3 BACKGROUND sa . . master SIGNAL HANDLER 688 0 10/04 10:50:48 3
4 BACKGROUND sa . . NULL LOCK MONITOR 0 0 10/04 10:50:48 4
5 BACKGROUND sa . . master TASK MANAGER 0 25 10/04 10:50:48 5
6 BACKGROUND sa . . master TASK MANAGER 469 0 10/04 10:50:48 6
7 sleeping sa . . NULL CHECKPOINT SLEEP 0 151 10/04 10:50:48 7
8 BACKGROUND sa . . master TASK MANAGER 0 0 10/04 10:50:48 8
9 BACKGROUND sa . . master TASK MANAGER 0 35 10/04 10:50:48 9
10 BACKGROUND sa . . master TASK MANAGER 0 0 10/04 10:50:48 10
11 BACKGROUND sa . . master TASK MANAGER 0 0 10/04 10:50:48 11
12 BACKGROUND sa . . master TASK MANAGER 0 0 10/04 10:50:48 12
14 BACKGROUND sa . . master TASK MANAGER 0 61 10/04 10:50:48 14
15 BACKGROUND sa . . master TASK MANAGER 0 22 10/04 10:50:48 15
51 sleeping GEdenfield W2KSRV9811A . gSchool AWAITING COMMAND 594 8 10/05 20:10:43 MS SQLEM - Data Tools 51
52 sleeping SIS\Administrator W2K9000SIS-S . BEDB AWAITING COMMAND 37911202 599 10/06 08:26:03 VERITAS Backup Exec(TM) for Windows Servers 52
53 sleeping SIS\Administrator W2K9000SIS-S . BEDB AWAITING COMMAND 2775859 554 10/06 08:45:22 VERITAS Backup Exec(TM) for Windows Servers 53
54 sleeping GEdenfield W2KSRV9811A . gSchool AWAITING COMMAND 359 108 10/05 19:53:16 MS SQLEM 54
55 sleeping leguser DP10869 . Legacy AWAITING COMMAND 0 0 10/05 16:37:36 Visual Basic 55
56 sleeping SIS\Administrator W2K9000SIS-S . BEDB AWAITING COMMAND 48135 4 10/06 08:23:09 VERITAS Backup Exec(TM) for Windows Servers 56
57 sleeping SIS\Administrator W2K9000SIS-S . BEDB AWAITING COMMAND 18236 0 10/05 13:00:07 VERITAS Backup Exec(TM) for Windows Servers 57
58 sleeping SIS\Administrator W2K9000SIS-S . BEDB AWAITING COMMAND 7878268 557 10/06 08:19:22 VERITAS Backup Exec(TM) for Windows Servers 58
59 sleeping GEdenfield W2KSRV9811A . gSchool AWAITING COMMAND 1734 0 10/05 20:18:12 MS SQLEM - Data Tools 59
60 sleeping GEdenfield W2KSRV9811A . gSchool AWAITING COMMAND 1375 48 10/05 15:52:32 MS SQLEM - Data Tools 60
61 sleeping GEdenfield W2KSRV9811A . gSchool AWAITING COMMAND 0 0 10/04 10:59:12 MS SQLEM - Data Tools 61
62 sleeping SIS\Administrator W2K9000SIS-S . msdb AWAITING COMMAND 3555652 1 10/06 08:45:26 SQLAgent - Alert Engine 62
63 sleeping SIS\Administrator W2K9000SIS-S . master AWAITING COMMAND 744 44 10/04 14:13:47 MS SQLEM 63
64 sleeping leguser DP10869 . Legacy AWAITING COMMAND 0 0 10/05 16:41:03 Visual Basic 64
65 sleeping POLK-FL\kenneth.courtney DPLAB06 . gSchool AWAITING COMMAND 0 0 10/04 12:30:41 SQL Query Analyzer 65
66 sleeping GEdenfield W2KSRV9811A . gSchool AWAITING COMMAND 3017 6 10/05 17:53:59 MS SQLEM - Data Tools 66
67 sleeping SIS\Administrator W2K9000SIS-S . msdb AWAITING COMMAND 1796 0 10/05 10:20:20 SQLAgent - Generic Refresher 67
68 sleeping POLK-FL\kenneth.courtney DPLAB06 . gSchool AWAITING COMMAND 0 60 10/05 16:33:29 SQL Query Analyzer 68
69 sleeping genuser^X-200301 DP-GVANDELLEN . gSchool AWAITING COMMAND 2469 0 10/06 08:38:27 Visual Basic 69
70 sleeping POLK-FL\gary.vandellen DP-GVANDELLEN . gSchool AWAITING COMMAND 547 19 10/06 07:36:52 MS SQLEM 70
71 sleeping POLK-FL\jason.cochran DPJCOCHRAN . gSchool AWAITING COMMAND 1595 181 10/05 15:33:37 SQL Query Analyzer 71
73 sleeping POLK-FL\basil.ottallah DP-BASIL-OTTALL . gSchool AWAITING COMMAND 468 3 10/05 14:43:20 SQL Query Analyzer 73
77 RUNNABLE SIS\Administrator W2K9000SIS-P . master SELECT INTO 688 4 10/06 08:44:32 SQL Query Analyzer 77
78 sleeping SIS\Administrator W2K9000SIS-P . master AWAITING COMMAND 578 22 10/06 08:44:23 SQL Query Analyzer - Object Browser 78
SP_LOCK
51 7 0 0 DB S GRANT
52 11 0 0 DB S GRANT
53 11 0 0 DB S GRANT
54 7 0 0 DB S GRANT
55 12 0 0 DB S GRANT
56 11 0 0 DB S GRANT
57 11 0 0 DB S GRANT
58 11 0 0 DB S GRANT
59 7 0 0 DB S GRANT
60 7 0 0 DB S GRANT
61 7 0 0 DB S GRANT
62 4 0 0 DB S GRANT
64 12 0 0 DB S GRANT
65 7 0 0 DB S GRANT
66 7 0 0 DB S GRANT
67 4 0 0 DB S GRANT
68 7 0 0 DB S GRANT
69 7 0 0 DB S GRANT
70 7 0 0 DB S GRANT
71 7 0 0 DB S GRANT
73 7 0 0 DB S GRANT
77 1 85575343 0 TAB IS GRANT
MSDTC is running are far as I know.
SQL Agent is running.
I connect using Windows Auth. and I also tried SQL auth. but the results were the same.
Dan
October 11, 2004 at 6:15 am
I did a search on the internet and supposedly there is a fix for Query Analyzer NOT RESPONDING issues. Do you know of this and if so where can I get this fix.
Thanks,
Dan
October 26, 2004 at 6:20 am
Has anything been found to fix this problem????
Thanks,
Dan
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply