Monitor, Diagnose, Administer and Automate SQL Server Tuning

By: Edgewood Solutions | Read Comments | Print Edgewood Solutions is a technology company focused on Microsoft SQL Server and founder of MSSQLTips.com. Related Tips: More

Spotlight® on SQL Server Enterprise

Operational Monitoring, Diagnostics, Administration and Automated Tuning for SQL Server

Download Now!

Spotlight® on SQL Server Enterprise provides in-depth physical, cloud, and virtual SQL diagnostics. Intuitive overviews of enterprise health and performance, automated alerts and actions, and an integrated Xpert tuning module ensure optimal performance for your SQL Server, Analysis Services, VMWare ESX and SQL Azure database environments.

Spotlight makes it easy to:

• Understand your SQL Server infrastructure health at a glance
• Monitor SQL Server’s relational engine, Analysis Services, Windows, VMWare ESX and SQL Azure from a single console
• Customize built-in metrics and alarms
• Automate performance metric analysis
• Resolve issues quickly, including long-running processes, blocking locks, deadlocking and more

Features:

• Top SQL and Real-Time Query Plans – Pinpoint critical SQL statements based on index utilization, resource consumption, or query efficiency, and review run-time query plans
• High-Availability Support – Get in-depth information on your SQL Server clusters, replication, database mirroring, and log-shipping activities and environments
• Diagnostic Drilldowns – Automate CPU and I/O performance diagnosis and resolution
• Custom Performance Counters – Track and alarm on service level-specific processes as though they were metric counters to proactively handle performance issues
• Historical Playback – Navigate through up to two weeks of performance diagnostics and alarm data to resolve recent performance issues from any Spotlight management screen
• Custom Reporting and Trending – Understand health, activity, and capacity trends of your SQL Server enterprise with management and performance views, client-side reports, and the Spotlight® on SQL Server Enterprise Report Pack
• SQL Analysis and Xpert Tuning – Highlight long-running queries and bad code and tune, benchmark, and investigate indexing strategies through integration with Quest® SQL Optimizer for SQL Server (comes with Spotlight® on SQL Server Xpert)
• Spotlight Statistics Repository – Configure long-term metric data storage for historical trending and capacity planning initiatives
• Integrated Link to SQL Server Pedia – Get up-to-the-minute, context-specific advice on the performance issues you’re diagnosing from the experts
• Wait-Stat Analysis – Diagnose wait statistics to determine where waits are occurring and what is causing the event
• Deadlock Detection and Review – Gain full visibility of deadlock events and the conditions that caused them
• Windows-Only Connections Views – Add Windows-only connections to Spotlight’s views

Download Now!

 

 

Related Tips: More | Become a paid author

Last Update: 4/26/2011

Share:

Share

Tweet

Connect with MSSQLTips.com Follow us on twitter... Let's connect on facebook! Join us on Google+

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen." Write, edit, and explore SQL effortlessly with SQL Prompt. SQL Servers keeping you up at night? Contact the Edgewood SQL Server DBAs for a Health Check. Prices start at $995. Get SQL Server Tips Straight from Kevin Kline. Join the over million SQL Server Professionals who get their issues resolved daily. The SQL Server Security THREAT - It’s Closer Than You Think