Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
plsqldev
Starting Member
11 Posts |
 Posted - 2011-10-24 : 10:49:32
|
| we have two servers pre production and productions. has almost same data. when we ran a procedure in it is returning some data in pre prodution but not in prodution.It has performance issue in prodution. indexes are same in both envirnoments. can any one suggest me the solution.Thank you in advannce. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-24 : 11:18:28
|
| are statistics up to date in both? is there some other processes running in parallel and blocking it? have a look at sp_who2 to understand if any blocks are happening------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-24 : 13:10:46
|
| Not returning data <> performance issue. You said data in both environment were "almost" same but not exact. It's quite possible that the data you are fetching using your SP doesnt exist in production. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-11-12 : 05:32:14
|
| Is one database the same as the other ,regarding : data and indexesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
james_wells
Yak Posting Veteran
55 Posts |
Posted - 2011-11-20 : 11:33:32
|
| if your code is only fecthing data execute the code on pre-prod against the data on production and visa versa. (You may have too set up linked servers and enable RPC etc..)If its a data issue then the production server will now bring back the data and the pre-prod will not. |
|
|
|
|
|
|
Performance issue