监控SQLSERVER系统性能的脚本
监控SQLSERVER系统性能的脚本
1 --queryprocess 2 --跟踪系统性能脚本: 3 SET NOCOUNT ON 4 GO 5 USE master 6 GO 7 8 DECLARE @i INT 9 DECLARE @loops INT 10 DECLARE @delayStr VARCHAR(20) 11 12 --根据需求，可以调整@loops和@delayStr的值 13 SET @loops = 60000 14 SET @delayStr = '00:0:10' --每10秒执行一次脚本 15 16 DBCC SQLPERF(waitstats,CLEAR) 17 DBCC SQLPERF(umsstats,CLEAR) 18 19 SET @i = 0 20 WHILE @i < @loops 21 BEGIN 22 WAITFOR DELAY @delayStr 23 PRINT 'START TIME' 24 SELECT CURRENT_TIMESTAMP 25 PRINT 'END TIME' 26 PRINT '' 27 28 PRINT 'START SYSPROC' 29 SELECT * 30 FROM [sys].[sysprocesses] 31 PRINT 'END SYSPROC' 32 PRINT '' 33 34 PRINT 'START WAITSTATS' 35 DBCC SQLPERF(waitstats) 36 PRINT 'END WAITSTATS' 37 PRINT '' 38 39 PRINT 'START SYSSCHED' 40 DBCC SQLPERF(umsstats) 41 PRINT 'END SYSSCHED' 42 PRINT '' 43 -- ... 44 --根据需求加入其他监视语句 45 SELECT @i = @i + 1 46 END
DBA可以将这段脚本保存成一个叫queryprocess.sql的批处理文件，然后用osql或者sqlcmd来调用
比如用osql，执行的命令是：osql /E /S /i queryprocess.sql /o queryprocess.out /w 3000
我把他做成了一个批处理：queryprocess.bat
输出的内容
1 1> 2> 3> 4> 1> 2> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 2 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 3 START TIME 4 5 ----------------------- 6 2013-02-13 14:45:46.247 7 8 END TIME 9 10 START SYSPROC 11 spid kpid blocked waittype waittime lastwaittype waitresource dbid uid cpu physical_io memusage login_time last_batch ecid open_tran status sid hostname program_name hostprocess cmd nt_domain nt_username net_address net_library loginame context_info sql_handle stmt_start stmt_end request_id 12 ------ ------ ------- -------- -------------------- -------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ ------ ----------- -------------------- ----------- ----------------------- ----------------------- ------ --------- ------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------- ---------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------ ------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------ ----------- ----------- ----------- 13 1 3468 0 0x0000 0 SOS_SCHEDULER_YIELD 0 1 9890 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 RESOURCE MONITOR sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 14 2 3464 0 0x0060 826 LAZYWRITER_SLEEP 0 1 11980 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 LAZY WRITER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 15 3 3436 0 0x007F 338022 LOGMGR_QUEUE 0 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 suspended 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 LOG WRITER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 16 4 3584 0 0x0080 2480 REQUEST_FOR_DEADLOCK_SEARCH 0 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 LOCK MONITOR sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 17 5 3452 0 0x009D 3939618 KSOURCE_WAKEUP 1 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SIGNAL HANDLER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 18 6 0 0 0x0000 0 MISCELLANEOUS 1 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 19 7 3588 0 0x00A2 1700 SQLTRACE_BUFFER_FLUSH 1 1 15 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TRACE QUEUE TASK sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 20 8 0 0 0x0000 0 MISCELLANEOUS 0 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 UNKNOWN TOKEN sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 21 9 4344 0 0x00A9 3952831 BROKER_TRANSMITTER 1 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 BRKR TASK sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 22 10 3756 0 0x007E 3954718 ONDEMAND_TASK_QUEUE 1 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 23 11 3592 0 0x0081 338163 CHECKPOINT_QUEUE 1 1 31 88 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 CHECKPOINT sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 24 13 0 0 0x0000 0 MISCELLANEOUS 1 1 0 2503 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 25 15 0 0 0x0000 0 MISCELLANEOUS 1 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 26 17 0 0 0x0000 0 MISCELLANEOUS 1 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 27 26 4328 0 0x00AD 3948837 BROKER_EVENTHANDLER 1 1 0 77 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 BRKR EVENT HNDLR sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 28 27 3772 0 0x00A9 3952878 BROKER_TRANSMITTER 1 1 0 0 0 2013-02-13 13:40:06.790 2013-02-13 13:40:06.790 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 BRKR TASK sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0 0 29 51 10060 0 0x0000 0 SOS_SCHEDULER_YIELD 1 1 0 9 2 2013-02-13 14:45:36.003 2013-02-13 14:45:36.077 0 0 runnable 0x010500000000000515000000AF75934274490F9D679DD442F401000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 JOE OSQL-32 8316 SELECT JOE Administrator E89A8FCBB84F LPC JOE\Administrator 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x01000100833DE70C2002B8050000000000000000 878 990 0 30 52 0 0 0x0000 0 MISCELLANEOUS 4 1 93 184 2 2013-02-13 13:40:10.297 2013-02-13 13:40:11.757 0 0 sleeping 0x0101000000000005120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 JOE SQLAgent - Generic Refresher 4432 AWAITING COMMAND NT AUTHORITY SYSTEM E89A8FCBB84F LPC NT AUTHORITY\SYSTEM 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x01000400628D3815C815DE040000000000000000 0 0 0 31 56 0 0 0x0000 0 MISCELLANEOUS 1 1 93 80 2 2013-02-13 13:42:54.267 2013-02-13 13:42:56.923 0 0 sleeping 0x010500000000000515000000AF75934274490F9D679DD442F401000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 JOE Microsoft SQL Server Management Studio 7672 AWAITING COMMAND JOE Administrator E89A8FCBB84F LPC JOE\Administrator 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x010001000A43142D401FDE040000000000000000 0 0 0 32 59 0 0 0x0000 0 MISCELLANEOUS 5 1 0 0 2 2013-02-13 14:45:43.427 2013-02-13 14:45:43.520 0 0 sleeping 0x0101000000000005120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 JOE Report Server 3556 AWAITING COMMAND NT AUTHORITY SYSTEM E89A8FCBB84F LPC NT AUTHORITY\SYSTEM 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0100050014260A35D000B8050000000000000000 0 0 0 33 34 END SYSPROC 35 36 START WAITSTATS 37 Wait Type Requests Wait Time Signal Wait Time 38 -------------------------------- -------------- -------------- ---------------- 39 MISCELLANEOUS 0.0 0.0 0.0 40 LCK_M_SCH_S 0.0 0.0 0.0 41 LCK_M_SCH_M 0.0 0.0 0.0 42 LCK_M_S 0.0 0.0 0.0 43 LCK_M_U 0.0 0.0 0.0 44 LCK_M_X 0.0 0.0 0.0 45 LCK_M_IS 0.0 0.0 0.0 46 LCK_M_IU 0.0 0.0 0.0 47 LCK_M_IX 0.0 0.0 0.0 48 LCK_M_SIU 0.0 0.0 0.0 49 LCK_M_SIX 0.0 0.0 0.0 50 LCK_M_UIX 0.0 0.0 0.0 51 LCK_M_BU 0.0 0.0 0.0 52 LCK_M_RS_S 0.0 0.0 0.0 53 LCK_M_RS_U 0.0 0.0 0.0 54 LCK_M_RIn_NL 0.0 0.0 0.0 55 LCK_M_RIn_S 0.0 0.0 0.0 56 LCK_M_RIn_U 0.0 0.0 0.0 57 LCK_M_RIn_X 0.0 0.0 0.0 58 LCK_M_RX_S 0.0 0.0 0.0 59 LCK_M_RX_U 0.0 0.0 0.0 60 LCK_M_RX_X 0.0 0.0 0.0 61 LATCH_NL 0.0 0.0 0.0 62 LATCH_KP 0.0 0.0 0.0 63 LATCH_SH 0.0 0.0 0.0 64 LATCH_UP 0.0 0.0 0.0 65 LATCH_EX 0.0 0.0 0.0 66 LATCH_DT 0.0 0.0 0.0 67 PAGELATCH_NL 0.0 0.0 0.0 68 PAGELATCH_KP 0.0 0.0 0.0 69 PAGELATCH_SH 0.0 0.0 0.0 70 PAGELATCH_UP 0.0 0.0 0.0 71 PAGELATCH_EX 0.0 0.0 0.0 72 PAGELATCH_DT 0.0 0.0 0.0 73 PAGEIOLATCH_NL 0.0 0.0 0.0 74 PAGEIOLATCH_KP 0.0 0.0 0.0 75 PAGEIOLATCH_SH 0.0 0.0 0.0 76 PAGEIOLATCH_UP 0.0 0.0 0.0 77 PAGEIOLATCH_EX 0.0 0.0 0.0 78 PAGEIOLATCH_DT 0.0 0.0 0.0 79 TRAN_MARKLATCH_NL 0.0 0.0 0.0 80 TRAN_MARKLATCH_KP 0.0 0.0 0.0 81 TRAN_MARKLATCH_SH 0.0 0.0 0.0 82 TRAN_MARKLATCH_UP 0.0 0.0 0.0 83 TRAN_MARKLATCH_EX 0.0 0.0 0.0 84 TRAN_MARKLATCH_DT 0.0 0.0 0.0 85 LAZYWRITER_SLEEP 11.0 11013.0 31.0 86 IO_COMPLETION 0.0 0.0 0.0 87 ASYNC_IO_COMPLETION 0.0 0.0 0.0 88 ASYNC_NETWORK_IO 2.0 62.0 0.0 89 SLEEP_BPOOL_FLUSH 0.0 0.0 0.0 90 CHKPT 0.0 0.0 0.0 91 SLEEP_TASK 19.0 0.0 0.0 92 SLEEP_SYSTEMTASK 0.0 0.0 0.0 93 RESOURCE_SEMAPHORE 0.0 0.0 0.0 94 DTC 0.0 0.0 0.0 95 OLEDB 0.0 0.0 0.0 96 FAILPOINT 0.0 0.0 0.0 97 RESOURCE_QUEUE 0.0 0.0 0.0 98 ASYNC_DISKPOOL_LOCK 0.0 0.0 0.0 99 THREADPOOL 0.0 0.0 0.0 100 DEBUG 0.0 0.0 0.0 101 REPLICA_WRITES 0.0 0.0 0.0 102 BROKER_RECEIVE_WAITFOR 0.0 0.0 0.0 103 DBMIRRORING_CMD 0.0 0.0 0.0 104 WAIT_FOR_RESULTS 0.0 0.0 0.0 105 SOS_SCHEDULER_YIELD 8.0 0.0 0.0 106 SOS_VIRTUALMEMORY_LOW 0.0 0.0 0.0 107 SOS_RESERVEDMEMBLOCKLIST 0.0 0.0 0.0 108 SOS_LOCALALLOCATORLIST 0.0 0.0 0.0 109 SOS_CALLBACK_REMOVAL 0.0 0.0 0.0 110 LOWFAIL_MEMMGR_QUEUE 0.0 0.0 0.0 111 BACKUP 0.0 0.0 0.0 112 BACKUPBUFFER 0.0 0.0 0.0 113 BACKUPIO 0.0 0.0 0.0 114 BACKUPTHREAD 0.0 0.0 0.0 115 DBMIRROR_DBM_MUTEX 0.0 0.0 0.0 116 DBMIRROR_DBM_EVENT 0.0 0.0 0.0 117 DBMIRROR_SEND 0.0 0.0 0.0 118 CURSOR_ASYNC 0.0 0.0 0.0 119 HTTP_ENUMERATION 0.0 0.0 0.0 120 SOAP_READ 0.0 0.0 0.0 121 SOAP_WRITE 0.0 0.0 0.0 122 DUMP_LOG_COORDINATOR 0.0 0.0 0.0 123 DISKIO_SUSPEND 0.0 0.0 0.0 124 IMPPROV_IOWAIT 0.0 0.0 0.0 125 QNMANAGER_ACQUIRE 0.0 0.0 0.0 126 DEADLOCK_TASK_SEARCH 0.0 0.0 0.0 127 REPL_SCHEMA_ACCESS 0.0 0.0 0.0 128 REPL_CACHE_ACCESS 0.0 0.0 0.0 129 SQLSORT_SORTMUTEX 0.0 0.0 0.0 130 SQLSORT_NORMMUTEX 0.0 0.0 0.0 131 SQLTRACE_WAIT_ENTRIES 0.0 0.0 0.0 132 SQLTRACE_LOCK 0.0 0.0 0.0 133 SQLTRACE_BUFFER_FLUSH 3.0 11980.0 0.0 134 SQLTRACE_SHUTDOWN 0.0 0.0 0.0 135 MSQL_SYNC_PIPE 0.0 0.0 0.0 136 QUERY_TRACEOUT 0.0 0.0 0.0 137 DTC_STATE 0.0 0.0 0.0 138 FCB_REPLICA_WRITE 0.0 0.0 0.0 139 FCB_REPLICA_READ 0.0 0.0 0.0 140 WRITELOG 0.0 0.0 0.0 141 HTTP_ENDPOINT_COLLCREATE 0.0 0.0 0.0 142 EXCHANGE 0.0 0.0 0.0 143 DBTABLE 0.0 0.0 0.0 144 EC 0.0 0.0 0.0 145 TEMPOBJ 0.0 0.0 0.0 146 XACTLOCKINFO 0.0 0.0 0.0 147 LOGMGR 0.0 0.0 0.0 148 CMEMTHREAD 0.0 0.0 0.0 149 CXPACKET 0.0 0.0 0.0 150 WAITFOR 1.0 9999.0 0.0 151 CURSOR 0.0 0.0 0.0 152 EXECSYNC 0.0 0.0 0.0 153 SOSHOST_INTERNAL 0.0 0.0 0.0 154 SOSHOST_SLEEP 0.0 0.0 0.0 155 SOSHOST_WAITFORDONE 0.0 0.0 0.0 156 SOSHOST_MUTEX 0.0 0.0 0.0 157 SOSHOST_EVENT 0.0 0.0 0.0 158 SOSHOST_SEMAPHORE 0.0 0.0 0.0 159 SOSHOST_RWLOCK 0.0 0.0 0.0 160 SOSHOST_TRACELOCK 0.0 0.0 0.0 161 MSQL_XP 0.0 0.0 0.0 162 MSQL_DQ 0.0 0.0 0.0 163 LOGBUFFER 0.0 0.0 0.0 164 TRANSACTION_MUTEX 0.0 0.0 0.0 165 MSSEARCH 0.0 0.0 0.0 166 XACTWORKSPACE_MUTEX 0.0 0.0 0.0 167 CLR_JOIN 0.0 0.0 0.0 168 CLR_CRST 0.0 0.0 0.0 169 CLR_SEMAPHORE 0.0 0.0 0.0 170 CLR_MANUAL_EVENT 0.0 0.0 0.0 171 CLR_AUTO_EVENT 0.0 0.0 0.0 172 CLR_MONITOR 0.0 0.0 0.0 173 CLR_RWLOCK_READER 0.0 0.0 0.0 174 CLR_RWLOCK_WRITER 0.0 0.0 0.0 175 SQLCLR_QUANTUM_PUNISHMENT 0.0 0.0 0.0 176 SQLCLR_APPDOMAIN 0.0 0.0 0.0 177 SQLCLR_ASSEMBLY 0.0 0.0 0.0 178 KTM_ENLISTMENT 0.0 0.0 0.0 179 KTM_RECOVERY_RESOLUTION 0.0 0.0 0.0 180 KTM_RECOVERY_MANAGER 0.0 0.0 0.0 181 SQLCLR_DEADLOCK_DETECTION 0.0 0.0 0.0 182 QPJOB_WAITFOR_ABORT 0.0 0.0 0.0 183 QPJOB_KILL 0.0 0.0 0.0 184 BAD_PAGE_PROCESS 0.0 0.0 0.0 185 BACKUP_OPERATOR 0.0 0.0 0.0 186 PRINT_ROLLBACK_PROGRESS 0.0 0.0 0.0 187 ENABLE_VERSIONING 0.0 0.0 0.0 188 DISABLE_VERSIONING 0.0 0.0 0.0 189 REQUEST_DISPENSER_PAUSE 0.0 0.0 0.0 190 DROPTEMP 0.0 0.0 0.0 191 FT_RESTART_CRAWL 0.0 0.0 0.0 192 FT_RESUME_CRAWL 0.0 0.0 0.0 193 LOGMGR_RESERVE_APPEND 0.0 0.0 0.0 194 LOGMGR_FLUSH 0.0 0.0 0.0 195 XACT_OWN_TRANSACTION 0.0 0.0 0.0 196 XACT_RECLAIM_SESSION 0.0 0.0 0.0 197 DTC_WAITFOR_OUTCOME 0.0 0.0 0.0 198 DTC_RESOLVE 0.0 0.0 0.0 199 SEC_DROP_TEMP_KEY 0.0 0.0 0.0 200 SRVPROC_SHUTDOWN 0.0 0.0 0.0 201 NET_WAITFOR_PACKET 0.0 0.0 0.0 202 DTC_ABORT_REQUEST 0.0 0.0 0.0 203 DTC_TMDOWN_REQUEST 0.0 0.0 0.0 204 RECOVER_CHANGEDB 0.0 0.0 0.0 205 WORKTBL_DROP 0.0 0.0 0.0 206 MIRROR_SEND_MESSAGE 0.0 0.0 0.0 207 SNI_HTTP_ACCEPT 0.0 0.0 0.0 208 SNI_HTTP_WAITFOR_0_DISCON 0.0 0.0 0.0 209 UTIL_PAGE_ALLOC 0.0 0.0 0.0 210 SERVER_IDLE_CHECK 0.0 0.0 0.0 211 BACKUP_CLIENTLOCK 0.0 0.0 0.0 212 DEADLOCK_ENUM_MUTEX 0.0 0.0 0.0 213 INDEX_USAGE_STATS_MUTEX 0.0 0.0 0.0 214 VIEW_DEFINITION_MUTEX 0.0 0.0 0.0 215 QUERY_NOTIFICATION_MGR_MUTEX 0.0 0.0 0.0 216 QUERY_NOTIFICATION_TABLE_MGR_MUT 0.0 0.0 0.0 217 QUERY_NOTIFICATION_SUBSCRIPTION_ 0.0 0.0 0.0 218 QUERY_NOTIFICATION_UNITTEST_MUTE 0.0 0.0 0.0 219 IMP_IMPORT_MUTEX 0.0 0.0 0.0 220 RESOURCE_SEMAPHORE_MUTEX 0.0 0.0 0.0 221 IO_AUDIT_MUTEX 0.0 0.0 0.0 222 BUILTIN_HASHKEY_MUTEX 0.0 0.0 0.0 223 SOS_PROCESS_AFFINITY_MUTEX 0.0 0.0 0.0 224 MSQL_XACT_MGR_MUTEX 0.0 0.0 0.0 225 MSQL_XACT_MUTEX 0.0 0.0 0.0 226 QRY_MEM_GRANT_INFO_MUTEX 0.0 0.0 0.0 227 SOS_STACKSTORE_INIT_MUTEX 0.0 0.0 0.0 228 SOS_SYNC_TASK_ENQUEUE_EVENT 0.0 0.0 0.0 229 SOS_OBJECT_STORE_DESTROY_MUTEX 0.0 0.0 0.0 230 EE_PMOLOCK 0.0 0.0 0.0 231 RESOURCE_SEMAPHORE_QUERY_COMPILE 0.0 0.0 0.0 232 RESOURCE_SEMAPHORE_SMALL_QUERY 0.0 0.0 0.0 233 FULLTEXT GATHERER 0.0 0.0 0.0 234 SEQUENTIAL_GUID 0.0 0.0 0.0 235 BROKER_TASK_STOP 0.0 0.0 0.0 236 SNI_LISTENER_ACCESS 0.0 0.0 0.0 237 EXECUTION_PIPE_EVENT_INTERNAL 0.0 0.0 0.0 238 ASSEMBLY_LOAD 0.0 0.0 0.0 239 TIMEPRIV_TIMEPERIOD 0.0 0.0 0.0 240 INTERNAL_TESTING 0.0 0.0 0.0 241 Total 44.0 33056.0 31.0 242 243 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 244 END WAITSTATS 245 246 START SYSSCHED 247 Statistic Value 248 -------------------------------- -------------- 249 Node Id 0.0 250 Avg Sched Load 5.0 251 Sched Switches 489.0 252 Sched Pass 4869.0 253 IO Comp Passes 2860.0 254 Scheduler ID 0.0 255 online 1.0 256 num tasks 4.0 257 num runnable 0.0 258 num workers 6.0 259 active workers 4.0 260 work queued 0.0 261 cntxt switches 0.0 262 cntxt switches(idle) 2.0 263 preemptive switches 0.0 264 Scheduler ID 1.0 265 online 1.0 266 num tasks 5.0 267 num runnable 0.0 268 num workers 8.0 269 active workers 3.0 270 work queued 0.0 271 cntxt switches 2.0 272 cntxt switches(idle) 7.0 273 preemptive switches 1.0 274 Scheduler ID 2.0 275 online 1.0 276 num tasks 3.0 277 num runnable 0.0 278 num workers 6.0 279 active workers 3.0 280 work queued 0.0 281 cntxt switches 8.0 282 cntxt switches(idle) 18.0 283 preemptive switches 4.0 284 Scheduler ID 3.0 285 online 1.0 286 num tasks 5.0 287 num runnable 0.0 288 num workers 7.0 289 active workers 4.0 290 work queued 0.0 291 cntxt switches 24.0 292 cntxt switches(idle) 20.0 293 preemptive switches 9.0 294 295 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 296 END SYSSCHED
