July 7, 2010 at 3:22 pm
I have two questions.
Q1. Other than using a third party tool , what views should i be looking at to fetch the query of my own (say for a particular os user or sql server authenticated user , or for a particular IP)?.
May be i will be able to filter sp_who and sp_who2. If someone has a ready script i would appreciate it ( i can modify it to for my environment).
Q2: How do i identify sessions consuming higher resources? I understand Resource Manager will help me limit, but i would like to first look at the problematic sessions.
TIA
July 9, 2010 at 10:21 am
Try sys.dm_exec_sessions dynamic management view.
Other related views and relationships displayed here: http://msdn.microsoft.com/en-us/library/ms181509.aspx
July 9, 2010 at 10:39 am
There's also Jason's scripts from this article: http://www.sqlservercentral.com/articles/sp_who2/70222/
Or you might check into WhoIsActive: http://sqlblog.com/blogs/adam_machanic/archive/2009/03/30/who-is-active-v8-40-now-with-delta-power.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply