Foglight.. Start Your Engine!
This post is short but hopefully useful. When you start the Foglight server and navigate to the home page URL (http://foglight_server:8080 or https://foglight_server:8443), you may see a startup splas...
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...
Top 5 challenges of managing cross-platform databases
If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technol...
Toad Cross Country Vacation
Woohoo! Just got word that my boss approved my January vacation and now I’ll get the opportunity to check several items off my bucket list as I hop across country to the Quest Database Fed Forum in D...
How to Avoid Extinction in the Database Evolution
Friends. Change is here. All of us DBAs are dealing with it. Look at the number of new database platforms. It’s relentless. They just keep coming. And we’re expected to take on any or all of them that...
Customer Conversation: Diagnose SQL Server Instances in an Availability Group
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...
Foglight for SQL Server: Back to Basics – Diagnosing Blocking
I've done a number of posts recently that touch on Foglight administration, customization, or some of the more advanced capabilities of the product. I felt it was a good time to circle back on some o...
Integrate Foglight by Sending SNMP Traps
Many customers ask how they might integrate Foglight Alarms into other 3rd party monitoring tools. One way to accomplish this is to send SNMP traps in response to a Foglight alarm. To configure Fog...
Toad and Foglight in harmony – The PL/SQL Profiler
My favourite feature in Toad has always been the PL/SQL Profiler. I love the way it can profile your code executions is integrated with the editor. It is such an easy and visual feature to use. So if ...
You’re Fired! Wait, What has Fired?
Foglight has many out of the box rules to evaluate performance and availability conditions for your databases, virtual and physical infrastructure, web pages, network devices, etc. Once it has been ru...
Checking When DBCC CheckDB Last Checked Your DB
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 ...
Customer Conversation: Backup Escalation in Litespeed for SQL Server
A customer recently asked me to clarify the option "Enable Backup Escalation" in Litespeed for SQL Server. The customer has been using Litespeed for a while so I was a bit surprised the question was a...