Azure SQL Database NextGen Release Preview

Play Azure SQL Database NextGen Release Preview

The Discussion

  • User profile image
    rickarthur

    Glad to see the performance updates in the Premium tier.  Any chance that you will be fixing the performance in the Standard tier.  I tried running my small website from an S2 database, and it was DOG-SLOW!   I can't afford the premium tiers, and so moved the database to an A1 Virtual Machine (1 core, 1.75GB RAM) running SQL Express.   That little VM ran circles around the S2 database.  I would really like to move back to SQL DB!!!  Please, please, please tell me that you are going to fix this. 

  • User profile image
    compupc1

    +1 for the performance improvements to standard tier sizes.

    Love the higher level of compatibility.  SQL Azure is becoming a real contender!

  • User profile image
    Tony Petrossian

    With the new preview we also introduced the Standard S3 performance tier which is rated at 2x of S2. Please give Standard on the new preview a try and see if it addresses your concerns. See more details here: https://azure.microsoft.com/en-us/pricing/details/sql-database/

  • User profile image
    rickarthur

    Thanks Tony.  I saw the new S3 level, and that it has twice the DTU's of the S2 level.  But based on some of the testing I have done, this still puts the S3 performance level well below the horsepower of a single core VM with SQL Express. 

    I would love to have the added reliability that SQL Azure gives me over a standard VM, but Microsoft just doesn't have a solution that looks like it is going to work for me.  Unless Microsoft can address this soon, I am going to have go through the painful process of moving everything back to AWS.

  • User profile image
    Tony Petrossian

    Rick, send me an email after the holidays and we can chat in more details to see what would work for you. my email alias is tonypet

  • User profile image
    Phil001

    Hi,
    You mention better performance for Premium databases. Do you have any actual stats based on the current benchmarks so we can compare?

    Benchmark Transaction Rate:
    https://msdn.microsoft.com/en-us/library/azure/dn741336.aspx

  • User profile image
    Phil001

    Hi,
    I'm interested to know if the next version of SQL DB will allow a greater max DB size than 500GB.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.