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…
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…
If you are reading this, chances are you’re considering a 30 day trial of ‘Foglight for Cross Platform Databases’. Before you do, here are a few tips that will help you get a fully functional Foglight installation up and running quickly…
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…
We all get excited when our cell phone plan includes so called “Unlimited Data.” But, you know what happens if we push your luck. That’s right; we start to experience performance issues and get tossed into the dreaded 2G zone!
A similar…
Imagine this.... you're hosting a Holiday Party...and the phone rings. You answer and the person on the other end says with a tense voice, "I'm sorry but we will be unable to deliver your beer, wine, and liquor order. The product never shipped."…
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…
Congratulations! You have Foglight installed and it is collecting meaningful performance data. There’s no doubt it is providing a ‘smorgasbord’ of actionable information about your mission-critical environment. Help yourself to delicious servings of baseline…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It simply expires after the 30 days. There are a couple…
In an earlier blog, I wrote about a company’s success with Quest’s flagship SQL Server monitoring and diagnostics solution – Spotlight Enterprise. The blog detailed a customer success story and revealed detailed use cases explaining how this application…
During periods of scheduled maintenance, you may wish to prevent Foglight from sending alarms about the systems involved in the maintenance task. The use case is quite obvious. You know the system's down for maintenance and there's no need for you to…
Whether it’s hitting sys.dm_io_virtual_file_stats DMV with calculated queries, collecting Perfmon Disk Counter statistics, reviewing Resource Monitor Disk information, or keeping your storage admin close by, I/O issues are all too familiar a concern.…