Home

/

SQL Create table waitstats

Create table waitstats

CREATE TABLE waitstats 
(
wait_type      varchar(20),
requests       numeric(10, 0),
wait_time      numeric(12, 2),
signal_wait    numeric(12, 0),
recorded_time  datetime DEFAULT GETDATE() 
)
GO

INSERT INTO waitstats (wait_type, requests, wait_time, signal_wait)
    EXEC ('DBCC SQLPERF(WAITSTATS)')