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 is an API used by SQL Server when retrieving … [Read more...] about The OLEDB Wait Type and How to Reduce It
SQL Server Performance
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. This is one wait type that can be misjudged. I mentioned before that the wait types … [Read more...] about Reducing SQL Server CXPACKET Wait Type
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 your SQL Server is assigned a scheduler and it is responsible for managing … [Read more...] about An Overview of SQL Server Task Scheduling
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 time of writing this post, I do not know about all of the wait types in SQL Server and there are many of … [Read more...] about An Introduction to SQL Server Wait Types and Stats
How to Delete Millions of Rows using T-SQL with Reduced Impact
In this post, I talk about deleting millions of rows in SQL Server whilst keeping impact low. Deleting millions of rows in one transaction can throttle a SQL Server TRUNCATE TABLE - We will presume that in this example TRUNCATE TABLE is not available due to permissions, that foreign keys prevent this operation from being executed or that this operation is unsuitable for … [Read more...] about How to Delete Millions of Rows using T-SQL with Reduced Impact