Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

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

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

Cost Changed

The Cost Changed alarm becomes active when one or more of the following parameters, defined via the Cost Configuration screen, has been changed:

•

•

•

To view the meaning of each parameter and for instructions how to access the Cost Configuration screen in order to review the new definitions, see Cost Was Not Set on page 78.

Glossary

Adhoc SQL Plans

Query plans produced from an ad hoc Transact-SQL query, including auto-parameterized queries. SQL Server stores such query plans in the procedure cache for later reuse, if an identical Transact-SQL statement is later executed.

The mechanism by which Foglight for SQL Azure alerts to a condition that might be a problem in the SQL Server instance. While an alarm is active, the color of icons on the homepage changes.

A SQL Server Agent object that performs an action when a condition is satisfied. Categorized as either Event Alerts or Performance Alerts. The action performed can be to send email, pager or Net Send message, or to run a SQL Agent job.

Automatic Discovery

Automatic Discovery is a cartridge that is installed as part of the Foglight for SQL Azure installation package. This cartridge allows running the database discovery wizard, which provides a common entry point for adding and discovering all of the database instances within a user-specified range, and then configuring these instances to be monitored.

Batch

A set of Transact-SQL statements that are sent from a Client program to SQL Server for execution. Even though batches can contain multiple statements, they often hold only a single statement.

BCP (Bulk Copy Program)

A stand-alone executable program that is extremely fast at copying data between SQL Server and text files. BCP can be used for loading or unloading data.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating