November 20, 2002 at 5:06 pm
Hi everyone, I have some processes that run very slow. One thing that is confusing me about those processes is that in EM under Process Info, there is a Memory Usage column. For all of these processes they are zero, which is odd since these processes are actually quite large. They declare many variables, do many updates and inserts and call other processes. Please advise. Thank you.
November 20, 2002 at 5:49 pm
I just ran a sproc guaranteed to delivery a hit and nothing showed up in 'Process Info'. Try using Performance Monitor instead. A good article to get started can be found at:
http://www.sql-server-performance.com/sql_server_performance_audit2.asp
Everett Wilson
ewilson10@yahoo.com
November 20, 2002 at 7:29 pm
Keep in mind you have to refresh the Current Acitivty manually, it is not auto updating and does not reoccurr each time you open. You must right click on Current Acitivity to update. Also, that value is cumulative for a connection not just a process and once the connection clears the value is gone. Process Info is good for long running processes, blocking, and basic connection stats (like sp_who or sp_who2) but not much otherwise. For better stats on a process use Profiler instead.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply