Monitoring Windows Azure SQL Server VMs and SQL Databases
Using a virtual machine divorces you from the underlying hardware and makes understanding what is happening on your systems more difficult. Take that same situation and move it into the cloud on Azure systems and the difficult can seem almost impossible. Understanding how you can monitor performance in the Azure environment, what works, what doesn't and what's a lie, will help you to better understand how your systems are performing. You'll better be able to identify and fix bottlenecks in order to ensure necessary performance of your systems that are hosted out on the cloud. We'll cover the different methods you have for SQL Server on a VM and for Windows Azure SQL Database so that you can begin monitoring your own cloud-based systems as soon as possible.
Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG). He earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.