Background
We are very excited to announce the general availability of Quest® Foglight® version 6.3.
Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…
We are very excited to announce the general availability of Quest® Foglight® version 6.3.
Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…
As organizations rely more on data to make critical business decisions, ensuring that their databases are running efficiently becomes increasingly important. A database slowdown or crash can result in a significant…
Spotlight reports are designed in SQL Server Report Definition files (RDL) and stored in the local installation folder of Spotlight client application making them accessible to Spotlight users. By default this path in Spotlight is C:\Program Files (x86…
Spotlight 13.0 introduces a brand new feature of managing access to monitored connections at the user level. It provides the ability to assign or deny a user access to a set of connections that have been configured to be monitored in Spotlight.
The need…
Just like most people’s goal towards incorporating more raw food into their daily diet, accessing and manipulating raw data is very much a coveted functionality.
The Spotlight Statistics Repository database is a repository for historical data collected…
Spotlight Enterprise 12.4 comes with some neat features you do not want to miss!
Query Execution Plans available when needed the most:
The Workload Analysis and the Query Execution Statistics drilldowns expose the most resource intensive transactions…
We’re excited to announce that with Spotlight version 12.3, the Plan Visualizer feature now includes several new enhancements. In my last blog, I covered the Plan Visualizer feature included in version 12.0 which provides a display view of the estimated…
Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.
In this (Part 3) blog, the focus is SQL Server Analysis Services or ‘SSAS’.…
Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.
In this (Part 2) blog, the focus is SQL Server Reporting Services or ‘SSRS’.…
We often get asked about the breadth and depth of Foglight when it comes to its monitoring scope. Whether it support for a multitude of relational, open source and NoSQL database platforms or providing the depth needed to identify the root cause of performance…
A Picture is worth a thousand words!
Execution plans can help us identify the performance hog sections of SQL code that impact CPU usage and I/O operations. Addressing these bottlenecks can ultimately help us achieve the best execution times. What if…
In every SQL Server instance the TempDB database is the common global resource for all the operations taking place and DBA's are particularly cautious about the use of it. Given the nature of applications and ad-hoc queries by users, one must keep…
The famous Yankee, Yogi Berra once said, “If you don't know where you are going, you'll end up someplace else.” This applies to lots of different things and since this is a blog about SQL, you likely know where I am going with this…