MS SQL Server - SQL Monitoring tools...

Author

SQL Monitoring tools...

fishoj

2006-03-14, 8:23 pm

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

Cube

2006-03-15, 3:23 am

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.

"fishoj" wrote:

> 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

Enric

2006-03-15, 11:23 am

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.
--
current location: alicante (es)

"fishoj" wrote:

> 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

Sponsored Links