September 15, 2008 at 1:34 pm
Hi,
Does anyone have any suggestions or advice on the following products for monitoring SQL Servers for performance, stability, drive space, etc.?
Spotlight for SQL Server Enterprise
idera SQL Server diagnostic manager
Microsoft System Center Operations Manager
If there are others that are worth considering, I'd be grateful if you could post them as well.
Thanks for any help!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 15, 2008 at 5:13 pm
These days I use Performance Dashboard and my own home-grown scripts for monitoring (they're free and portable). However, I've used Idera's Diagnostic Manager in the past with great success.
September 15, 2008 at 8:26 pm
Pam Brisjar (9/15/2008)
These days I use Performance Dashboard and my own home-grown scripts for monitoring (they're free and portable). However, I've used Idera's Diagnostic Manager in the past with great success.
Thanks for the feedback. Are there any sites or links that show approximate price comparisons for the not-free tools?
Thanks again,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 15, 2008 at 8:35 pm
Are there any sites or links that show approximate price comparisons for the not-free tools?
Thanks again,
webrunner
I think SQL Server magazine has done some ratings of various tools.
Just call them up and get quotes and get the demo versions so you can test them out yourself. Idera often discounts their list price, so I wouldn't trust some 3rd party to give you good pricing info.
September 16, 2008 at 1:06 am
Ten Centuries,
Better to script it yourself.
By scripting it yourself you will get familiar with the sys-tables and you can extract just what you need.
Store it in a specially designed tablestructure and report counters either by select-to-file, e-mail or using Reporting Service (MS).
Create a method to "crawl" other servers as well using the LinkedServers mechanism and store the data in a local database a seperate server especially for this purpose (not to interfear with other load on any server).
Keep it light with as less overhead as possible (especially on heavy used server).
Better not install deamons or gathering databases on productie environments.
Mention agreements on security and processes within you company
Mention default settings such as sp_cmdshell / sp_OAxxxx procedures etc.
Need more info. . .contact me (cause I've written such a DB-monitor environment).
GKramer
The Netherlands
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply