May 20, 2015 at 2:23 am
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...
May 20, 2015 at 3:20 am
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
May 20, 2015 at 3:24 am
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...
May 20, 2015 at 4:07 am
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 20, 2015 at 5:06 am
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://qa.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/
May 22, 2015 at 1:50 am
Hi,
are you seeing any I/O latency during the restore operation.
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply