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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy