Post reply

Identify Long Running Queries (include LoginName and HostName in results)

  • September 11, 2009 at 12:54 pm

    #138011

    Hi Everyone,

    I'm hoping someone can point me in the right direction. I would like to identify and log all the poor performing queries in my data warehouse. I know this could easily be accomplished by running a trace through profiler with a filter on duration but I want to avoid running a 24/7 trace. The dmv sys.dm_exec_query_stats provides 99% of the information I need but is missing 2 very important pieces on information I need...Loginname and HostName. Not only do I want to identify the poor performing SQL but I also want to know where it originated from and who performed it. Is it possible to obtain this information without capturing it through profiler?

    Any help would be appreciated!

    Thanks

  • September 11, 2009 at 3:56 pm

    #1052598

    you can run trace without profiler, is it interesting to you ?

  • September 11, 2009 at 9:09 pm

    #1052638

    Yes..Please explain.

  • September 11, 2009 at 9:45 pm

    #1052648

    Hi,

    Refer the Gail shaw remarks,

    http://www.sqlservercentral.com/Forums/Topic706167-65-1.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

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