지금 지원 담당자와 채팅

라이브 도움말 보기
등록 완료

로그인

가격 산정 요청

영업 담당자에게 문의

무료 트라이얼

Foglight for SQL Azure 5.5.8.6 - User Guide

콘텐츠 탐색

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

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

Monitoring estimated costs

The Estimated Cost pane displays the estimated costs, in US dollars, to be charged for the actual storage consumption and bandwidth usage during the specified time range.

NOTE: To view detailed information regarding the estimated cost calculation, refer to the following panels:

•

For bandwidth usage—go to Activity > Bandwidth Usage. For more information, see Monitoring Bandwidth Usage on page 37.

•

For storage consumption—go to Database > Estimated Storage Cost. For more information, see Reviewing the Estimated Storage Cost on page 47.

Reviewing the Storage Utilization the Cost-related Results

The Estimated Storage Cost section allows viewing the daily storage cost over the last several days, as defined in the selected time range, and determining the suitability of the business edition in use, compared with the current database size.

Reviewing the Estimated Storage Cost Changes

The Estimated Cost chart allows viewing the variations, if any, of the daily storage cost between the days specified in the selected time range. The cost can be compared with the actually used space size, which is displays in the Utilized Space Size chart.


	IMPORTANT: As the daily storage cost is determined at the end of the day, the daily storage cost is plotted over days. However, as such a display is not possible when the selected time range is the default period of the last two days, the chart plots the storage cost over hours. Therefore, if the database has been monitored for more than a week, it is advisable to change the selected time range to 7 days (1w) in order to obtain a more realistic display.

Reviewing the Total Storage Cost Calculation

The Storage Cost Calculation table displays the estimated storage cost for the number of days specified in the selected time range, for which data is available, with a breakdown by days and cost plan (business edition and storage limit) used each day.


	IMPORTANT: As the estimated daily storage cost is calculated at the end of the whole day (midnight), no storage cost is available for the current day, and the table displays the estimated cost the number of days specified in the selected time range, for which data is available. For example: if selecting a one-week time range on October 10th at 13:30, the table displays data for the week that ended on October 9th at midnight.

The table contains the following columns:

•

Edition—the business edition type; either Web or Business

•

Limit—the upper storage limit for the selected cost plan

•

Days—the number of days that the selected cost plan was in use

•

Price—the storage price per GB

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택