WAP Azure SMA Management Interface slow down
Recently I had an issue with the Windows Azure Pack. I have been using the Automation portion of it to do a lot of, Automation. Yeah big surprise. Well recently I have been having issues where using the web interface would result in 100's of MB of IO/Sec on the SMA database. After fighting with it for a while I determined that my problem was a direct result of queries being performed on the StreamJobs table.
To Resolve this issue I first created a backup of the SMA database and then dropped the entire StreamJobs table and recreated it. This has resulted in MUCH better SMA and Service Management Portal interface performance.