spotlight on sql server
Skip this Video
Download Presentation
Spotlight™ on SQL Server

Loading in 2 Seconds...

play fullscreen
1 / 14

Spotlight™ on SQL Server - PowerPoint PPT Presentation

  • Uploaded on

Spotlight™ on SQL Server. Powerful Diagnostic and Resolution Tool for Microsoft SQL Sever Databases. High Availability. Application Offloading. Monitoring & Diagnostics. DB Server Development. Performance Tuning. The Quest Application Management Platform. DEVELOP/DEPLOY. MANAGE.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Spotlight™ on SQL Server' - Antony

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
spotlight on sql server

Spotlight™ on SQL Server

Powerful Diagnostic and Resolution Tool for Microsoft SQL Sever Databases

the quest application management platform
High Availability

Application Offloading

Monitoring & Diagnostics

DB Server Development

Performance Tuning

The Quest Application Management Platform



Quest Monitoring Solution


Quest Foglight®

e-Business, Commerce One, PeopleSoft, Exchange, Oracle Apps, Siebel, SAP,WebLogic, WebSphere,SharePlex®



Spotlight™ Products

Oracle, SQL Server & DB2 UDB

Exchange &Windows

EMC, Oracle Apps,SAP & Web Servers


Coming Q1 2001

Coming Q2 2001

problems facing sql server dbas
Problems Facing SQL Server DBAs
  • Responsible for installing, configuring, administrating and troubleshooting Microsoft SQL Server.
  • Majority time is spent performing troubleshooting and solving issues.
  • Performing numerous tasks besides Database Administration
  • No sophisticated diagnostic tool to measure database performance.
  • Lack the ability to quickly identify, troubleshoot and resolve database bottlenecks.
spotlight on sql s erver will
Spotlight on SQL Server Will…
  • Eliminate time-consuming guesswork by identifying source of problem
  • Immediately pinpoint database bottlenecks
  • Easily drilldown to details of problem areas with a few mouse clicks
  • Automatically calibrate to set normal activity baseline
  • Provide performance thresholds to predict problems before they occur
  • Get expert advice from online tuner
what is spotlight on sql server
What is Spotlight on SQL Server?
  • Shows a visual representation of real-time SQL Server process flows
  • Automatically sets a baseline for normal database activity
  • Displays the details of problem areas for rapid problem resolution
  • Alerts DBAs with an audio or visual alarm
  • Will operate with Foglight® for 24x7 unattended monitoring of systems, databases & applications
product differentiation microsoft
Product Differentiation(Microsoft)
  • Spotlight provides a complete picture in one screen
  • Raw data versus information
  • Increase in efficiency by rapidly identifying bottlenecks
  • Online tuner for rapid resolution of problem
  • Thin client – only 5 MG
spotlight important facts
Spotlight Important Facts
  • Currently GA
  • Spotlight Supports the Following:
    • Windows NT & 2000 (Client Side)
    • Microsoft SQL Server 7.0 & SQL Server 2000
out of the box diagnostics
Out of the Box Diagnostics

Understanding Cause and Effect:

  • Many application issues are generated by individual users
  • When user requires resolution of an issue, the pressure is on to provide swift results
  • Isolate cause from effect within the subsystem
  • Highly graphical representation of cause and effect and rule-based diagnostics
  • Support leading applications and infrastructure
  • Instant ROI and value
emercandise com and spotlight
Response to a TV ad campaign overwhelmed the Web site

Quest’s Spotlight located the bottleneck in 15 minutes vs. the estimated 10 days

Spotlight recommended a solution that increased Web page access by 2500% andSpotlight™

“Fifteen minutes after I

installed Spotlight™,

I was able to diagnose

a problem, correct it and

dramatically boost

performance for my


  • Tom Cox, DBA

TrueNorth Consulting

in summary

In Summary

Quest Software offers the most complete monitoring, diagnostics and high availability solutions on the market today.