Browse by Tags

All Tags » Diagnostics (RSS)
22 November 2011 22:02

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
Filed under: , ,
21 November 2011 20:12

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
Filed under: , ,
17 May 2011 16:59

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:
28 July 2010 13:28

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...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
16 June 2010 20:15

So which null equals this null, that null? maybe this null, or is it this null?

Tuning takes many routes and I get into some interesting situations and often make some exciting finds, see http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/17/just-when-you-thought-it-was-safe.aspx for an example. Today I encountered a multitude...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
15 May 2010 12:20

Did I back that file up ?

As part of some diagnostics I was wishing to check if a particular file had been locked by a backup process whilst I was trying to copy it. So I put a request into the DataCentre for a list of files backed up and time when they were backed up, seems reasonable...
Posted by GrumpyOldDBA | 19 comment(s)
Filed under: ,
03 May 2010 15:38

w WARN: Thread pool pressure. Using current thread for a work item.

The skill set needed by a DBA can be quite diverse at times and a run in with SSRS 2005 probably illustrates the point quite well. I don't have skills in IIS although I was responsible for the design and deployment of an online mortage application...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
23 March 2010 19:33

Cursors 1 Sets 0

I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
10 February 2010 12:09

Print vs Select - security through obscurity ?

Now here's an interesting snippet which I'm sure will provoke a few " ... and you didn't know that! " comments. I wanted to take the output from a stored procedure into a table using the insert into mytable exec proc; command but...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
17 August 2009 18:59

Windows 2008 build fun and games.

I run a number of test servers at home, these are technically PCs running a server o/s, these currently number 6. I generally build these myself with a base spec of supporting 8GB ram in 4 slots, a minimum of a dual core proc and at least one x16 pci...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
More Posts Next page »