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.

Jeremy Tirrell

Read more posts by this author.