Introducing sys.database_connection_stats for Troubleshooting Windows Azure SQL Database

Windows Azure SQL Database (formerly Sql Azure) now has a new system view called sys.database_connection_stats to help database Administrators track the status of incoming connections. The sys.database_connection_stats gives insight into how many incoming TDS connections are successful, terminated, throttled, and failed aggregated to a five minute window. Before this feature improvement, application developers needed to…

0

Understanding Windows Azure SQL Database Size

The database on Windows Azure Sql Database is stored in two parts: Database data and metadata. Database data is the data in the tables and indexes and is stored in page files. Metadata is the stored procedures, functions, cached query plans, etc… that are related to your database. Metadata is stored in the pages of…

2