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 colleague Trent Mera wrote a great blog on…
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 colleague Trent Mera wrote a great blog on…
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 different, it is important to review and familiarize yourself…
Managing production application databases has become more demanding than ever before not only due to the complexity of the applications they support, but also the very small margins for performance slowdowns or outages. Being proactive and resolving…
As the old saying goes, “the one constant in life is change”, and this is especially true in database environments. There are many reasons why database environments experience change whether it be through typical maintenance efforts such…
During a recent installation of Foglight for SQL/Oracle the DBA announced how excited he was to get Foglight installed because he was desperate to become a pro-active DBA and stop being a re-active one. Music to my ears!
So what was it about Foglight…
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 technologies like open source or NoSQL? With those changes…
I had a question recently from a customer. They were asking how to keep track of inactive SQL Server instances in Foglight so that the data can be removed. A flip side of this would be to check what instances they have being monitored vs. what is supposed…
Had a question from a customer today about backing up the Foglight for SQL PI database. The customer wants to automate this using command line and the reference guide asks you to deactivate the agent first, via the UI.
No problem, I said, there is always…