September 17, 2014 at 10:13 am
Hi,
IF some one gave top most ten queries that consuming most of the cpu time. How to identify which application is using that queries.
Is there anyway to find out the source of those queries
September 17, 2014 at 10:54 am
If you got the data from a trace or extended events session then you'd include the application name or appname in the output of the trace or XE session. If you got it by querying the DMV's then you'd need to make an educated guess based on the database and the data or you might be able to get lucky and do a join to sys.dm_exec_requests and sys.dm_exec_sessions.
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
September 17, 2014 at 11:01 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply