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

Seven Monitoring Scripts Expand / Collapse
Author
Message
Posted Friday, May 13, 2005 7:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 23, 2012 3:01 PM
Points: 63, Visits: 43

Great scripts.  Very useful. 

 

Thanks

Vipul

Post #182236
Posted Sunday, May 15, 2005 11:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 18, 2011 5:52 PM
Points: 18, Visits: 16
Excellent.
Post #182539
Posted Monday, May 16, 2005 1:16 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: 2 days ago @ 5:24 PM
Points: 425, Visits: 539

Smart and simple.

I also find using sysjobs_view useful in place of sysjobs. Especially if you are managing more than one server.

The extra colum originating_Server can tell which server the job failed on.




Post #182548
Posted Monday, May 16, 2005 8:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 30, 2007 10:03 AM
Points: 2, Visits: 1

These scripts are very useful.

 




Post #182659
Posted Wednesday, July 20, 2005 5:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 10, 2010 9:43 PM
Points: 9, Visits: 34

sql monitoring tips are excelent. i expect more tips like that.

thax and regards

kiran

sql dba

Post #202704
Posted Monday, May 15, 2006 6:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 3:59 PM
Points: 5, Visits: 48

Another tip for xp_readerrorlog -- the first parameter is an integer that determines which error log to read.

xp_readerrorlog      -- current errorlog

xp_readerrorlog 1    -- most recent archived errorlog

xp_readerrorlog 2    -- etc.

Dave.

Post #279936
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse