Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Foglight for SQL Azure 5.5.8.6 - User Guide

Introducing Foglight for SQL Azure Adding and Configuring Agents Reviewing SQL Azure Activity Reviewing Database Usage Reviewing the Database Properties Monitoring Estimated Costs Viewing User Metrics Using the Global Administration Options Reviewing Foglight for SQL Azure Alarms Glossary

Monitoring blocked processes for the sampled interval

The Number of Blocked Processes chart displays the number of SQL Azure sessions that were involved in blocks over time. Use this chart to review the frequency and duration of lock conflicts in SQL Azure.
This chart displays the following indicators:
•
Blocked Processes—number of sessions that were waiting on locks held by others.
•
Lead Blockers—number of sessions that were not blocked, but were blocking others. Lead Blockers correspond to sessions in the Blocking table that do not have a parent in the Blocking chain (at level 1 in the tree).

Tracking Historical Lock Conflicts

The Blocking (History) panel displays all of the blocks that reached or exceeded the minimal duration, in seconds, which a block should reach or exceed in order to be collected.
 
* 
NOTE: The minimal duration’s length is defined via the Blocking History Collection Parameters section under the SQL Azure agent properties, accessible via Dashboards > Administration > Agents > Agent Status. For details, see chapter “Agent Properties” in the Managing SQL Azure Database Systems Reference Guide.
This panel contains the following sections:
•
Blocks Exceeding a predefined threshold—a chart displaying all of the blocks that reached or exceeded the minimal duration, in seconds, which a block should reach or exceed in order to be collected. This chart can be displayed using either of the following parameters:
•
Longest block duration—the duration (seconds) of the longest block detected during the snapshot
•
Number of blocks—the total number of block detected during the selected snapshot
•
A table displaying all snapshots taken during the specified time range, providing the following details regarding each snapshot:
•
Snapshot time
•
Longest block duration
•
Number of blocks

Viewing Detailed Sessions Data

The Sessions panel allows tracing the activity of all currently running sessions, as well as their resource consumption.
 
* 
NOTE: The refresh rate of the data displayed on the Sessions panel can be set by selecting a value from the Refresh interval drop-down list, which appears on the panel’s upper right side.
This panel allows carrying out the tasks detailed in the following sections:
•
Monitoring the active/inactive sessions ratio on page 30
•
Monitoring the foreground/background sessions ratio on page 30
•
Viewing the workload incurred by a single session’s activity on page 31

Monitoring the active/inactive sessions ratio

The Active/Inactive sessions section provides a graphic representation of the percentage of active sessions within the entire number of SQL Azure sessions that ran during the specified time range.
Active sessions are non-system sessions that are actively processing in SQL Azure, or are waiting on locks (blocked). An unexpected increase of the number of active sessions can indicate one of the following situations:
•
A massive workload—the system handles more users than it was initially designed to do
•
A bottleneck—lack of system resources prevents users from carrying out their transactions, resulting in wait events and an increasing number of sessions that remain active for prolonged periods
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation