April 23, 2014 at 2:12 pm
Hi -
Anyone running SQL Azure residing on SSD's?
I have a very volatile OLTP environment that we'll be splitting up between GeoLocations.
I've been speaking w/ AWS about spinning up a VM with a combination of the SSD's and their EBS storage.
I'm trying to determine what my options are with Azure. So - from what I see, A9 offers 16 cores, 112 GB RAM - what about storage?
Our current environment leverages local PCIe cards for temp db and a flash array for other database files.
April 23, 2014 at 3:28 pm
You're talking Azure VMs, not SQL Azure which is the platform as a service offering, not infrastructure.
As far as disks go, the only ones available currently are through Azure blob storage which is hard capped at 500 iops. While you can stripe them into virtual disks to get more (roughly multiplicative, 2 disks = 1000 iops, etc.). But that's the only thing on offer at the moment.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply