Watch Brent Tune Servers [Video] #MSIgnite

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.

,
Previous Post
Databases Need a Kosher Certification
Next Post
Staging Data: Locking Danger with ALTER SCHEMA TRANSFER

11 Comments. Leave new

  • Michel Zehnder
    May 11, 2015 10:52 am

    Hi Brent

    Around minute 30, the screen freezes and never gets updated. Is this only me?

    Thanks
    Michel

    Reply
  • Michel Zehnder
    May 11, 2015 10:53 am

    Hah… reload with another browser, and seems to work now 🙂 Sorry!

    Reply
  • Carm Vecchio
    May 11, 2015 1:14 pm

    Great pres Brent. Will share with my team.

    Reply
  • Yasser Salem
    May 12, 2015 12:41 pm

    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.

    Reply
  • Oh dear! The video seems to be malfunctioning. (in FF and IE)

    Reply
  • Good demos on some of the SQL 2014 features and where to use and when.

    Reply
  • Awesome session Brent! You rock!!!!!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}