SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cursor Peformance
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Brittney10
Posting Yak Master

USA
152 Posts

Posted - 06/28/2013 :  11:57:18  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 06/28/2013 :  12:10:57  Show Profile  Reply with Quote
where the statistics of tables upto date on both servers? ALso are indexes similar between them?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Brittney10
Posting Yak Master

USA
152 Posts

Posted - 06/28/2013 :  12:32:31  Show Profile  Reply with Quote
Indexes are the same. Stats appear the same, as well.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/28/2013 :  12:51:58  Show Profile  Reply with Quote
wat about server versions?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Brittney10
Posting Yak Master

USA
152 Posts

Posted - 06/28/2013 :  13:04:44  Show Profile  Reply with Quote
Server is exactly the same during both cursor update processes.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/28/2013 :  13:23:59  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000