Sunday, February 26, 2012

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items shown
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
--
Steven FergusonSteven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely to
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.com/sql_server_profiler_tips.asp
Hope this helps
John
"fergusons" wrote:
> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen under
> the Current Activity option in the Management folder there are no items shown
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

No comments:

Post a Comment