I am no SQL expert, but I wonder if some of the queries couldn't be talking to the 29 databases left on the physical server. In that case, you'd see a performance problem I bet. Also, we...
See more...
I am no SQL expert, but I wonder if some of the queries couldn't be talking to the 29 databases left on the physical server. In that case, you'd see a performance problem I bet. Also, we have what I would call a fairly large SQL 2005 DB on a win 2003 box, I want to say 15 GB in size, running on a physical box with dual quad cores, 16GB RAM. Way overkill you would think. It still pegs out all 8 "CPUs" at 100% with one particularly nasty crystal report that query the dog out of it. To give our DB admin / crystal person credit, that same report we inherited used to take 10 minutes to run before our person cleaned it up. Now it takes a good minute or 3 depending on what the server is doing otherwise. So my idea would be to move that virtualized DB back to a physical server... but NOT the same one with the other 29 DBs. See if it runs crappy there.