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. My webcast shows how to identify resource bottlenecks with wait types and queues.
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.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
1 Comment. Leave new
Hi!
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?