SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost

SQL
8 Comments

It is very common for people to move databases now a days to the cloud. The very first question I often hear from them is – How to Improve Application Performance on Cloud While Reducing Bandwidth Cost?

However, once the data is moved to any cloud there are two major challenges I see.

SQL SERVER - Improve Application Performance on Cloud While Reducing Bandwidth Cost nitroazure-800x302

Challenge 1: Network Latency / Congestion and Slow Performance

Challenge 2: Network Bandwidth Congestion and High Cost

Every time when I go to performance tuning consultation for cloud hosted database, I hear about slow performance and high cost. The matter of the fact, it is so common that when I know the database is hosted on a cloud, I tell my customer that I already know their problem a) Slow Performance due to network latency and b) High cost due to high consumption of the data bandwidth.

If you have a very small database, you may not face issues with the high cost of bandwidth, but if you are running enterprise grade application where you move quite a lot of data from one server to another server, I am very confident that you are facing above two issues.

For example, Microsoft charges egress or data transfer out cost per 250MB around USD 21.32 and Amazon charges around USD 23.27. Now look at your database and find the size of the largest table, next think if you want your table to be exported to our in-premises system due to any reason, how much will it cost if you try to transfer out that much data. Trust me, in no time, you can almost cross the limit of your credit card. It is indeed a big big challenge and a REAL ONE!

Smart Solution

Though the challenge is quite big the solution is very simple. Actually the solution requires just a couple of clicks of the button and four minutes of your time.

I have installed NitroAccelerator in my cloud machine and local machine. Once I installed NitroAccelerator, I did two different tests of transferring around 25,000 rows of the data. When I saw the results, I was indeed very much surprised and happy.

Here is the less than 4 minutes long video where I narrate the entire story.

TESTTime (s)Data Size (KB)
NitroAccelerator OFF482267
NitroAccelerator ON1231

You can see that when I had turned ON NitroAccelerator, the query time was reduced 1/4 from the original time by giving me around 400% percentage of performance improvements and data size was reduced from 2267 KB to just 31 KB, that is around 98% of the compression of the data.  These tests do not include using the NitroAccelerator caching features for applications with redundant queries or using multiple active result sets (MARS) where you would get even more performance and cost saving benefits.

Here is my question to you – answer me honestly.

Do you want to gain 4 times more performance by reducing your cost by 98%?

If the answer is YES. Watch the above video and download NitroAccelerator.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Cloud Computing, Nitrosphere, SQL Azure
Previous Post
SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
Next Post
SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.

Related Posts

8 Comments. Leave new

  • Useful Article Pinal. Thank you for sharing. However, small correction… its 400% performance improvement…. from 48 secs to 12 secs. :)

    Reply
  • It is dreadful that Microsoft cannot build this type of efficiency into its own products.

    Reply
  • Rémi BOURGAREL
    February 26, 2017 11:08 pm

    Pinal, you’re omiting nitro accelerator cost here : $2,395.00 per sql server and $1,200.00 per app server (I asked for a quote because their website doesn’t show their prices), you have to have some very important bandwidth cost for thinking about this solution !

    Reply
    • Hi Remi,

      Thank you so much.

      Very good point. Many of my customers are currently paying in high 4 digits or lower 5 digit price for bandwidth and this one time investment will bring their cost down by 50% and it is a big win.

      Additionally, do consider the performance improvement. Many organizations pay way more price for consults to tune queries than the product price.

      Reply
  • Can we install it on Windows Azure to speed the SQL Azure up?.

    Reply

Leave a Reply