Browse by Tags

All Tags » Monitoring (RSS)

Oh the irony of it all !!

In my previous post I mentioned what I see as a fatal flaw with the “Alert on Error” scenario, well no sooner posted than to quote Shakespeare “hoisted by my own petard” HA!  I have a log shipped setup where the server communicates alerts using smtp...
Posted by GrumpyOldDBA | with no comments

How's your email today ? No Alerts ?

When I first started as a SQL Server DBA / Developer in 1995 working with SQL Server 6.x one of the key steps was to set up alerting and monitoring. I was working for a very rapidly growing mortgage provider and DR, monitoring and performance were critical...

A follow up to yesterday

As I have been asked,  here to tidy up yesterdays post is the procedure my startup procedure calls along with the logging table deployed in the DBA database. Just to muddy the water further I have routines for remotely calling the DBAMessages table...
Posted by GrumpyOldDBA | with no comments

A New Record ( How many noughts ????????? )

I have to say I thought I’d seen it all but this last week brought an event of such magnitude I may be contacting the Guinness Book of Records. OK that’s not true, but I’d like to! One of our production systems has to support a certain element of real...

SSMS Built in Reports for Server and Database Monitoring

This is a long post which I hope will format correctly – I’ve placed a pdf version for download here  http://www.grumpyolddba.co.uk/sql2008/ssmsreports_grumpyolddba.pdf I sometimes discover that the built in reports for SQL Server within SSMS are...