Activity Moniotor - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Activity Moniotor

Author

Topic

datosiva
Starting Member

18 Posts

Posted - 2010-10-12 : 01:50:13

Dear sifu's

Need you assistants.
Running SQL2008. How to view the Activity Monitor thru the Management Studio. I cant find it in.

shiva :)

Hugh
Starting Member

1 Post

Posted - 2010-10-12 : 10:25:12

Hello,

Assuming you are using SSMS, then look at the tool bar right below the menus. On the far right hand side is the icon for the activity monitor. It is only visible if there is a query window visible, so that might have been why you could not find it.

I am a developer so I can afford to be a musician.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-12 : 11:31:05

or just use sp_who2

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-12 : 12:54:04

I hate SSMS 2008's Activity Monitor! I refuse to use it. I'll either use sp_who2 or write my own query via master..sysprocesses. SSMS 2005's Activity Monitor was good. I did use it sometimes, but I'd still go to sp_who2/sysprocesses for further digging.

Here's my most frequent query:
select * from master..sysprocesses where blocked <> 0

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

Subscribe to my blog

datosiva
Starting Member

18 Posts

Posted - 2010-10-13 : 08:40:43

Thank you sifu's. you are simply superbb

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-13 : 13:20:50

Does sifu mean master/teacher/instructor? I had to google it. It was too close to STFU, which is derogatory, so I had to look it up.

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

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-13 : 13:25:08

lol. i googled it to. i think it means "master"

datosiva
Starting Member

18 Posts

Posted - 2010-10-27 : 23:31:50

Yes SIFU means MASTER (Chinese language)
thanks once again sifu

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2010-10-28 : 00:05:21

2008 activity monitor was in response to oracle's version of the same thing I think. I agree it sucks.

far better than sp_who2 is Adam Machanic's sp_whoisactive, I have it on all my servers. it's awesome.

http://sqlblog.com/blogs/adam_machanic/archive/2010/10/21/who-is-active-v10-00-dmv-monitoring-made-easy.aspx

elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources