I find the StarInix tool quite good (freeware).

There is no need to reboot regularly (unless you have a memory leak in Windows).

It could be a bad execution plan issue, with the execution plan flushed out of cache...

Hi,

You could use sp_OA* however these are not much better!

CLR is generally used in SQL 2005 (from my experience) by developers to replace much of the functionality that xp_cmdshell...

Hi,

The connections don't 'close' in sleeping mode- you would need to 'kill' them.

You could kill all the processes that aren't system processes, but why do you want to 'close' them?

Have you been through this list:

http://support.microsoft.com/kb/907284

The splitting of install folders into 'Servers' and 'tools' fixes many installation errors from my experience (if you are copying from network/msdn install...

Flash memory is MUCH faster than disk, no moving parts...but still too expensive for most organisations.

ps. I hope we're talking solid state hard drives, rather than sticking a flash drive...

I haven't tried it, but have seen an expensive server running solid state hard drives. Unbelievable the I/Os per second the server was achieving!

There is some debate whether tuning...

Hi,

Without knowing your database structure, you could create new databases based on date ranges and create an archiving job that will delete from the current database and insert into the...

You can use Affinity mask. From my experience, SQL Server performed better when i left SQL Server to automatically set the affinity...

By the way, Microsoft engineers that I have spoken to advise heavily against running 3Gb switch for SQL Servers.

It makes sense...what Microsoft operating system these days will run effectively...

Ideally I would use perfmon for benchmarks, especially disk counters (avg disk read/write) and memory, CPU, Network utilisation.

It may be worth asking your server guys to send server logs to the vendor for analysis also. I have seen this happen before due to a bad firmware version...

I'm finding this happening on one of our databases that is set to auto close. I'm guessing the 'ping' that MOM does doesn't actually wake up the database...and MOM thinks...