New System View Publishing for Windows Azure SQL database

I am pleased to announce that Windows http://www.aliyun.com/zixun/aggregation/13357.html ">azure SQL database two new system views are now available immediately, It provides diagnostic tracking information for the cloud database.

In your SQL database server's primary database, you now have the following new system views to use:

View

Location

Postal

Sys.event_log

Master

Exposes to the user log information from the system about each database hosted on the server.

Sys.database_connection_stats

Master

Exposes connection statistics information that is successful and failed for the surrounding connection.

With this improvement, system managers now use the same tools and techniques to query connection statistics and bandwidth throttling events, with a non cloud SQL Server that can use a system view designed for the cloud.

Sys.event_log View

At this point, the Sys.event_log view enables the following important scenarios:

Core connection information can be found in Sys.event_log, as described below in SQL Server Management Studio 2012 (Run SELECT * from Sys.event_log on the primary database):

In addition, the deadlock view is exposed in the Additional_data field in Sys.event_log (Run select * from sys.event_log where event_type = ' deadlock ' to the primary database):

Sys.database_connection_stats View

Over time, database connection data statistics expose critical failure totals in each database. The Sys.database_connection_stats view provides insight into how many incoming TDS connections are successful, terminated, or contained: failures converge to a five-record window.

Instances of this type in the table are displayed as follows (run SELECT * from Sys.database_connection_stats for the primary database):

Also, to make it easier to manage your Windows Azure SQL database, the portal site for each database Windows Azure Management now exposes the connection information graphically:

Permissions

By connecting to the primary database, these two new systems can be accessed, access to the database only with administrative privileges, and (read-only) the view. Because this data is stored in the master database, the space to store the data is not part of the user manifest.

Lag time

There are some delays when connecting, and some increments are displayed in the Sys.database_connection_stats view. During this time, after the row is first written, the information in a single row may be updated. A SQL database is a multi-tenant system with multiple points that participate in processing connections, each of which can add data to rows.

For more information

We want the new view to prove useful in managing the database and obtaining more detailed diagnostic information. You can find more information about these views on MSDN via the links below:

In addition, Wayne Berry has released an MSDN blog about further information, including useful queries to construct these new views. For questions about these features, you can publish in the SQL database MSDN Support Forum.

Happy！

reinstates Azure SQL Database Team