April 29, 2009 at 6:25 am
Hi All,
Can some one help me in building a Simple SQL scripts which can be used to moniter the Error Log (Sql server)
As my monitering Tool does not read Stored Procredure.(its the drawback only sql statement).
If we have the Script, it can be used to ping the Server and any issues found then alert ..
Many Thanks,
Gagan,
April 29, 2009 at 8:15 am
It sounds like you just need to set up alerts in SQL Server. These do what you describe in your posts.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 29, 2009 at 8:41 am
gaganks (4/29/2009)
Hi All,Can some one help me in building a Simple SQL scripts which can be used to moniter the Error Log (Sql server)
As my monitering Tool does not read Stored Procredure.(its the drawback only sql statement).
If we have the Script, it can be used to ping the Server and any issues found then alert ..
Many Thanks,
Gagan,
Like Chris said, alerts are probably your best way to approach this. Between SQL Server and Performance Monitor, you should be able to set alerts for pretty much every situation you would want to be notified of.
April 29, 2009 at 10:07 am
I use this on all my production servers: http://www.sqlservercentral.com/articles/Administration/2757 It works great
Francis
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply