Would increasing RAM improve DB restore times

Question

Would increasing RAM improve DB restore times

arrjay

Hall of Fame

Points: 3455
More actions
May 20, 2015 at 2:23 am

#318243

Hi there - I understand that the disk I/O is the main performance bottleneck however if I increased available RAM would this improve database restore times?
Thanks!!
--------------------------------------------
Laughing in the face of contention...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

I highly doubt it. RESTORE is an I/O intensive operation and RAM plays a very secondary role in the process. Backup compression can help improve restore elapsed times. If you're using enteprise edition, piecemeal restores can also be a way to speed up the process.

-- Gianluca Sartori

arrjay Hall of Fame Points: 3455 More actions · Answer 2

Thats great, thanks.

So a restore will write to disk, and at a later date SQL will write the data to memory once the user starts querying the database?

Thanks again.

--------------------------------------------

Laughing in the face of contention...

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

arrjay (5/20/2015)
Thats great, thanks.
So a restore will write to disk, and at a later date SQL will write the data to memory once the user starts querying the database?
Thanks again.

Yes, that's how it works.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 4

You can also improve backup time by specifying in the backup statement the number of buffercount and maxtransfersize. Have a look at this article – http://www.sqlservercentral.com/blogs/dotnine-sql-server-and-more/2013/08/21/optimizing-sql-server-backup-and-restore/%5B/URL%5D

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

subramanian-357640 SSC Enthusiast Points: 171 More actions · Answer 5

Hi,

are you seeing any I/O latency during the restore operation.

Thanks