Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

VERSIONI DI PROVA GRATUITA

Foglight for SQL Azure 5.5.8.6 - User Guide

Table of Contents

Introducing Foglight for SQL Azure

Foglight for SQL Azure Summary View Reviewing the Databases Dashboard

Currently Selected Group

Selecting the Database to be Monitored

Filtering the Display by Severity Creating Custom Database Groups Previewing the Requested Database Components Shared by all Foglight for SQL Azure Screens

Viewing the Foglight for SQL Azure Summary

Identifying the Instance Monitoring Alarms Reviewing the Estimated Costs Tracking the Instance Data Flow Monitoring the Database Activity and Storage

Reviewing frequently requested statistics

Adding and Configuring Agents

Studying the Foglight for SQL Azure Architecture Running the Database Discovery Wizard

Carrying Out the Automatic Discovery Process

Reviewing SQL Azure Activity

Viewing In-depth Data about the Instance

Tracking Current Lock Conflicts

Handling blocking sessions Monitoring blocked processes for the sampled interval

Tracking Historical Lock Conflicts Viewing Detailed Sessions Data

Monitoring the active/inactive sessions ratio Monitoring the foreground/background sessions ratio Viewing the workload incurred by a single session's activity Viewing the Session Details page

Tracking Top SQL Statements Data

Top SQL Statements table SQL Activity section SQL Statement Details page

Monitoring Bandwidth Usage

Reviewing bandwidth usage and estimated costs Reviewing external data transfer Reviewing internal data transfer

Reviewing Database Usage

Viewing the Database's Storage-related Data

Reviewing the Database's Tables and Indexes

Reviewing tables' space usage Reviewing indexes for a selected table Indexes table Index Details Index Density table Index Histogram table

Reviewing the Storage Growth and the Cost-related Results

Reviewing the database properties Reviewing the database growth and the resulting storage price Reviewing the ratio between the database's tables and indexes Reviewing the top-fastest growing tables and indexes by size Reviewing the growth of a specific database object

Reviewing the Estimated Storage Cost

Reviewing the Estimated Storage Cost per Day Reviewing the Estimated Total Storage Cost Reviewing the Estimated Storage Cost Changes

Reviewing the Database Properties

Viewing the Database and Master Database Properties

Reviewing the Instance's Version-related Information Reviewing the Remote Users' Firewall Settings Reviewing the Monitored Database's Properties

Monitoring Estimated Costs

Viewing the Database's Pricing Plan and Estimated Costs

Reviewing the Pricing Plan and its Effect on Estimated Costs

Viewing the user account settings Viewing the storage and bandwidth usage prices Monitoring estimated costs

Reviewing the Storage Utilization the Cost-related Results

Reviewing the Estimated Storage Cost Changes Reviewing the Total Storage Cost Calculation

Reviewing Bandwidth Utilization and Cost-related Results

Reviewing the Estimated Changes of Bandwidth Usage Cost Reviewing the bandwidth usage cost calculation

Viewing User Metrics

Viewing User-Defined Collections

Using the Global Administration Options

Reviewing the Global Administration Settings Defining the Connection Settings for the Monitored Databases Defining Data Collection and Storage Options Configuring User-defined Collections

Editing user-defined collections

Configuring the On-demand Data Port Defining Alarms

Reviewing all Existing Alarms Viewing and Editing the Alarm Settings

Defining Thresholds

Configuring Alarm-triggered Email Notifications Configuring Foglight Mail Server

Configuring Usage Costs Setting the User Account

Reviewing Foglight for SQL Azure Alarms

Alarms Displayed in the Databases Table

Collection Status

Alarms Displayed in the Summary's Database Pane

Bandwidth Usage Baseline Deviation Connection Time Instance/Database Unresponsive Response Time

Alarms Displayed in the Blocking (History) Panel

Long Lock Running

Alarms Displayed in the Sessions Panel

Total Connections Baseline Deviation All Active Connections Baseline Deviation Blockers Connections Baseline Deviation

Alarms Displayed in the Top SQL Statements Panel

Executions Baseline Deviation Total CLR Time Baseline Deviation Total I/O Baseline Deviation

Alarms Displayed in the Storage Panel

Database Reaching Maximum Limit Capacity Database Requires Change in Edition Database Reaching Current Limit Capacity Database Wrong Edition Used Database Current Limit Resized

Alarms Displayed in the Database Properties Panel

Database Property Changed

Alarms Resolved via the Cost Configuration Administration Screen

Cost Was Not Set Cost Changed

Glossary

Batch BCP (Bulk Copy Program) Blocking Books Online Bulk copy Bulkinsert Bulk load CAL Calibration Cardinality Cartridge Chart Client network utility CLR Compile Connect Connection Connectivity software Cursors Data access components Data storage engine Database Database object DataFlow DBCC DBID DBO Deadlock Density DMO Drilldown Execution contexts Extent Foglight Agent Manager Foglight Management Server Foreign key Full text search GAM GUID Hashing Heap Hit rate Hit ratio In-row data Index Indid Kill Licensing Lock Lock escalation Lock mode Logical I/O LRU LSN Master MDAC Metric Null OBID Object plans OLTP Optimizer Panel Parse Parser Per seat licensing Per server licensing Physical read Physical write Pinned Plan Prepared SQL plans Primary key Procedure cache Procedure plans Process Pulse Query plan Random I/O Read ahead Recompile Referential integrity Relational data engine Role Rollback Schema locks Sequential I/O Session Severity SGAM Sort, Hash, Index Area SPID (Session ID) Spike Spinner SQL Plans SQL Server Agent SQL Server books online Standard deviation Stolen pages Stored procedure Temporary tables and table variables Threshold Transaction Trigger Trigger plans Truncate Waitfor

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Foglight for SQL Azure 5.5.8.6 - User Guide

Random I/O

Read ahead

Recompile

Referential integrity