Microsoft SQL Server Error Log Scanning

Question

Microsoft SQL Server Error Log Scanning

Viewing 5 posts - 31 through 34 (of 34 total)

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

Charles Kincaid SSChampion Points: 13593 More actions · Answer 1

In fact sp_readerrorlog actually calls xp_readerrorlog.

Hey Rudy. Great article. Thanks for firing this off.

I put everything into a single script file, replaced the cursor with the update and changed the query exclusions to DELETE statement. If you don't want to see stuff then gone is good. It's only the local table anyway. I could have made one complicated delete but I chose maintainability over performance. I also reformatted some statements to be in line with our corporate SQL statement style standards. Update script is attached

We gave SSIS the heave ho sometime back. Long story. Some of our clients are on Express so I can't always use the agent stuff. We have gotten to be wizards at cheap and effective. I use Windows command files that use OSQL to run scripts. Some are as simple as executing a stored procedure. We then use the task scheduler to fire those off

ATBCharles Kincaid

Rudy Panigas SSChampion Points: 10702 More actions · Answer 2

Hello everyone,

Thanks for the feed back! Glad to see others are talking about this script and modifying it to fit their needs.

As for the issue with xp_readerrorlog, I have not encountered this issue on all our SQL servers (SQL 2005- SQL 2014CTP). We have all our SQL servers up to the latest SP and CU patches.

Thanks,

Rudy

alanspeckman Hall of Fame Points: 3344 More actions · Answer 3

Great article, thank you for sharing.

Here is another resource. Jonathan Kehayias creates a sproc for doing errorlog scanning as well.

http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ErrorLogMon

Here is a presentation given on performance metric collection with SSIS. This presentation is being given this Saturday at SQL Saturday.

http://www.sqlsaturday.com/viewsession.aspx?sat=246&sessionid=16453

Al

gary1 SSC-Insane Points: 21152 More actions · Answer 4

Hi Rudy,

Can you also include alert mechanism to send the error detail in an email so that DBA can quickly act on it?

Thanks,

Gary

Rudy Panigas SSChampion Points: 10702 More actions · Answer 5

gary1 (9/7/2013)
Hi Rudy,
Can you also include alert mechanism to send the error detail in an email so that DBA can quickly act on it?
Thanks,
Gary

Hello Gary,

Since I have a different process that collects other information and alerts on it, I don't have an alert mechanism for this code but you can created one to fit your needs.

Thanks,

Rudy