Hello all, I have over 50+ SQL servers on my Data Center floor and was
wondering if anyone was aware of a tool or product thta could be used to
monitor SQL DB performance, growth and alert when there is a problem...

Thanks

if you have the time, write your own using wmi or smo, the functionality in
both these object models make it really easy to write your own custom
application.

Or u can use osql/sql cmd to run custom monitoring scripts where you can
DTS/ssis the results into a xls spreadsheet and mail to relevant parties with
the info.


Show quoteHide quote

Well, there are a several companies which are offering powerful tools in
order to do fast diagnostics and reliable reports and so forth...
Personally, I work in a big organization with around 8,000 employees and
1000 MSDE Sql Server and 30 o 40 Sql Server 6.5/7.0/2000 and here doesn't
exists nothing like that.
Show quoteHide quote

Show quote Hide quote

I have written a monitor tool that is very cheap and powerful called
DBMonitor.

The main selling point of this monitor over the other commercial ones is its
extremely small footprint.  Most refreshes of the information bearly
registers on the SQL Server it is monitoring.

It has email alerts for when the server has heavy loads, slow response times
or disconnects unexpectedly.

I am in the process of written the next version of it which has a better
interface plus more reporting of problems and information from the server.

You can find a copy of this application from the following address:
www.dbplussoftware.com

Sql Server Resetting Ansi_Nulls Setting
SysAdmin and ServerAdmin unable to start/stop or pause services
How much allocated space is actually used?
Read only and access to specific databases
Log Shipping
Updating records in one table from another
encrypting data in SQL table?
NEW B - {WildPacket}
Procedure to Stress Test
DB question