Detect Worst Performing SQL Queries – Part 3

Best way to tune production server is to find out what are the queries executed in a particular duration and how many times it got executed, thus to concentrate on tuning top hitting queries ASAP…check out the video and scripts

this series of videos will walk through how to detect worst performing sql queries which is slowing down microsoft sql server, after this session you should be able to achieve below objectives…

  1. how to find out during production peak hour what are the exact queries taking most of the resources and will benefit most from fine-tuning…
  2. how to use sql server dmo’s to gather what resources are the bottlenecks and which queries are causing those bottlenecks.
  3. demo – how to find which exact queries are taxing production systems resources based on cpu/disk/memory/network.

please check videos for part 1 & part2  for previous videos of this series…

scripts:

to save right click on links and choose “save target as”

scripts repository – github sample load generator to create test scenario’s

24 Hours of Free, Nonstop SQL Server Training

Join SQL Server experts as they take an in-depth look at the hottest SQL Server topics over 24 consecutive (and free!) technical webcasts. The learning starts on March 21, 2012 beginning at 00:00 GMT (that’s a March 20 evening start for the Americas).

24 hours of pass watch from your home/office

join sql server experts as they take an in-depth look at the hottest sql server topics over 24 consecutive (and free!) technical webcasts. the learning starts on march 21, 2012 beginning at 00:00 gmt (that’s a march 20 evening start for the americas).

register today

i personally love these sessions which you can watch from home comfort also some of my favorite speakers are talking on latest sql server topics….

cindy gross on fitting microsoft hadoop into your enterprise bi strategy

jessica m. moss on upgrading and overhauling your ssis packages for 2012

jorge segarra on  stop! consolidate and listen!

kendra little  on sql server first responder kit

grant fritchey on what to look for in sql server 2012 execution plans

complete session schedule