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…
In the recent 5.7.5.50 release of Foglight for SQL Server, a change was made to the TempDB drilldown. Specifically, the Sessions tab would formerly show the current sessions, regardless of the time range selected on the dashboard. Now, it will allow you…
There are so many things you never want to hear in life:
But few things are worse…
Now you've successfully configured Toad's Team Coding with your preferred version control system, how does Team Coding actually work? Watch this video to learn how simple the process is and how Team Coding also ensures that the integrity of your database…
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…
I’ll admit, the concept of the DBA workaholic used to be an oxymoron. Not too long ago, many of us worked strictly in “Oracle shops” where we had time to indulge our photography hobbies in between tasks. I don’t know about you, but I used to do a fair…
Spotlight’s vast alarm customization capabilities enables users a wide variety of options. Setting alarm severity levels, their start and end threshold values, or disabling them completely are just a few. Fortunately, Spotlight performance moni…
I’ve been interested in weather, meteorology and clouds in the sky for as long as I can remember; which may explain why one of my favorite songs is Joni Mitchell’s “Both Sides Now”. I’ve learned that some clouds are pretty, and…
In a previous post, I explained how to customize alarms in Spotlight on SQL Server Enterprise. Recently, I had a customer inquire how he could refine the "Days Since Last Full Backup" alarm. He wanted to be able to exclude specific databases, but specify…
A Picture is worth a thousand words!
Execution plans can help us identify the performance hog sections of SQL code that impact CPU usage and I/O operations. Addressing these bottlenecks can ultimately help us achieve the best execution times. What if…
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…
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 most enterprises need to know about. The out-of-the…
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…
Am 10.4. 2018 findet das siebte Foglight Anwendertreffen in Köln statt. Das Treffen bietet Ihnen die Möglichkeit, sich über Neuheiten und Entwicklungen im Bereich Foglight zu informieren und Erfahrungen auszutauschen. Die Referenten kommen aus den technischen…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
The new year kicked off with some big news on January 3rd, 2018 with the news of the Meltdown and Spectre chipset vulnerabilities. There are a lot of resources available to understand the details and potential impact. This one from cnet.com is pretty…
Are you looking for a simpler, more effective way to carry out code quality reviews of all your Oracle PL/SQL code that takes subjectivity out of the equation and gives you the foundation for an automated way to review your code as part of a DevOps process…
Is your organization moving to agile development and DevOps and you now have to test your Oracle PL/SQL code and have no idea what to do? Your worries are over! With Toad for Oracle, creating some simple PL/SQL unit tests to get started is really easy…
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…
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’ll save our companies money. But it’s hard, right…
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. I didn’t, either. But, listen, sometimes…
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 looking to understand the root cause of compute resource…
Merriam-Webster defines ‘Custom’ as made or performed according to personal order. Tailored, fitted, personalized…or ‘pimped out’, slang meaning something is modified to extreme performance. There was a television series called …
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…
