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 |
|
Brittney10
Posting Yak Master
154 Posts |
 Posted - 2013-06-28 : 11:57:18
|
| I had two different databases that I ran a cursor update against, which was executed from an SSIS job. Both were allegedly the same database as far as schema, size, record counts, etc, but they were backups from different points in time (one from 3+ months ago and one from about a month ago). When I ran the cursor update against the 3+ month ago db, it took 6 hours to process. When I ran the cursor update against the one month database it took 45 minutes. Close to the same number of records were cursor-ed and updated. Also both databases were processed on the same server. Any ideas what could have caused this increase in performance or what perhaps could have accounted for the cursor processing time? Also, the only thing running on the server was the SSIS job and the cursor update. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-28 : 12:10:57
|
| where the statistics of tables upto date on both servers? ALso are indexes similar between them?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Brittney10
Posting Yak Master
154 Posts |
Posted - 2013-06-28 : 12:32:31
|
| Indexes are the same. Stats appear the same, as well. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-28 : 12:51:58
|
| wat about server versions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Brittney10
Posting Yak Master
154 Posts |
Posted - 2013-06-28 : 13:04:44
|
| Server is exactly the same during both cursor update processes. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-28 : 13:23:59
|
| it may be that in between the period the number of records which satisfied condition for cursor update got reduced due to intermediate transactions happening------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Cursor Peformance