Browse by Tags

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://blogs.technet.com/b/askperf/archive/2012/03/06...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Mon, Mar 12 2012
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 through a remote server to send out email from...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Nov 22 2011
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 own this procedure can't actually be used...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Mon, Nov 21 2011
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 when the system picked up I had some interesting...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, May 17 2011
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 tables don't actually contain any data...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Jul 28 2010
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 of Foreign Key constraints on a table, now FKs...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Jun 16 2010
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 to me ? However the response was somewhat...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Sat, May 15 2010
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 site some years ago.I had to get hands on with IIS5...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Mon, May 3 2010
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 the production server for the past 4 years I guess...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Mar 23 2010
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 despite my best efforts this just wasn't happening...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Feb 10 2010

Page 1 of 6 (51 items) 1 2 3 4 5 Next > ... Last »