SQL点滴之收集SQL Server线程等待信息

复制use AdventureWorks CREATETABLE dbo.WaitStats ( dt DATETIME NOTNULLDEFAULT (CURRENT_TIMESTAMP),点滴之待信 wait_type NVARCHAR(60) NOTNULL, waiting_tasks_count BIGINTNOTNULL, wait_time_ms BIGINTNOTNULL, max_wait_time_ms BIGINTNOTNULL, signal_wait_time_ms BIGINTNOTNULL ); CREATEUNIQUE CLUSTERED INDEX idx_dt_type ON dbo.WaitStats(dt, wait_type); CREATEINDEX idx_type_dt ON dbo.WaitStats(wait_type, dt); 1.2.3.4.5.6.7.8.9.10.11.12.