I recently spoke to a user of Spotlight on SQL Server Enterprise who wanted to be able to drill into the individual SQL Server instances that are participating in an Availability Group. The customer h...
I had a customer ask how they could use Foglight to find out when "dbcc checkdb" last ran against their SQL Server databases. This is a great use case for User-Defined Collections! As a refresher, my ...
Apologies to Rogers and Hammerstein; but the title fits. In addition to listening to the scores of old musicals, one of my hobbies is watching the weather. I have about 20 years of weather data in ...
Database performance monitoring can be a real circus! And with an ever-growing amount of technology platforms to manage, we’ve become the ultimate jugglers. Didn’t sign up to be a clown? Hey, I know...
For a Happy Halloween and a happy time anytime in Toad! Enjoy these five sugar free Toad Treats!! Toad Script Runner (TSR) - Have long running SQL Statements in Toad and think you need to open up a...
It is a foregone conclusion that performance monitoring is part and parcel of managing a database instance once it is in production. But what about pre-production? Especially when the instance itsel...
EPX provides electronic funds processing for debit and credit cards, electronic check transactions, and other financial transfers. The company interfaces with all the major credit card organizations a...
Understand that this is a general, high-level guide outlining the steps you should expect to take during a Foglight for SQL Server upgrade. Since environments and upgrade circumstances are often diffe...
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 reveal...
We've all been there, the dreaded ticket that comes across our inbox. Always light on detail, just a single sentence: "The database server is slow." No five words bring as much fear, uncertainty and...
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...
I often get asked about monitoring SQL workload that is consuming a database instance’s resources. The first question that comes to my mind is, “What is the symptom you are trying to resolve?” Are you...
