CREATE TABLE #IOWarning (LogDate datetime , ProcessInfo sysname , LogText nvarchar(1000)); INSERT INTO #IOWarning EXEC xp_readerrorlog 0, 1, N'taking longer than 15 seconds'; INSERT INTO #IOWarning EXEC xp_readerrorlog 1, 1, N'taking longer than 15 seconds'; INSERT INTO #IOWarning EXEC xp_readerrorlog 2, 1, N'taking longer than 15 seconds'; INSERT INTO #IOWarning EXEC xp_readerrorlog 3, 1, N'taking longer than 15 seconds'; INSERT INTO #IOWarning EXEC xp_readerrorlog 4, 1, N'taking longer than 15 seconds'; INSERT INTO #IOWarning EXEC xp_readerrorlog 5, 1, N'taking longer than 15 seconds'; SELECT LogDate, ProcessInfo, LogText FROM #IOWarning ORDER BY LogDate DESC;
2 thoughts on “Get IO warning from log”
Comments are closed.
Pingback: Read specific errors using temp table Himanshu Patel SQL Server Consultant developer & Administrator -
Pingback: Get TempDB files count Himanshu Patel SQL Server Consultant developer & Administrator -