locked
Queries running very slow on read only replica (Sometimes getting timeout error) RRS feed

  • Question

  • Hi All,

    We are created read only replica on multiple databases to run reports.

    Sometimes reports getting time out Error....

    How can we resolve this issue, is there any other approaches to improve the report execution performance? 

    Thanks in Advance...

    Monday, July 18, 2016 6:49 AM

Answers

  • First of all you need to figure out the reason... Running the queries on a read only replica is under the hood doing the exact same thing it would do on the primary. With a few caviats of course.

    My first approach would be to start up Activity Monitor on the read replica, run one of the slow reports and see which wait types are showing up for the SPID. I would almost bet that you will see PAGEIOLATCH...

    Once you get the wait information please post it here so we can dig into that deeper.

    Monday, July 18, 2016 7:34 AM