New System View Publishing for Windows Azure SQL database

Source: Internet
Author: User
Keywords Azure azure 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.

Happy!

reinstates Azure SQL Database Team

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.