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 2000 Forums
 SQL Server Administration (2000)
 Eye Candy

Author  Topic 

jason
Posting Yak Master

164 Posts

Posted - 2005-03-17 : 15:07:12
Are there any monitoring utilities out there that provide you with a graphical interface for monitoring SQL server activity? In my mind's eye, I would like something like a bar chart by user/spid that provides views of cpu, memory, and I/O. I realize EM provides a accumulated view of this and it is possible to produce this info in QA.

Kristen
Test

22859 Posts

Posted - 2005-03-17 : 15:17:27
Performance Monitor?

Kristen
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-03-17 : 15:35:40
There are some out there. I can't find them right now, but they do exists. They are usually HELLA expensive though.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-03-17 : 15:57:29
Quest has spotlight, BMC has dbxray and idera has sqlcheck.

You can download all of these to test out. I think the idera product is free though.



-ec
Go to Top of Page

jason
Posting Yak Master

164 Posts

Posted - 2005-03-17 : 16:23:42
thx ec, I'm downloading...
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-03-17 : 17:04:48
You should start with Performance Monitor. It's free, it's already installed, and it's easy to use.

quote:
Originally posted by jason

Are there any monitoring utilities out there that provide you with a graphical interface for monitoring SQL server activity? In my mind's eye, I would like something like a bar chart by user/spid that provides views of cpu, memory, and I/O. I realize EM provides a accumulated view of this and it is possible to produce this info in QA.



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -