Tuesday, October 15, 2013

SQL Server: Get a list of most expensive queries

I’m not a DBA but still I want to know what’s happening inside our SQL Server. You never know what you can achieve with a little bit of optimization.

On Brent Ozar’s blog I found the following query that returns the top 20 most resource-expensive  queries:

If you execute this query, you not only get the Average CPU, Duration, … but also the query plan.

image

By clicking on the query plan XML, you can even get a graphical representation:

image

Nice!

2 comments:

mywindowshosting said...

Good one, Keep Posting more. Get more features about asp hosting reviews you can come at www.mywindowshosting.com

Shruti Ramalingam said...
This comment has been removed by a blog administrator.