Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Throttling the CPU / Disk IO for SQL Restore Option RE: Throttling the CPU / Disk IO for SQL Restore Option

  • July 19, 2018 at 4:46 pm

    #1998320

    Sridhar-137443 - Thursday, July 19, 2018 3:58 PM

    Hi Sue,
    Thank you for your response. The databases are different sizes. The biggest one is 100 GB. Lot of them are over 50 GB. we are restoring the database from files in another server. The Dev server is AWS EC2 Instance (m4.large - 2 CPU, 8 GB RAM). I can copy the backup files to local drives if you think it would speed up the restore significantly. It is a dedicated SQL Server. We are not running anything other than SQL.

    Thanks for providing that - it really helps. With those database sizes, it really shouldn't be running forever. and pegging the server so bad. How many databases? And do you run all of the restores individually or all/a few at a time?
    You can ignore my comment on using the local drives - that would be more for an on-premise server.
    Where are the .bak files when you are restoring them? Are the .bak files on Amazon S3?

    Sue