We have two instances on the same box and top wait times for each of them is as follows
Instance1 that is heavily used has following multiple lazywriter spids (from sp_who2) with CPU as follows
I also get several 15 second I/0 waits on instance1.
Please suggest some ways to troubleshoot this situation. Why am I seeing top wait stats different for both instance1 and instance2? Why am I seeing so many lazy writer spids with high CPU at any given time? Is bumping up/down of degree of parallelism on
the instance would help or degrade above stats?
View Complete Post