New System View Publishing for Windows Azure SQL database
Source: Internet
Author: User
KeywordsAzureazure System view
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:
Public Connection Statistics information exposes deadlock views to customers
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:
Sys.event_log sys.database_connection_stats
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.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.