|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2000 Uber Monitoring Tools - a request for infoI am looking to evaluate SQL Server 2000 monitoring tools for the SQL Server setup we have here. I have been looking at various tools however I was wondering if anyone out there knows of any tools that will automatically do the following tasks that are currently performed manually (i.e. - Me, every morning!): * Check all SQL Servers are up and running * Check all SQL Server Agents are running * Check database status (egg - flag for corrupt or 'In Load' db's) * Check for deadlocking * Check SQL Server error logs * Check all SQL jobs for any errors. * Monitor any replication, log shipping, etc I know people will say that SQL Server does these things already and that I should stop being lazy, however trying to "eyeball" over 30 servers that contain over 20 databases and their related jobs can be quite time consuming. Basically what would be ideal would be a tool that a report can be run once a day (or on demand) that can inform me the status of the servers/database and any errors that I can quickly deal with as well as the points mentioned. Many thanks qh quackhandle1***@yahoo.co.uk wrote:
Show quote > Hi, You may want to check out Quest's new Spotlight on SQL Server Enterprise > > I am looking to evaluate SQL Server 2000 monitoring tools for the SQL > Server setup we have here. I have been looking at various tools > however I was wondering if anyone out there knows of any tools that > will automatically do the following tasks that are currently performed > manually (i.e. - Me, every morning!): > > * Check all SQL Servers are up and running > * Check all SQL Server Agents are running > * Check database status (egg - flag for corrupt or 'In Load' db's) > * Check for deadlocking > * Check SQL Server error logs > * Check all SQL jobs for any errors. > * Monitor any replication, log shipping, etc > > I know people will say that SQL Server does these things already and > that I should stop being lazy, however trying to "eyeball" over 30 > servers that contain over 20 databases and their related jobs can be > quite time consuming. Basically what would be ideal would be a tool > that a report can be run once a day (or on demand) that can inform me > the status of the servers/database and any errors that I can quickly > deal with as well as the points mentioned. > > Many thanks > > qh which will be released very soon. It provides a single dashboard for all your SQL Servers. If you'd like, I can put you in touch with one of our engineers for more information about the product and get you a demo. I am affiliated with Quest Software. Email me directly (take the nospam out of the email address) and I'll put you in touch with the correct person. -- David Gugick - SQL Server MVP Quest Software not a quick answer , but I would definately look @ DMO which can be accessed
using VBScrip via COMt. Very useful for doing "For Each" type of functionality you want Bit of a learning curve but worth the investment Also MOM is quite good for this , but I'm guessing too much of an invesment for 30 servers. cheers, Andy. <quackhandle1***@yahoo.co.uk> wrote in message news:1140710861.936265.229580@z34g2000cwc.googlegroups.com... tools for the SQL> Hi, > > I am looking to evaluate SQL Server 2000 monitoring Show quote > Server setup we have here. I have been looking at various tools however > I was wondering if anyone out there knows of any tools that will > automatically do the following tasks that are currently performed > manually (i.e. - Me, every morning!): > > * Check all SQL Servers are up and running > * Check all SQL Server Agents are running > * Check database status (egg - flag for corrupt or 'In Load' db's) > * Check for deadlocking > * Check SQL Server error logs > * Check all SQL jobs for any errors. > * Monitor any replication, log shipping, etc > > I know people will say that SQL Server does these things already and > that I should stop being lazy, however trying to "eyeball" over 30 > servers that contain over 20 databases and their related jobs can be > quite time consuming. Basically what would be ideal would be a tool > that a report can be run once a day (or on demand) that can inform me > the status of the servers/database and any errors that I can quickly > deal with as well as the points mentioned. > > Many thanks > > qh >  |
|||||||||||||||||||||||
Other interesting topics