Microsoft CSS SQL Azure Diagnostics tool developed by Microsoft Customer Service and Support (CSS) SQL Support, enables customers to help customers troubleshoot SQL Azure issues, by expediting the data collection process.
“Since you cann’t use PSSDiag/SQLDiag against SQL Azure, I decided to develop this tool to shorten the data collection process when troubleshooting SQL Azure issues,” stated Evan Basalik, of the CSS SQL Server team.
“You can point CSAD to your SQL Azure instance, provide the appropriate credentials and will then be presented with some good summary data about your instance. Since I leverage the standard ReportViewer control, you can also export the reports to a number of different formats.
This makes it easy to share the reports with either your colleagues or CSS. In addition, CSAD is a Click-Once application, so it has a very light installation and it always checks for the latest version.”
- CSAD does require the installation of the ReportViewer 2010 and the .NET 4.0 Client Profile. It should check for both components on install, but you can also install them separately:
- No reboot is necessary
- Each time CSAD starts up, it checks the Azure blob storage location for a newer version and updates itself if necessary
- You can uninstall it by going to Control Panel — > Add/Remove Programs
- I’ve already seen a few isolated instances where the ReportViewer control wouldn’t install. If you run into that scenario, just install it separately using the link above
[Source: CSS SQL Server Engineers]