Great article!! And thanks for the plug of my Blog. :smooooth:

noeld (10/5/2007)

These communities help all of us. I've learned a lot by helping people figure out solutions to problems they were experiencing. If all you learn is what you experience, you...

That specific error is actually referring to latches on memory spaces in the buffer. Basically, SQL Server is removing shared objects (cached query plans) that objects have a latch (a...

PSS = Product Support Services. Basically, it's Microsoft SQL Server support.

I agree with checking for blocking first, but I'm surprised that two of the most fundamental things aren't even listed: check the SQL log for unreported errors and check the...

A couple of changes that I'd like to see made in the tool in a future release:

1. The application is listed as ".Net SqlClient Data Provider". Would prefer to see it's...

There are not 59 minutes and 59 seconds in hour #1. There isn't even 59 minutes, 59.9999 seconds. There is 60 seconds in a minute and 60 minutes in an...

Why are you defaulting to 59 minutes if the process was running before the hour started and finished after the hour ended?

A process that is already running at 12:00 and...

If nothing else, it certainly was a thought-provoking, compelling article. Very few of these things even come close to double digit pages of responses.

Yeah, I understand that. I'm assuming that recovery from tape is a fairly fast process for you. For myself, the department that handles tape backups has a 2 week SLA...

I abhor doing backups and restores over the network, but they do not always fail. I definitely agree that for large databases, you should backup locally onto a separate disk...

Actually, the directions do state quite implicitly that it can only fall into one category. It uses the word "substitute". When you substitute for something, the original thing is no...

Your list doesn't include the DefaultData and DefaultLog entries in it.

These are the only values I read or set on a regular basis:

Exec

xp_instance_regread N'HKEY_LOCAL_MACHINE'

Was there anything in the PERL script that couldn't be accomplished with xp_instance_regread and xp_instance_regwrite?