SQLAuthority News – Online Webcast How to Identify Resource Bottlenecks – Wait Types and Queues

SQLAuthority News - Online Webcast How to Identify Resource Bottlenecks - Wait Types and Queues queue11 As all of you know I have been working a recently on the subject SQL Server Wait Statistics, the reason is since I have published book on this subject SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues [Amazon] | [Flipkart] | [Kindle], lots of question and answers I am encountering. When I was writing the book, I kept version 1 of the book in front of me. I wanted to write something which one can use right away. I wanted to create an primer for everybody who have not explored wait stats method of performance tuning.

Well, the books have been very well received and in fact we ran out of huge stock 2 times in India so far and once in USA during SQLPASS. I have received so many questions on this subject that I feel I can write one more book of the same size. I have been asked if I can create videos which can go along with this book. Personally I am working with SQL Server 2012 CTP3 and there are so many new wait types, I feel the subject of wait stats is going to be very very crucial in next version of SQL Server. If you have not started learning about this subject, I suggest you at least start exploring this right now. Learn how to begin on this subject atleast as when the next version comes in, you know how to read DMVs.

I will be presenting on the same subject of performance tuning by wait stats in webcast embarcadero SQL Server Community Webinar. Here are few topics which we will be covering during the webinar.

  • Beginning with SQL Wait Stats
  • Understanding various aspect of SQL Wait Stats
  • Understanding Query Life Cycle
  • Identifying three TOP wait Stats
  • Resolution of the common 3 wait types and queues

Details of the webcast:
How to Identify Resource Bottlenecks – Wait Types and Queues
Date and Time: Wednesday, November 2, 11:00 AM PDT
Registration Link

I thank embarcadero for organizing opportunity for me to share my experience on subject of wait stats and connecting me with community to further take this subject to next level.

One more interesting thing, I will ask one question at the end of the webinar and I will be giving away 5 copy of my SQL Wait Stats print book to first five correct answers.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Wait Stats
Previous Post
SQLAuthority News – SQL Server Wait Stats – eBook to Download on Kindle – Answer to FREE PDF Download Request
Next Post
SQL SERVER – How to Ignore Columnstore Index Usage in Query

Related Posts

1 Comment. Leave new

  • Eugene Lobanov
    October 28, 2011 6:59 pm


    Pinal, can you explain the situation with several domain groups and user who belongs to them.

    What default kanguage user will get?

    for Example

    DOMAINUser is a member of DOMAINGroup1 and DOMAINGroup2.
    DOMAINGroup1 and DOMAINGroup2 are logins on the SQL Server. DOMAIN
    User is not.
    DOMAINGroup1’s default language is English
    DOMAINGroup2’s default language is British English

    My question is, when DOMAINUser logs on, is their default language
    well defined?


Leave a Reply