Top SQL queries based on CPU usage and execution time

Question

Top SQL queries based on CPU usage and execution time

PJ_SQL

SSCertifiable

Points: 6703
More actions
August 25, 2016 at 5:29 pm

#316666

How do I capture information regarding top sql queries based on CPU usage and execution time?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

You can download this book for free: Performance Tuning With SQL Server Dynamic Management Views and it has the queries you are looking for.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 2

search Glenn Berry SQL Server Diagnostic Scripts

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 3

Look to extended events as a way of ensuring you'll capture exactly what you need in a controlled fashion.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning