Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Customizable Error Log Scanning Expand / Collapse
Author
Message
Posted Tuesday, December 12, 2006 9:44 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:50 AM
Points: 2,906, Visits: 467
Comments posted here are about the content posted at temp

----------------------
http://thomaslarock.com
Post #330025
Posted Wednesday, December 27, 2006 7:01 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, November 17, 2010 3:38 AM
Points: 445, Visits: 82
Thanks for the nice script.


Post #332929
Posted Wednesday, December 27, 2006 8:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 31, 2007 8:22 AM
Points: 92, Visits: 1
Excellent article. Thanks for sharing.
Post #332949
Posted Wednesday, December 27, 2006 10:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 10:54 PM
Points: 26, Visits: 74
This is another good example of a script to add to my "toolbox". Thanks and keep them coming.
Post #332997
Posted Thursday, December 28, 2006 4:04 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 6, 2014 2:10 PM
Points: 96, Visits: 67

Wonderfull , this show that wat great factor shoub be noted by any DBA hows its important , keeep it up

Post #333118
Posted Thursday, December 28, 2006 4:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 24, 2013 10:38 AM
Points: 26, Visits: 82

Great Idea, this thought pattern can be used in other area's too.
I would give my left leg for a method of dumping out Server EVT's parsing them cleaning them and then letting me know if anythings' gone wrong.

Without me having to lift a finger.

Post #333125
Posted Thursday, December 28, 2006 5:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 25, 2012 8:14 AM
Points: 6, Visits: 91
i need a new left leg

http://www.sql-server-performance.com/rvb_processing_event%20_logs.asp



Post #333127
Posted Thursday, December 28, 2006 1:29 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, August 18, 2014 11:11 AM
Points: 596, Visits: 1,687

Haven't found the problem yet but even after putting a "WARNING" message in my log, I'm still getting  No Errors in the Error Logs

I thought the use of character fields for the Error_Date fields could be a problem but now I don't think so. Must be something in  Usp_Errorlog_Notification

RAISERROR ('WARNING', 16, 1) with log




Post #333281
Posted Friday, December 29, 2006 9:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:50 AM
Points: 2,906, Visits: 467

All,

The version of the proc I included is incorrect, and I will ask Steve to post a new zip file with the updated code. Essentially when the delete happens based upon the date, we used to have a convert statement and we lost that during one of the last frantic rewrites as we tried to get things working for SS2K5.

Anyway, the key is to have this line:

delete #Errors from #Errors eTmp where vchLogDate <= @MxDateDel

changed to this:

delete #Errors from #Errors eTmp where convert(datetime,vchLogDate) <= convert(datetime,@MxDateDel)

That should avoid the problem you are seeing right now, i believe. Also, when in doubt, we sometime will flush the ErrorsP1 table with a truncate statement in order to see if that helps things flow through again.

Let me know if there are any other issues with the code so that I can research it immediately.

tom

 



----------------------
http://thomaslarock.com
Post #333475
Posted Friday, December 29, 2006 2:17 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, August 18, 2014 11:11 AM
Points: 596, Visits: 1,687

I also changed this line to convert char to datetime -- before that I was getting lots of very old log entries emailed to me. 

-- next, find the current max date in the ErrorsP1 table

Select @MxDateDel = max(convert(datetime,Error_date)) from ErrorsP1

Also removed "login failed for user" from ErrorlogScanExclude table because I don't get many and wanted to see them.

INSERT INTO dbo.ErrorlogScanExclude ( Excludekeyword )
   VALUES ( 'Login failed for user' )
go



Post #333562
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse