I tried to re-establish a db replication which was being test a while ago, everything was ok untill I noticed that when I run a queyr on the destination server, the performance is extremely bad and even not usable. a report query that takes 30sec on another
server with similar specs will take 15min to finish!
I did a bit investigation and it revealed that the PAGEIOLATCH_SH waits is the dominant waits time, this led me to run a sqlio test.
the result of random write and random read test result appears to be normal compared to the other server I mentioned above.
at this stage, I am kind of running out of idea, can anyone provide any suggestion?
just to clarify, the problem still exists even after I deleted the replication.
View Complete Post