I have about 15 databases running on a single instance of 2008 R2. It's a beefy box - 16 way with 64GB of RAM.
We process several databases at a time. Very often we'll see where a processing in one database will delay the processing in another database. The CPU is under 15%, RAM isn't nearly utilized, and there's no slowness on the disk.
My question is - why would one processing in a database delay the processing in another. No objects are shared between the databases.
It appears there is a server wide lock going on. Is this true? Why?
View Complete Post