Monitoring Production Instances.

#1

We will soon have 200 + production instances. In an effort to be more
pro active, I am looking for a way to monitor jobs, both failed and
long running, Disk space, and other such things like CPU load etc.
I would appreicate any suggestions you might have on accomplishing
this. For instance, is there anything in reporting services that might
help accomplish this ? Most of the instances are 2k, but we also have
some 2k5.
Best Regards
SGB

#2

(sgbergkam (AT) gmail (DOT) com) writes:

Quote:

We will soon have 200 + production instances. In an effort to be more
pro active, I am looking for a way to monitor jobs, both failed and
long running, Disk space, and other such things like CPU load etc.
I would appreicate any suggestions you might have on accomplishing
this. For instance, is there anything in reporting services that might
help accomplish this ? Most of the instances are 2k, but we also have
some 2k5.

I think you should look at MOM, Microsoft Operations Manager.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Monitoring Production Instances.

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Monitoring Production Instances. - 05-10-2006 , 04:48 PM

Re: Monitoring Production Instances. - 05-10-2006 , 05:00 PM