When running Microsoft SQL inside of Azure it is important to make sure that the virtual machine has enough I/O to support the workload that is expected. I/O is measured in IOPS which are going to be used when discussing performance throughout this blog. If the virtual machine does not have enough IOPS there will be a huge decrease in performance that can easily be prevented. A standard virtual machine with one data disk will only provide 500 IOPS which might not be enough for databases that are constantly used. In order to increase the number of IOPS, I am going to take advantage of disk striping by using a storage pool to create a virtual disk that consists of multiple data disks in Azure.
First, let’s start off with a virtual machine with one data disk so we can compare…
The long awaited webjobs is now in preview for Windows Azure! How many times have you deployed a website, then after a couple months requirements change and they want you to run a daily or continuous job that processes files or re-size images or works a queue, now with web jobs in Windows Azure it is easy. In this post I will explain how you can deploy this Azure Web Job as part of your Azure web site (PaaS), You just deploy and you are done. There is no need to zip up files and go to the management console. A one shot deal!
The PAL (Performance Analysis of Logs) tool is a powerful tool that reads in a performance monitor counter log and analyzes it using known thresholds. A template is created from the PAL tool and imported to the server’s Performance tool as a new counter. This includes relative BizTalk and SQL metrics that will be tracked. The resulting blg files are analyzed by the PAL tool and thresholds are applied once questions are answered regarding number of CPU, memory, etc. A report is produced by the PAL tool in an easy to read format with graphs. Tallan will use this information to make recommendations for performance improvements.
Threshold files take the questions answered in the tool and apply them to the results. This is a quick and easy way to see where the weaknesses are without lengthy analysis.
An easy to use GUI…