Foglight for SQL Server (Cartridge) 5.9.4.20 - User Guide

Overview Running the Upgrade Wizard Migrating Agents

Adding instances manually Discovering instances by host name Discovering instances by IP range Importing Instances from a File

Contents of the Input CSV File Configuring the On Demand Data Port on the Agent Manager Concentrator

Assigning Instances to Users or Groups Selecting an Instance to Monitor Foglight for SQL Server Toolbar and Views

Viewing the Replication Home Page

Resource Toolbar Options Monitoring SQL Performance without SQL PI configured Monitoring SQL Performance with SQL PI Configured

Viewing the Memory Summary Monitoring Buffer Cache-related Data

Viewing In-depth Data about the Instance Tracking the Instance Data Flow

Monitoring SQL Server Databases Monitoring Database Details

Reviewing the Support Service Status Reviewing SQL Agent Jobs Viewing SQL Agent Alerts Monitoring SQL Server Transactions using the DTC Panel Monitoring Full-text Indexes using the Full Text Search Panel

Monitoring the Log Shipping Monitoring Cluster Services Tracking the Status of the Mirroring Operation Reviewing the Always On Availability Groups

Reviewing the SQL Server Error Logs Reviewing the SQL Agent Error Logs

Reviewing SQL Server Configuration

Viewing User-Defined Performance Counters Viewing User-Defined Collections

Configuring Integration Services Monitoring Overview dashboard Packages Dashboard Terminology

Configuring Reporting Services Monitoring Monitoring Reports using the Reporting Services Panel

Configuring Analysis Services Monitoring Overview dashboard Unprocessed Objects Dashboard Current Activity Dashboard Monitoring Analysis Service Performance Resource Toolbar Options Performance Tree Viewing Historical Metrics Viewing Change Tracking

Defining Connection Details Alarms

Reviewing SQL Server Configuration

Opening the Databases Administration Dashboard Reviewing the Administration Settings Defining Connection Details Customizing Alarms for Foglight for SQL Server Rules Defining Data Collection and Storage Options Defining Error Log Filtering Configuring Performance Counters Setting Options for Displaying Data in the Buffer Cache Setting Options for Displaying Data in the Plan Cache Setting Options for Displaying Data in the Locks Panel Defining Retention Policies Defining the Collection and Display of Top SQL Statements Defining the Collection of Database Indexes Configuring User-defined Collections Administering SQL Performance Investigator Configuring the On-demand Data Settings Configuring the Database to be Excluded

Alarms Displayed in the SQL Processes Panel Alarms Displayed in the SQL Memory Panel Alarms Displayed in the Background Processes Panel Alarms Displayed in the Database Details Panel

Generating Reports for a Foglight for SQL Server Instance Studying the Various Reports

Viewing Data Displayed on vmExplorer

Access methods Adhoc SQL Plans Alarm Alert Allow updates Anonymous subscription Authentication AutoClose AutoGrow Automatic Discovery AutoShrink B Batch BCP (Bulk Copy Program) Blocking Books Online Bound trees Buffer Buffer cache Buffer pool Bulk copy Bulkinsert Bulk load C Cache CAL Calibration Cardinality Cartridge Chart Checkpoint process Client network utility CLR Compile Connect Connection Connectivity software CPU Usage Cursors D Data access components Data file Data storage engine Database Database object DataFlow DBCC DBID DBO Deadlock Disk queue length Disk transfer time Disk utilization DiskPerf Distributing instance Distributor DMO Drilldown DTC DTS E Error log Event alert Execution contexts Extended stored procedures Extent External procedures F File Filegroup File cache Foglight Agent Manager Foglight Management Server Foreign key Forwarded records Free buffers Free list Free pages Free potential Free space Freespace scans Full text search G GAM Ghosted records Growth increment GUID H Hash buckets Hashing Heap Hit rate Hit ratio Host name Host process I I/O Index Indid Integrated security Intent Locks J Job K Kernel memory Kernel mode Kill L Latch Lazy writer Licensing Lightweight pooling Lock Lock area Lock escalation Lock mode Log Log cache Log writer Logical I/O LRU LSN M Master MaxSize MDAC Metric Misc.normalized trees Model Monitor page file N Named pipes Net library NIC Null O OBID Object plans OLAP OLAP service OLTP Optimizer Optimizer cache osql P Page life expectancy Paging Panel Parse Parser Per seat licensing Per server licensing Performance alert Physical I/O Physical read Physical write PID Pinned Plan Plan cache Potential growth Prepared SQL plans Primary key Privileged mode Procedure cache Procedure plans Process Profiler Publication database Publisher Publisher databases Publishing server Pull subscription Pulse Push subscription Q Query plan R RAID Random I/O Read ahead Recompile Referential integrity Relational data engine Replication procedure plans Role Rollback S sa Schema locks Sequential I/O Session Severity SGAM Shared locks Show advanced options SMP Sort, Hash, Index Area SPID Spike Spinner SQL Agent Mail SQL Mail SQL Plans SQL Server Agent SQL Server authentication SQL Server books online Standard deviation Stolen pages Stored procedure Support service SYSADMIN role T TDS TempDB Temporary tables and table variables Threshold Torn page detection Transaction Trigger Trigger plans Truncate Trusted U UMS Unused space User connection area User mode V Virtual log file VLF W Waitfor Windows authentication mode Working set