April 2012 Entries

SQL Azure: Database Size History

You may end up in a situation where you need to know how your databases have evolved over time from a storage standpoint, and how much they were used. For example, you may want to know how your databases were used last month if your customers complained about performance. Or you may need to see how fast your database is growing to help you plan for future capacity. Two system views are now available (see disclaimer further down): sys.resource_usage and sys.resource_stats. Both views contain a time ......