12 Kicks

SQL SERVER – Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 2 years ago

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.

add a comment |category: |Views: 484

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
kirankkirank(175) - BagavathiBagavathi(150) - marcy23marcy23(0) - rodinizrodiniz(106)
More who kicked this story...
Comments:
information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?