SQL Server Video Tutorials

SQL Server Video Tutorials

SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing any additional load on system.

Prakash heda

2-Minute Read

On 9th April 10.30 PM PST, I will be speaking on “Detect Worst Performing SQL Queries During Peak Hour” @ SQLSaturday, Silicon Valley!!, If you are in the area I hope to see you!!

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing any additional load on system.

Prakash heda

2-Minute Read

On 24th Oct 02.15 PM PST, I will be speaking on “Detect Worst Performing SQL Queries During Peak Hour” @ SQLSaturday, Portland!!, If you are in the area I hope to see you!!

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

Prakash heda

1-Minute Read

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!!

Detect Worst Performing SQL Queries - Part 2

Part 2 -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

Prakash heda

1-Minute Read

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!!

Detect Worst Performing SQL Queries

How to use SQL Server DMO's to gather what resources are the bottlenecks and which queries are causing those bottlenecks. 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...

Prakash heda

1-Minute Read

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!!

Recent Posts

categories

About

SQL Server Video Tutorials shared by Prakash Heda