Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Azure with SSD's Expand / Collapse
Author
Message
Posted Wednesday, April 23, 2014 2:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 2:06 PM
Points: 163, Visits: 603
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.
Post #1564454
Posted Wednesday, April 23, 2014 3:28 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:21 PM
Points: 15,630, Visits: 28,017
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1564466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse