Processed 405535 pages for database ‘AdventureWorks2012’, file ‘AdventureWorks2012_Log’ on file 1.īACKUP DATABASE successfully processed 598423 pages in 152.066 seconds (30.744 MB/sec). NAME = N’HC_TST-Full Database Backup’, SKIP, COMPRESSION, NOREWIND, NOUNLOAD, STATS = 10 TO DISK = N’d:\Backup\Test.bak’ WITH INIT, We started out using a basic backup command… Nothing fancy, and we got 22MB/s, so not that great either. Processed 405530 pages for database ‘AdventureWorks2012’, file ‘AdventureWorks2012_Log’ on file 1.īACKUP DATABASE successfully processed 598418 pages in 211.441 seconds (22.110 MB/sec). Processed 192888 pages for database ‘AdventureWorks2012’, file ‘AdventureWorks2012_Data’ on file 1. NAME = N’HC_TST-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10 TO DISK = N’d:\Backup\Test.bak’ WITH NOFORMAT, NOINIT, Database : AdventureWorks increased several times up till 1,5GB ( using a set of SQL commands by Jonathan Kehayias), compared to the 250MB.Backup destination used was the temporary drive (D). Paths : SQL Binaries, Data & Log files on Z-drive.Storage : Z-drive, based upon storage spaces, with one disk (100GB / LRS / Standard).What is the test environment we’ll be using? In light of the experience we had on that case, I went into my lab environment to test the impact of different parameters… A while ago we experienced an issue with slow backup performance on an Azure VM.
0 kommentar(er)
