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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2008-02-19 : 00:32:04
|
Hi there Can you give me a light a bit regarding trouble shooting bulk load query that we have? We have a bulk upload with a business logic around it selecting and updating into multiple table. We ran the same bulk of load on production is really slow comparing with UAT. We're capturing data from start to finish and we've filtering the result and sort that by CPU. We found that the one of the query UPDATE PD SET LBNo=910005133 WHERE TNo=610787365 is returning :CPU: 19782 (19.782 seconds) Duration: 20657 (20.782 seconds)Reads: 47345 (47345 x 8192)Writes: 1Check the indexing for this table and there is an index for that field TNo (nonclustered, unique, primary key located on PRIMARY).Also, the index defrag (online) was kicked off (scheduled) for the entire database prior running to this as well as statistic update.Any ideas guys?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:17:23
|
| What does execution plan say? |
 |
|
|
|
|
|
Duration and Reads