SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

published 730 days, 12 hours, 10 minutes ago posted by

pinaldave 737 days, 11 hours, 39 minutes ago

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries on SQL Server Box. SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_sta...

category: Query | clicked: 5 | | source: blog.sqlauthority.com | show counter code

tags: pinaldave, SQL, SQLAuthority, SQLServer

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up