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...
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...
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...
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...
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'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...
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...
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 ...
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...
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 ...
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...
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...
