March 9, 2015 at 4:17 pm
Hello,
during msSQL backup we see the disk activity is using 99% approximately 650mb/s , which is using all the RAID 10 speed causing some slowdown with other queries running during the backup.
Currently that setup with 4x 256GB Samsung SSD 840 PRO with 1 partition containing OS/data/logs. If I create more logical partition from this Array would it fix that 99% activity or there is something to limit the backup disk activity to 50% ?
March 10, 2015 at 5:10 am
bissagars (3/9/2015)
Hello,during msSQL backup we see the disk activity is using 99% approximately 650mb/s , which is using all the RAID 10 speed causing some slowdown with other queries running during the backup.
Currently that setup with 4x 256GB Samsung SSD 840 PRO with 1 partition containing OS/data/logs. If I create more logical partition from this Array would it fix that 99% activity or there is something to limit the backup disk activity to 50% ?
Creating more logical partitions wont help at all. During the read phase of the backup it will be consuming pages at a hell of a rate, if you have logs on the same array you'll encounter read\write contention
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2015 at 5:43 am
so it is better to create 2x RAID 1 Array and separate the data/logs and make the daily backup on the physical array which is doing write activity only?
I don't need the speed of RAID 10 as our buffer I/O cumulative time is 550ms in a production database with 4 days online
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply