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 |
|
propanecan
Yak Posting Veteran
60 Posts |
 Posted - 2007-06-12 : 16:14:32
|
| I'm researching an update statement that is taking a longer time to run in production than one of our test environments. CPU time is very similar, but elapsed time is significantly longer in production than in TST. I'm trying to gather client statistics in both environments. It works successfully in TST, but for production I get no information. Anyone have ideas on this? Thanks. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-12 : 16:20:19
|
| Does your prod table have more data (significantly higher as in millions vs thousands) compared to your test machine? Are the indexes up to date on the prod ? Also while you are running the update is the prod server live?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-06-12 : 16:29:48
|
| The test environment is a copy of PRD from last night. Indexes are up to date. The prd server is live. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-12 : 16:45:01
|
| Perhaps the activity on the prod server is contributing the longer execution time for this UPDATE? Also how do the execution times compare? You have not provided those details. Are we talking about a few milli sec's difference or is it into minutes?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-06-12 : 17:10:37
|
| Execution time in TST:SQL Server Execution Times: CPU time = 0 ms, elapsed time = 0 ms.Execution time in PRD:SQL Server Execution Times: CPU time = 0 ms, elapsed time = 100161 ms.I believe you are correct in assuming that the production activity is contributing to the longer elapsed times. My main question really is why I'm not seeing any values when I trace client statistics. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-12 : 17:19:23
|
| You should worry about the CPU time. The elapsed time varies depending on the load.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 20:44:18
|
| Any blocking issue on prod server? |
|
|
|
|
|
|
Client Statistics