Ran a benchmarking-query on the VM after rebuilding indexes. Results from Showcontig was GREAT etc. The query took 54 secs. I didnt DARE to reset the...
Why oh why didnt we get a seperate RAID10 setup for the MDFs :(. Havent gotten an oppurunty to actually do a REINDEX but the INDEXDEFRAG helped a...
Can I trust the performance monitor results when its running on VMware? The server is virtual : /. We tried benchmarking the hardware since theyre...
1 processor, Im not sure how to check MAXDOP, but its apparantly 5 min query plan threshhold to concider paralell execution (not sure if its even...
We have plenty of resources on the machines. I can't really do anything about the hardware except maintenance. Is there any good way of...
1. SQL 2000 SP 4 2. None really, a reboot of the computer is probably the biggest maintenance job we run. 3. Autoupdate is on. 4. Yes, and...
Hello there! First of all, I've been scouring these forums for a while so I guess I owe you all a thank you for all the great information you have...
Separate names with a comma.
