How can I check the Long Running Query by using Stats..

Question

How can I check the Long Running Query by using Stats..

Chowdary's

SSCrazy

Points: 2978
More actions
April 29, 2014 at 3:52 am

#396675

Hi All,
Here am Using SQL 2008,
How can i check the Long Running Query by using the following Query and how to tune that query to improve the Performance ..
"select * from sys.dm_exec_query_stats"
Regards..
Jagadeesh...
Regards
Chowdary...

Viewing 6 posts - 1 through 5 (of 5 total)

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

doug.brown SSCertifiable Points: 5607 More actions · Answer 1

Query tuning is a complex art, but Grant Fritchey's book on execution plans is a good resource to start with. It's available as a free pdf here:

http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

You can do this to get the plan:

SELECT

DEQP.query_plan

FROM

sys.dm_exec_query_stats AS DEQS

CROSS APPLY sys.dm_exec_query_plan(DEQS.plan_handle) AS DEQP

WHERE

[some criteria to determine what is long running]

Then you can examine the execution plan to determine where/what to start stuning.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Chowdary's SSCrazy Points: 2978 More actions · Answer 3

Thank u All.....

is there any Video Links for that Query Tuning...

Regards
Chowdary...

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

You can find lots on google. Select as per your need.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

doug.brown SSCertifiable Points: 5607 More actions · Answer 5

I got some good tuning tips from this Brent Ozar video:

http://www.brentozar.com/archive/2014/01/watch-brent-tune-queries/