Wht we need to Monitor in the Error Log.

Question

Post reply

Wht we need to Monitor in the Error Log.

Eshwaran

SSC Veteran

Points: 229
More actions
February 14, 2007 at 10:10 pm

#63045

Hi All,
This is Eshwaran. I have to automate the Monitoring of ErrorLog on all the 15 Prod boxes. How can i achieve this.
Pls find my questions ?
1. Can i Monitor using a batch File. Since my box is not configured with mail.
2. How can i export the errorlog of the each server into a table.
Pls let me as Soon as possible.

Thanks,
With Regards,
Eshwar.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135353 More actions · Answer 1

- What do you want to monitor about the errorlog ? Size or content ?

- we use a scheduled (sqlagent) job to start new errorlogs at least every week using DBCC errorlog

- to import the errorlog : (in this case in a temp table)

set nocount on

CREATE TABLE #ErrLog (SeqNo bigint identity(1,1) not null, LogDate datetime, ProcessInfo varchar(50), LogText varchar(max))

INSERT INTO #ErrLog (LogDate,ProcessInfo,LogText)

EXEC sp_readerrorlog

SELECT *

FROM #ErrLog

ORDER BY LogDate desc, SeqNo desc

drop table #ErrLog

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Eshwaran SSC Veteran Points: 229 More actions · Answer 2

HI,

I need to Monitor the Error Log contents for any new errors are there in the log. In Case of any new errors found the same has to send a alert msg to our oncall.

Johan Bijnens SSC Guru Points: 135353 More actions · Answer 3

you could use smtpmail in stead of sqlmail.

have a look at SQLDev.Net