Spotlight’s SQL Server Replication Monitoring
Keeping an eye on your Agents, Publications and Subscriptions. Along with its main dashboards helping you watch your SQL Server and Windows core operational performance, Spotlight on SQL Server has s...
Diagnosing IO Latency with Foglight for Databases
Understanding the processes and configurations causing your bottlenecks IO is the single most important metric to know for creating optimal performance of your database systems. To understand it, you...
Diagnosing Blocking and Deadlocks with Foglight for Databases
Finding where and how things are getting locked up Aside from IO bottlenecks, locking-related problems are the pains most commonly mentioned in the demos that we here at Quest Software provide for cus...
Extend Spotlight on SQL Server with Custom Counters
Capture the SQL performance metrics that are uniquely important to your environment Spotlight on SQL Server arrives ready to collect and alert on all of the key SQL Server performance indicators that...
Customizing Spotlight on SQL Server Alarms
Tweaking performance monitoring to work exactly the way you want Spotlight on SQL Server comes ready out-of-the-box to help you navigate your SQL Servers’ performance metrics in real-time. The settin...
Finding your Heavy-Hitting SQL Statements with Foglight for Databases
A Brief Walk-Through of SQL Performance Investigator In a previous Foglight for Databases/SQL Server blog post, I provided a guide for navigating your database servers’ performance metrics in real-tim...
Three Routes Through an Ocean of Performance Metrics
Navigating Foglight for Databases Behind the opening screen of Foglight for Cross-Platform Databases lies a wealth of overview and detail screens to give you a clear picture of database performance ...
Making Connections with Spotlight on SQL Server
Spotlight on SQL Server provides excellent real-time monitoring, workload analytics and more for SQL Server. You can download the complete software for a 30-day trail on as many systems as you'd like...
Prevent Spotlight on SQL Server Shenanigans with User Roles and Security
Spotlight on SQL Server Enterprise‘s main purpose in life is to inform you of SQL Server performance problems, and then give you a quick way to diagnose their root causes so you can take action quickl...