Browse by Tags

What does WRITELOG waittype mean? WRITELOG waits represent the time waiting on a LOG I/O to complete. Common operations that cause log flushes are checkpoints and transaction commits. Transaction commits can be whenever you run a COMMIT TRAN (incase of Explicit transaction) or whenever SQL Server...

Extended Events introduced in SQL Server 2008 is a detailed event infrastructure for SQL Server. If your environment is running with more SQL Server's of version > 2008, it is the right time to learn about Extended events since they help you a lot in troubleshooting SQL Server performance issues....

You can check the status of a SPID using any of these queries: SELECT status ,* FROM sys . sysprocesses SELECT status ,* FROM sys . dm_exec_requests SELECT status ,* FROM sys . dm_exec_sessions EXEC sp_who2 It should be noted that all these queries may not return the same amount of results...