Chat now with support

Live-Hilfe anfordern
Registrierung abschließen

Anmelden

Preisinformationen anfragen

Vertrieb kontaktieren

Foglight for Azure SQL Database (Cartridge) 6.0.0 - User Guide

Inhaltsnavigation

Installing and Configuring Agents

Installation About Monitoring Extensions Installing and Monitoring a Single Azure SQL Database

Using Foglight for Azure SQL Database

Viewing the Databases Dashboard Selecting an Instance to Monitor Foglight for Azure SQL Database Overview Dashboard SQL Performance Investigator (SQL PI) Azure SQL Activity Drilldown

Administering Foglight for Azure SQL Database

Opening the Databases Administration Dashboard Reviewing the Administration Settings Customizing Alarms for Foglight for Azure SQL Database Rules

Introducing the Alarms View Modifying Alarm Templates Configuring Email Notifications Cloning Agent Settings Reviewing Rule Definitions

Defining Connection Details Administering SQL Performance Investigator

Generating Reports for a Foglight for Azure SQL Database

Overview of Collections

Usability Query Store Query Store Top SQLs Version Info Resource Stat Wait Statistics Database Connections Summary Database Replication Database Storage Database Recommendations

SQL Performance Investigator Metrics

Active Connections Active Time Active Time per Execution Active Time Rate Always On Average CPU Percent Average DTU Percent Average Memory Usage Percent Average SQL Response Time Average XTP Storage Percent Average Data IO Percent Average Log Write Percent Backup Recovery Blocked Sessions Connections CPU Limit CLR Wait CLR Wait per Execution CLR Wait Rate CPU Time CPU Time per Execution CPU Time Rate CPU Wait CPU Wait per Execution CPU Wait Rate Cursor Synchronization Database Replication Deferred Task Worker Distributed Transaction DTU Limit Elapsed Time Executions External Procedure Full Text Search Governor Wait Governor Wait per Execution Governor Wait Rate Granted Memory Hosted Component Inactive User Connections I/O Bulk Load I/O Completion I/O Data Page I/O Wait I/O Wait per Execution I/O Wait Rate Idle Time Internal Cache Latch Latch Buffer Latch Savepoint Latch Wait Latch Wait per Execution Latch Wait Rate Lead Blockers Lock Bulk Update Lock Exclusive Lock Intent Lock Schema Lock Shared Lock Update Lock Wait Lock Wait Rate Lock Wait per Execution Log Buffer Log Other Log Synchronization Log Wait Log Wait per Execution Log Wait Rate Log Write Logical Reads Logical Reads per Execution Max Degree of parallelism Max DTU Percent Max Session Percent Max Workers Percent Memory Wait Memory Wait per Execution Memory Wait Rate Network HTTP Network I/O Network IPC Network Mirror Network Wait Network Wait per Execution Network Wait Rate OLEDB Provider Full Text Other Miscellaneous Other Wait Other Wait per Execution Other Wait Rate Parallelism Wait Percent of Total Plan Recompilations Physical Reads Physical reads per Execution Preemptive Wait Preemptive wait per Execution Preemptive Wait Rate Remote Provider Wait Remote Provider wait per Execution Remote Provider Wait Rate Row count Service Broker Synchronous Task Wait Time Percent Writes Writes per Execution XTP Log write Wait XTP Miscellaneous Wait XTP Procedure Wait XTP Transaction Wait XTP Wait XTP Wait per Execution XTP Wait Rate

Alarm Authentication Calibration Cartridge Client Machines CPU Usage CPU Wait DataFlow Deadlock Disk Transfer Time Disk Utilization DiskPerf Dispatcher Drilldown DTU Elastic Pool External Procedures Foglight Agent Manager Foglight Management Server General purpose I/O Wait Kernel Memory Kernel Mode Kill Lock Wait Log Buffer Wait Logical Reads LRU LSN Metric Network Wait OLTP Other Wait Paging Panel Physical Reads Process Random I/O Recompile Referential Integrity Relational Data Engine Schema Locks Severity Single database SPID Spinner Threshold Transaction Unused Space vCore

Technical support resources

LRU

Least Recently Used. Often refers to pages in memory. The LRU list is the mechanism by which Azure SQL Database determines which pages should be moved to the free list first.

LSN

LSN (Log Sequence Number|), which provides a unique identification of a point in a database's log, is used for determining determine when a page was last modified.

Metric

A unit of measurement that can be applied to a database. Metrics can help gauge the performance of a system.

A metric is an individual piece of information that Foglight for Azure SQL Database collects about the performance of a system. The information may be a numeric value (a number or percentage), a string of text, or some other piece of data.

Every time the Foglight for Azure SQL Database dashboard is refreshed, the cartridge retrieves the latest value of the metric, which can then be displayed in a drilldown or on the home page.

Network Wait

Network wait events occur when a session spends time waiting for messages to be sent or received over the network interface.

Network performance, which is measured in number (per second) of packets sent and received, can be used just like disk statistics to detect overload or non-optimal performance within a network or a network interface.

Excessive network wait can result from either:

•

Excessive network usage, originating in the application

•

Physical issues, identifiable by network errors and network collisions

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center