Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Query running slow in Production and fast in Test environment Expand / Collapse
Author
Message
Posted Friday, January 31, 2014 8:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:21 PM
Points: 391, Visits: 1,937
Actual and estimated execution plan details are same in both environments.
Can any one please provide what should i be looking next.
The tables are very small not more than 10,000 rows.
Post #1536815
Posted Friday, January 31, 2014 8:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 12, 2014 8:21 AM
Points: 7, Visits: 46
IO statistics
Post #1536823
Posted Tuesday, February 4, 2014 4:40 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:41 PM
Points: 202, Visits: 568
have you updated statistics and or see any differences in execution plans compared to prod. Like compare the tasks in the execution plans with prod's.

also maybe prod has buffer cache and nonprod has no plan cache if it was recently restarted or restored new db. my guess
Post #1537987
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse