Using DBCC FREEPROCCACHE to Clear SQL Server Procedure Cache

It is possible to clear out the entire SQL Server procedure cache using DBCC FREEPROCCACHE The procedure cache is where SQL Server will cache execution plans after they have been compiled. The benefit of this caching is that there is no need for the execution plans to be compiled at run time. This compiling operation […]

The OLEDB Wait Type and How to Reduce It

In this post, I look at the OLEDB wait type. Books Online lists this as “Occurs when SQL Server calls the SQL Server Native Client OLEDB Provider. This wait type is not used for synchronization. Instead, it indicates the duration of calls to the OLE DB provider.” “OLEDB” stands for Object Linking Embedding Database. OLEDB […]

Reducing SQL Server CXPACKET Wait Type

In my last post, I wrote about how SQL Server schedules tasks to be executed. It’s important to be  able to understand this when when trying to analyse wait types and statistics in SQL Server. For this post, I will be looking at the CXPACKET wait type and what you can do to reduce it. […]

An Overview of SQL Server Task Scheduling

In my previous post, I touched upon SQL Server wait types and in order to understand wait types in SQL Server, it’s important to know first how the server schedules tasks. On each CPU core, only a single thread or “worker” can be running at any given time. Each CPU, be it logical or physical inside […]

An Introduction to SQL Server Wait Types and Stats

Ok, so in this post, I wanted to go over SQL Server wait types and statistics  – what they are and how to check them. My idea is then to start a series of posts which go into more detail about individual SQL Server wait types, their causes and how to improve them. At the […]