Wait Types

Top 10 Performance Counters to Identify SQL Server Memory Pressure

Memory is one of the important system resource that SQL Server uses to process their transactions. Sometimes, your server might…

How to Reduce PREEMPTIVE_OS_WRITEFILEGATHER Wait Type in SQL Server?

I was getting wait type PREEMPTIVE_OS_WRITEFILEGATHER during database size allocation. Yesterday, I was configuring database size to the value that…

4 Different Usages of DBCC SQLPERF in SQL Server

DBCC SQLPERF is very useful command that we use to get multiple statistics related information in SQL Server. This command…

Fix Event ID 833: SQL Server has encountered 32 occurrence(s) of I/O requests taking longer than 15 seconds to complete.

Last week, we found some slowness in one of our database server. When we analyzed the database server, we found…

Understanding ASYNC_IO_COMPLETION Wait type in SQL Server

Normally, ASYNC_IO_COMPLETION Wait type can be seen during backup and restore activities. Whenever you will see this wait type your…

How to fix BACKUPBUFFER Wait Types?

Today I was working on an issue in which backup job was showing in executing state since last 2 days.Initially…

How to Fix RESOURCE_SEMAPHORE Wait Type in SQL Server?

RESOURCE_SEMAPHORE waits occurs when a query memory request cannot be granted immediately due to other concurrent queries. High waits and…

What is SQL Server Wait Type? or How to get wait type info in sql server?

 Wait Types are awesome way to troubleshoot performance related issues. In SQL Server 2005 and later version we can get…