Book Image

SQL Server on Azure Virtual Machines

By : Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West
Book Image

SQL Server on Azure Virtual Machines

By: Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West

Overview of this book

Deploying SQL Server on Azure virtual machines allows you to work on full versions of SQL Server in the cloud without having to maintain on-premises hardware. The book begins by introducing you to the SQL portfolio in Azure and takes you through SQL Server IaaS scenarios, before explaining the factors that you need to consider while choosing an OS for SQL Server in Azure VMs. As you progress through the book, you'll explore different VM options and deployment choices for IaaS and understand platform availability, migration tools, and best practices in Azure. In later chapters, you'll learn how to configure storage to achieve optimized performance. Finally, you'll get to grips with the concept of Azure Hybrid Benefit and find out how you can use it to maximize the value of your existing on-premises SQL Server. By the end of this book, you'll be proficient in administering SQL Server on Microsoft Azure and leveraging the tools required for its deployment.
Table of Contents (10 chapters)
8
Index

Performance best practices

Performance tuning can be a broad and complex topic; however, migrating to Azure VMs can help simplify the process. There are so many factors that can impact performance. If you have already deployed an Azure VM, the Azure portal lets you use Azure Monitor for VMs. It provides insights into the health and performance of your Windows or Linux VMs by monitoring their processes and dependencies on other resources. Not only can it monitor other Azure VMs; it can monitor VMs on other cloud providers and on-premises to give you a holistic view. You get pre-defined performance charts that show the trending and the dependency map, all built into the Azure portal. In addition to Azure Monitor for VMs, all VMs have basic monitoring enabled in the Azure portal. This basic monitoring shows the average CPU, the total network, the total disk bytes, and the average disk operations per second. Data can be shown for the past 1, 6, or 12 hours; the past 1, 7, or 30 days; and...