Browse by Tags

All Tags » Diagnostics (RSS)

Environmental Pollution

I did a number of posts under the heading “You couldn’t write it”  but in this case it had been so a different subject was required. We’d been looking at an issue which had allegedly been fixed but the testing seemed to present some problems indicating...
Posted by GrumpyOldDBA | with no comments

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...

Benchmarking Hardware and Environments

I suppose it would be fair to say I didn’t pick up the Grumpy Old DBA for no reason, as well as the usual paranoia of a Production DBA , distrust of almost anyone who wants to go near a database and possibly over protective nature regarding databases...
Posted by GrumpyOldDBA | with no comments

Community is Great

I have a great respect for so many who contribute to the community, without them I would often struggle in my role for sure. When "strange events" happen in a busy production environment it can be quite daunting when it seems everyone around...
Posted by GrumpyOldDBA | with no comments

Performance issues due to Inactive Terminal Server Ports

This is an interesting post and although I don't have any direct issues of performance with any of my Servers I can see the build up in the registry as described. If you make extensive use of DPR / TS sessions you might want to check this out http...
Posted by GrumpyOldDBA | with no comments

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

Hello it’s your server calling

This is nothing exciting but I've always found this startup procedure  very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's...
Posted by GrumpyOldDBA | with no comments

Scheduled Jobs on strike ??

I had an interesting situation with agent jobs stopping running without failure. I don't want to go into attempting to describe our infrastructure but siffice it say we had a few issues. None of my SQL Servers went down but there were problems and...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under:

An interesting annecdote

A while ago I blogged about using the dmvs to identify lookups and scans on tables http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/19/analysing-indexes-reducing-scans.aspx Well continuing on from this I had discovered that two of the top scanning...
More Posts Next page »