SQL monitoring

[SQLScholar]

Hey all,

I am really starting to get concerned that one of our servers is under alot of strain.

I know this has been asked before - as i found some answers, but i have a slight spin on it.

I want a piece of software to monitor SQL server in terms of

Memory usage
CPU usage
Network usage

But also SQL specifics such as table locks etc.

I have tried some other tools on trial - but the ones i have tried (for instance SQL Spy) i am not really sure what the information given means.

What i really need is something will just simply tell me if anything is being pushed too much - and what it is.

I will happly pay for the program if not too expensive.

many thanks all

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mutley1]

I used to use Spotlight by Quest Software. Probably still a free trial version on their site.

http://www.quest.com

That is real time monitoring - they have another product called Foglight which keeps historic data of counters etc. and can have thresholds set to email warnings / alerts etc.

Cant remember the cost though.

HTH,

M.

 

[ptheriault]

I use SQL diagnostics manager by Idera. It keeps both realtime and history. It also give database growth stats down to the table level. It can also monitor for alert thresholds and send an email. For example, I check for jobs that run 130% longer than the last time and send an alert. Or if there is blocking for longer that 300 sec it will notify my. It gives every Server, OS and SQL statistic I can think of.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Catadmin]

Why can't you just use a combination of Profiler and Performance Monitor (part of your Windows Server OS)? It'll save you the trouble of buying a new program.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"