This might be something that everyone else knows, but I was quite surprised the other day and thought I would share.
I had just added some new EBS volumes to a new SQL Server database EC2 instance in AWS. See, I like to add 2 or 4 higher IOPS drives to database servers and then use the OS to put them in a RAID 0 stripe(s) for data files (and TempDB if I don’t have an ephemeral SSD handy. But perhaps that’s a post for another day…).
While configuring these new drives into an array I somewhat inadvertently ended up in the Properties dialog for one of the drives. Since I was there, I thought I would check things out.
The drive’s Removal policy was, by default, “Quick Removal.” This doesn’t strike me as the key to ultimate performance! This is how you treat external USB drives.
I checked the other 3 drives and determine that 3 out of the 4 I had just added were Quick and the one was “Better performance.” I then spot checked a handful of other instances and found similar results. Needless to say, I set them all to “Better” and then carried on.
But now I’m curious: Why were they defaulting to “Quick removal”. Yet, why weren’t ALL sharing that default?
Anyways, something to watch for when provisioning a new Windows server. Seems that this would apply to any virtualization platform, not just AWS.