Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 ACTIVITY MONITOR

Author  Topic 

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2011-07-25 : 23:22:49
Like wise in 2005 Server we find the ACTIVITY MONITOR under the Maintenance Plan Node under SSMS.

In Similar way, how do we can find the same ACTIVITY MONITOR in 2008 R2 Version under SSMS.

Thanks

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-07-26 : 13:15:24
http://msdn.microsoft.com/en-us/library/ms175518.aspx
Go to Top of Page

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2011-07-26 : 19:10:59
Thanks Peter.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-26 : 19:36:46
The activity monitor sucks. Much better to use sysprocesses, sp_who/sp_who2, sp_whoisactive, sp_lock, etc.

The old activity monitor was so much better in 2000, not sure why they replaced it with this useless tool.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2011-07-27 : 17:06:32
quote:
Originally posted by tkizer

The activity monitor sucks.
Amen!

=======================================
I have never met a man so ignorant that I couldn't learn something from him. -Galileo Galilei, physicist and astronomer (1564-1642)
Go to Top of Page
   

- Advertisement -