Are you leveraging SQL Server through PaaS?

Last week we had our webcast Leveraging SQL Server through PaaS , and we had a very lively Q&A session that followed our experts’ presentation. Today we bring you a brief transcript of the questions from our audience. If you missed the webcast and would like to download the recording, click here.

Can we combine SQL Server with high availability technologies?
Yes, it’s possible. This would provide maximum protection against the loss of physical SQL Server database on instance. Using Always-On, or failure clustering within a site – it’s quite common along adding data mirroring to satisfy these recovery requirements. There isn’t one solution to fit all, but by understanding the alternatives and combing technology it’s possible to address this.

What is the performance overhead of asynchronous replica?
From the primary replica you can ping the secondary and see how long the response takes (in milliseconds.) Then you can run load tests in the secondary transaction load drive and see how long it takes to ride. This is the minimum additional time which will be added to each transaction on the primary. If you’d like to review the impact, you should make sure that your network is low latency and your transaction load drive rides fast.

How can we leverage MySQL to start using Hybrid Cloud options?
As we saw in the presentation, one of the simplest ways to do this is in the area of Backup. With SQL Server 2014, you can now use Microsoft Azure as the backup target, supported by both Transaction SQL and Azure services, and the maximum backup is 1 Terabyte.

Will In-Memory OLTP solve any performance problems?
No, while In-Memory OLTP Engine can provide a large performance boost in many situations, there are several performance issues that In-Memory cannot address. For instance, a bad database design, or correct poor performance queries. Additionally, not all details and procedures can be modified to take advantage of In-Memory OLTP Engine; some may require unsupported data types or physical features. You can use SQL Server 2014’s analysis to migrate and report to find out where the In-Memory OLTP feature can be effectively used.

What are the key benefits of using Azure services?
According to Microsoft, among the benefits of Azure we can include that critical updates for SQL Servers are enabled by default, for example, your SQL Server running in an Azure virtual machine always receives the critical updates, the virtual machines have access to more core and more memory for SQL Server loads, the ability to expand virtual machines with SQL Server 2014 In-Memory OLTP, you can use more virtual CPUs in parallel to increase the number of concurrent users and improve transactional performance, the opportunity to extend SQL Server business continuity with Azure Data Centers on which to place always-on secondaries, improved BI performance by uploading BI reporting from your primary to clusters as your secondary replica, economies of scale with Azure Data Center, Azure express root connection, faster SQL Server backups to Azure, and Cloud backup capabilities, and RPO by reducing the potential data loss in asynchronous mode and improving recovery time objective.