sql server - Poor Performance on SPs and a Simple Query -


we have staging db (sql server 2012) vm , clustered production db (sql server 2008). both have same db schema. staging has little less data not difference.

recently notice production db 4-5 times slower staging when run same stored procedure on both. statistics io can see in general production db has lot more logical reads.

they both have same schema couldn't index issue. possible there's wrong memory on production?

updated

i notice in client statistics, staging db's "wait time on server replies" lower (8-12) production (160-170)

looking @ different angle: have taken @ actual execution plan see if can improve performance of query without taking account query executes faster on staging environment? (sometimes small changes in data can lead slower queries)


Comments

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

python - How to remove the Xframe Options header in django? -