Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

Spotlight on SQL Server 10.0.3 - Getting Started Guide

Table of Contents

About Spotlight on SQL Server Installation and Upgrade

Install Upgrade Uninstall

Connections to SQL Servers Use Spotlight on SQL Server

Diagnose CPU Diagnose IO Diagnose Blocking View Historical Data Identify Expensive SQL

Turn on and configure SQL Analysis Real-Time Data and Expensive SQL Filter Displayed and Collected Data

Analyze Wait Statistics Find Long Running SQL Configure the Virtualization Overhead Guage

Connections to VMware Servers

Playback Database

Configure the Playback Database Requirements Playback

Troubleshooting, Permissions & Maintenance

Spotlight on SQL Server and Firewalls Permissions Unable to collect data Enabling Performance Data WMI Issues Spotlight on SQL Server and Windows domains Session Trace Errors Unable to establish a Spotlight connection to a SQL Server instance Connection Issues Monitor Multiple SQL Server Instances Spotlight Diagnostic User Groups Maintenance

Back Up Spotlight Configuration Data

Storage Drilldown

Note: This feature is not available for SQL Server Analysis Services 2000.

The Storage drilldown shows details of the databases and cubes of data defined on the Analysis Services server.

To see the Storage drilldown

Select a Spotlight on Analysis Services connection from the Spotlight browser.
Click Monitor | Storage.

Show all

To investigate...

Look at the...

Databases on the Analysis Services instance Databases page

Databases grid

Lists details of the databases in the Analysis Services instance.

Cubes Cubes page

Cubes grid

Shows information about the cubes that are currently defined on the Analysis Services server.

Related Topics

Spotlight on Analysis Services Drilldowns (page 1)

About Spotlight Charts (page 1)

About Spotlight Grids (page 1)

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating