![]() The percentage of bytes written by the captured query, in relation to any other events that are shown in the Top SQL Grid view.Īdditional data captured about the query. The number of physical disk writes performed by the server on behalf of the captured query. The percentage of bytes read by the captured query, in relation to any other events that are shown in the Top SQL Grid view. The number of logical reads from the cache performed by the server on behalf of the captured query. The percentage of CPU time used by the captured query, in relation to any other Top SQL events that are shown in the grid. The amount of CPU time (in milliseconds) used by the captured query. The amount of time taken by the captured query. The Windows or SQL Server account associated with the captured query. The event class of the associated captured query.Īdditional Information: For more information, see the SQL Server Event Class Reference MSDN article.Īssociated text data captured for the query. Name of the target where the associated captured query originated. Select Open to open a new Plan Explorer session for the captured query plan. This enables you to quickly determine which events are responsible for the most CPU or IO activity for the active date range.Īdditional Information: See the Top SQL Runtime Stats article. This groups all like events together using a normalized version of the T-SQL with all variable parameters replaced, and it shows aggregates for each group. Totals mode is enabled by selecting Show Totals (the sigma Σ button). Default mode is activated whenever auto-refresh is enabled by selecting Play on the toolbar, which shows the events for the last 10 minutes with new events coming in automatically at the top of the list. There are two modes for this pane: Default and Totals.ĭefault mode lists all events for the active date range in a standard list format, sorted descending by End Time by default. The View button in the Plan column opens a Plan Explorer session for the associated query. The Completed Queries tab lists all records matching the current filters. Note: The text data for the active statement is displayed in the Text Data pane when the Active Statement cell is selected. Note: Running queries isn't supported for SQL Server 2000 or Azure SQL Database. Adjust the time displayed on the graph with the Range slider. Different colors on the dots indicate the different plans, and the plans are numbered. Each dot represents when the query was executed. Query History provides information about the query execution plans, if and when they were changed, and how they impacted different resources. Query History displays a graphical representation of the selected query over a specified range of time. ![]() For more information about Plan Explorer, see the Plan Explorer topic. Select Open with Plan Explorer to open the integrated Plan Explorer view for the selected execution plan. Hover over a plan diagram icon to display a tooltip with more detailed information. Select Open with Plan Explorer to view the query diagram in more detail. The Plan Diagram displays a graphical plan preview of the desired query in your environment. This allows you to see which resources were consumed by which part of the batch. It provides details on the key performance metrics that are associated with each component part of the larger query. The Statements Grid displays the statements that were collected with the associated completed query, procedure stats or query stats. Open Plan Explorer for the expanded query by selecting Open. View Running Queries, Completed Queries, Procedure Stats, or Query Stats by selecting the corresponding tab. The Top section Grid View displays queries in your environment. See the Watched Target Objects article for details. This option creates a few objects within a SQL Sentry schema on the target database. ![]() To collect Top SQL metrics for Azure SQL database targets the Allow SQL Sentry Monitoring Objects in Target setting under the Azure SQL Database Connection settings must be set to True. The default minimum duration is five seconds, but this can be adjusted up or down as needed through the Top SQL Source settings. The default filter is Duration, but filtering using CPU and IO is also available. ![]() The Top SQL tab lists all T-SQL batches, stored procedures (RPCs), and statement events collected for the current date range that exceeded the Minimum Duration specified in the Settings pane. See the SQL Sentry Portal Top SQL article for an example of the Top SQL feature in a browser. To learn more about configuring your environment to use the on-premises, browser-based option with your existing SQL Sentry database, see the SQL Sentry Portal article. SQL Sentry Portal: This feature is available in SQL Sentry Portal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |