title: Why would my Azure SQL Database performance suddenly drop?
body: <p>I had a 'Business' edition SQL database that started timing out about the same time <a href="https://weblogs.asp.net/scottgu/azure-premium-storage-remoteapp-sql-database-update-live-media-streaming-search-and-more" rel="nofollow">MS announced the rollout of new SQL features</a>. </p>
  
  <p>Suspicious timing aside, a simple COUNT(*) query against one of my tables is taking nearly 2 minutes. It's got about 4.5 million rows which is about the same row count as another 'Web' tier database that is returning COUNT results in about 1 second. These two databases are on the same server in Azure.</p>
  
  <p>Assuming the worst 'noisy neighbor' scenario, I renamed the DB, copied it and migrated it to Standard S1 tier. I'm having the same performance issues on the new database. I'm not sure what else to try and I'm not sure why my performance fell off a cliff so suddenly.</p>
  
  <p>Any suggestions or 'me too' would be helpful. Thanks!</p>