Activity Monitor

I'm using SQL Server Management Studio 2005 ver 9.00.  I can't seem to find Activity Monitor.  Even using Control-Alt-A doesn't bring it up.
xmouserAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jagdish DevakuSr DB ArchitectCommented:
Hi

Please check it under Management after you login to SQL Server.

The user might not have permissions... please check the following..

To view the Activity Monitor in SQL Server 2005, a user must have VIEW SERVER STATE permission.

To view the Activity Monitor on a SQL Server 2000 server, a user must have SELECT permission to the sysprocesses and syslocks tables in the master database. Permission to view these tables is granted by default to the public database role.

To KILL a process, a user must be a member of the sysadmin or processadmin fixed server roles.

If the issue still persists, please give the exact error you are facing...

Bye...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
xmouserAuthor Commented:
Please check it under Management after you login to SQL Server.
*Don't see that

To view the Activity Monitor in SQL Server 2005, a user must have VIEW SERVER STATE permission.
*I have that permission

If the issue still persists, please give the exact error you are facing...
*No error message, I just can't find activity monitor
0
xmouserAuthor Commented:
JagdishDevaku:

Found it under Management.
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.