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…
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…
how to use sql server dmo’s to gather what resources are the bottlenecks and which queries are causing those bottlenecks.
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…
to save right click on links and choose “save target as”
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).