Last week at Microsoft Ignite 2015 in Chicago, I demonstrated how to tune a few SQL Server workloads with my favorite process:
- Measure how fast the SQL Server is going
- Check its bottlenecks
- Apply some easy-to-tweak configuration settings and measure the difference
There’s no camera in this hour-long video, just a screen capture, so you’ll have to imagine my jazz hands.
You can grab the demo scripts here, and grab our related performance tuning resources here.
11 Comments. Leave new
Hi Brent
Around minute 30, the screen freezes and never gets updated. Is this only me?
Thanks
Michel
Hah… reload with another browser, and seems to work now 🙂 Sorry!
Great pres Brent. Will share with my team.
Great session Brent as always .. Thank You.
Have a question about WaitTime numbers .. in the example about WriteLog, the waittime was about 21 seconds for a few seconds query .. can you explain this a bit more. I always have the same thing when I examine some of my instances where the waittime number in seconds (for any WaitType not WriteLog in particular) sometimes more than the duration of the SQL batch itself. It always guide me to what is the main waittype on the instance and how it is related to other waittype .. but the number itself of the waittime always makes me wondering.
Also probably related as you mentioned, I frequently getting this “more than 15 seconds” for some LUNs on some instances .. but again, in many cases, the number of occurences reported in sql log message if multiplied by 15 seconds will give very strange and huge number that does not make sense.
Thanks.
Yasser – the query was being run thousands of times, so it added up to dozens of seconds of writelog waits.
Oh dear! The video seems to be malfunctioning. (in FF and IE)
Sorry to hear that! You can try Chrome, or visit Microsoft directly: https://channel9.msdn.com/Events/Ignite/2015/BRK3566?wt.mc_id=player
Good demos on some of the SQL 2014 features and where to use and when.
Anand – thanks!
Awesome session Brent! You rock!!!!!
Awww, thanks!