Wish I had that 🙂

Only thing I can think of then is have perfmon running watching standard things like CPU, Hard Drive usage, as well as SQL counters until it...

Not sure if this applies to your specific PowerEdge/PERC model, but on the 2850's there's a firmware upgrade:

RAID_FRMW_LX_R169531

Fixes and Enhancements:

1. Fixed an issue of system lock ups and controller hangs...

That's alright 🙂

Run a sp_who2 now and again in an hour, see if the number of connections stays relatively the same. Try this every now and then and keep...

Do you have the latest SP on SQL installed?

In the performance monitor one thing you should definately be watching is the number of sql processor id's and connections.

Have the other technicians keep a query analyzer open with sp_who2...

Ross,

Thanks a ton for those commands. Helped me out a lot. BCP'd about 40million rows in like 10 minutes.

I used to have this problem a long time ago, had a program that would not close connections to SQL. Over time the number of connections (spids) would be...