Slow RO AG Node

  • Running report on OLTP server of AG group sp runs in 4 seconds.  On AG RO node almost 2 minutes.  Looked at stats and they are vastly different for one table almost 10 times as many logical reads.  Indexes on primary rebuild every sunday, 2 different databases involved in the sp one about 100 gig the other about 12.  Any one seeing this on their AG RO node.  I was stunned at the stats difference

  • Duh missed the obvious some sysadmin took RO node from 48 gig to 7, so not comparable to OLTP node, please disregard, should have looked for obvious

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply