Performance Tuning

Fix SQL Server Error 802: There is insufficient memory available in the buffer pool.

We receive SQL Server error 802 when buffer pool of SQL Server instance is full and cannot grow further. Here,…

Top Perfmon Counters to Identify SQL Server CPU Bottleneck

We should always monitor system resource utilization of our database servers and make sure that these utilizations should not exceed…

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…

SQL Server Error 701: There is Insufficient System Memory to Run this Query

Today I am going to discuss SQL Server memory issues that your database Instance might face during bulk data load…

Overview on SQL Server Performance Tuning

SQL Server Performance Tuning is an important subject and it is essential to implement various measures at regular intervals of…

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…

Disk and Performance Impact of Online Index Rebuild Operation

Here, we are going to talk about disk and performance Impact of online Index rebuild operation. As we know index…

Should We Clear Wait Statistics Data from DMV sys.dm_os_wait_stats in SQL Server?

Should we clear or reset Performance Wait Statistics Data present in DMV sys.dm_os_wait_stats in SQL Server? The answer to this question is depends…

SQL Server Interview Questions & Answers on Indexes

This article is part of SQL Server interview questions & answers series. Today, i am covering SQL Server Interview Questions &…

Identify Disk Bottleneck in SQL Server using Perfmon Disk Counters

Disk I/O problems are some of the most difficult problems to diagnose and to debug. Here I am going to…

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…

How to Avoid Page Split in SQL Server?

This is very interesting topic. How to Avoid Page Split in SQL Server? Let's start with basics. Page split is…

Difference between Index Rebuild and Reorganize

Fragmentation exists when indexes have pages in which the logical ordering, based on the key value, does not match the…

Understanding SQL Server Indexes

SQL Server Indexes are similar to book indexes that we use to search any content in that book. They are…