Earlier this year, I was fortunate to take part in the first edition of the Group By Conference organized by Brent Ozar. I was extremely fortunate that I was able to present an hour long presentation on the subject 3 Common Mistakes to Kill SQL Server Performance.
Group By project is extremely unique as it follows a very democratic model. Speakers submit their sessions and community selects the session, which they want to hear. I was extremely fortunate that my submitted session was of interest to the people. On January 20th, I got the opportunity to present the session to live audience. The session was mega-success as the conference was attended by hundreds (may be thousand) of attendees.
A special thanks to Brent Ozar Unlimited for organizing this community initiative. I can clearly see how much effort and time (and of course significant amount of fund) this project can take. From building a website to coordinating with authors & from being the host to post-production of videos – this was indeed a mammoth effort. I must congratulate everyone who is associated with this project for their contribution.
Here is the title and abstract of this video:
3 Common Mistakes to Kill SQL Server Performance!
No one wants slow performance of their application.
In this session we will learn about three mistakes which DBA often do which kills SQL Server’s performance. We will understand what are those errors, why those particular errors are prevailing in the industry and how we can fix it.
We will explore various settings as well as code which will kill SQL Server Performance. At the end of this session every attendee will receive scripts which will help them improve their SQL Server’s performance. This session is of intermediate level – you just have to know a little bit about SQL Server and a lot more you will learn in this session. The session is carefully crafted from the real world experience for DBA so they can learn tricks which can help them to improve their server’s performance.
We will discuss about various SQL Server Settings, File Placements as well as ignored details related to SQL Server Performance.
Here is the link to Download PPT and Script
If you love the video and want to say thank you, here is the quickest way to express-
Method 1:Â Go to and leave your vote and feedback
Method 2: Just tweet the link of this blog post (tweet this), so more and more people can take advantage of this FREE video.
I also conduct very high impact and action oriented, Practical Workshop for Performance Tuning (3-4 Hours). It is extremely popular as it is No PPT, 100% Demonstration oriented training.
Reference: Pinal Dave (https://blog.sqlauthority.com)
18 Comments. Leave new
Database ‘test’ cannot be opened because it is offline.
Please bring that online to use script.
I do like your energy Pinal. I LOL about your wife making you coffee.
Just loved this one! Hats-off!
Thank you for your kind note.
Just gone through your video shared on this post. The complete knowledge shared by you is a learning lesson for me. Your time and efforts are highly appreciated.
Thanks Hetalkumar.
thanks for your share.
Thanks @sam
I really appreciate your Knowledge and information that you share , thank you so much
Thanks @Sachidanand
This contains valuable Information AND was fun to watch.
Awesome energy Sir and superb presentation…
Thanks A lot for highlighting our mistakes!!!
It was really really helpful session…
Thank you so much!
Thanks a lot Pinal Sir.
Great meeting you my friend!
Hi Pinal ,Thanks for the session .i cant find all scripts which you have used during this session
Hi Pinal, thank you for sharing parts of your know how. I enjoyed this video!