Red Gate forums :: View topic - SQL Backup Performance Difference between 32bit to 64bit
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

SQL Backup Performance Difference between 32bit to 64bit

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
integragroup



Joined: 29 Dec 2011
Posts: 4

PostPosted: Mon Jan 23, 2012 3:44 pm    Post subject: SQL Backup Performance Difference between 32bit to 64bit Reply with quote

We are trying to understand a performance difference we noticed when recently moved from SQL 2000 (32bit) to SQL 2008 R2 (64bit).

A db that is 105GB was taking 2 1/2 hours to backup to a network drive. This was on a dell 2950 with 4GB and Windows 2003. SQL Backup that latest available.

We moved this db to a dell 2850 with 16GB of ram and Windows 2008 R2 as well as SQL Server 2008 R2. The db has grown to 108 GB during this time, however the backups are now taking 5 hours and 40 minutes.

I understand that a 2950 is a little newer/faster than the 2850, however both have GB nic and both were writing to the same NAS share therefore the two differences we have identified are the 64bit and the 2850.

Any insight on how to approach this SQL Backup wise would be appreciated. We have plans to put Windows 2008 R2 and SQL Server 2008 R2 on the 2950 to run a test if nothing else materializes to see what may be going on. The 2850 has dual (dual core) 3.2GHz processors as well as the 2950 has dual (dual core) 2.00GHz 5130s...
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Tue Jan 24, 2012 3:52 pm    Post subject: Reply with quote

In the SQL Backup help file, look for the 'Optimizing backup speed' topic. Try running the stage 1 and 2 tests, and see if they differ significantly between the 2 servers.

Also, what version of the SQL Backup Agent are you running, as returned by the following:

Code:
DECLARE @version NVARCHAR(32)
EXEC master..sqbutility 1030, @version OUTPUT
SELECT @version

_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group