SQL Wait Stats Archives - Page 10 of 13 - SQL Authority with Pinal Dave

SQL SERVER – OLEDB – Link Server – Wait Type – Day 23 of 28

February 23, 2011

When I decided to start writing about this wait type, the very first question that came to my mind was, “What does ‘OLEDB’ stand for?” A quick search on Wikipedia tells me that OLEDB means Object Linking and Embedding Database. (How many of you knew this?) Anyway, I found it…

SQL SERVER – Guest Post – Jacob Sebastian – Filestream – Wait Types – Wait Queues – Day 22 of 28

February 22, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Filestream, SQL Wait Stats

Jacob Sebastian is a SQL Server MVP, Author, Speaker and Trainer. Jacob is one of the top rated expert community. Jacob wrote the book The Art of XSD – SQL Server XML Schema Collections and wrote the XML Chapter in SQL Server 2008 Bible. See his Blog | Profile. He…

SQL SERVER – Guest Posts – Feodor Georgiev – The Context of Our Database Environment – Going Beyond the Internal SQL Server Waits – Wait Type – Day 21 of 28

February 21, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

This guest post is submitted by Feodor. Feodor Georgiev is a SQL Server database specialist with extensive experience of thinking both within and outside the box. He has wide experience of different systems and solutions in the fields of architecture, scalability, performance, etc. Feodor has experience with SQL Server 2000…

SQL SERVER – MSQL_XP – Wait Type – Day 20 of 28

February 20, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

In this blog post, I am going to discuss something from my field experience. While consultation, I have seen various wait typed, but one of my customers who has been using SQL Server for all his operations had an interesting issue with a particular wait type. Our customer had more…

SQL SERVER – PREEMPTIVE and Non-PREEMPTIVE – Wait Type – Day 19 of 28

February 19, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

In this blog post, we are going to talk about a very interesting subject. I often get questions related to SQL Server 2008 Book-Online about various Preemptive wait types. I got a few questions asking what these wait types are and how they could be interpreted. To get current wait…

SQL SERVER – LOGBUFFER – Wait Type – Day 18 of 28

February 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Wait Stats

At first, I was not planning to write about this wait type. The reason was simple- I have faced this only once in my lifetime so far maybe because it is one of the top 5 wait types. I am not sure if it is a common wait type or…

SQL SERVER – WRITELOG – Wait Type – Day 17 of 28

February 17, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Wait Stats

WRITELOG is one of the most interesting wait types. So far we have seen a lot of different wait types, but this log type is associated with log file which makes it interesting to deal with.