Part 2 of this series will show you how to tune the queries you found by using Workload Analysis (see Part 1). Additionally, we'll look at the different 'Context' dimensions to help you quickly focus on the right problem.
2. SQL Statements…
Part 2 of this series will show you how to tune the queries you found by using Workload Analysis (see Part 1). Additionally, we'll look at the different 'Context' dimensions to help you quickly focus on the right problem.
2. SQL Statements…
Database performance issues are a major contributor to the application slowdowns which we all face every day.
DBAs, developers and IT professionals have a daunting task of deciphering the large number of factors that contribute to database wait time.…
In this post, we looked at how to create an alarm template via the Databases dashboard.
If you followed the steps outlined, you would've ended up in the Alarm Templates dashboard with a new template.
You can also get to Alarm Templates directly from…
With the release of Foglight version 6, alarm management has been simplified with the use of alarm templates.
You can access Alarm Templates directly from the left-hand panel in the new UI. However, if you've upgraded from a previous version, it helps…
Postgres v. 14 snuck up on us and was released about a month ago.
The community continues to kill it with advancements in innovation.
Have a look at these frighteningly powerful enhancements and additions.
JSON:
PostgreSQL 14 now supports the syntax…
This is the second in a multi-part series on how to leverage Foglight to save money within your IT budgets. To review the first part, managing monitoring vendor sprawl, check out the post linked here.
This post is going to cover another way to save money…
For over two decades, as a Database Sales Engineer, I have provided technical demonstrations either in-person, online, or in a recorded format. It takes a particular honed skillset to accurately distill technical information and position solutions in…
We're often asked how to create an alarm threshold exception for certain types of objects. Using the Databases -> Configure Alarms dashboard, you can change thresholds at the instance level. That works great when there is a 1:1 relation between the instance…
I was trying to come up with a clever title for this post, and even googled "good network port jokes" but they were all blocked.
Badum-Tiss..
For this post, we can refer to this general Foglight architecture diagram.
The "Data Submission" and…
As part of one’s Database Management strategy, one of the primary tasks at hand is to keep queries running at peak performance. One of the most impactful ways to do this is to identify ‘Missing Indexes’.
Simply put, Indexes can allow…
"Rabbit, Rabbit!" - a superstition found in Britain and North America wherein a person says or repeats the words "rabbit", "rabbits" and/or "white rabbits" aloud upon waking on the first day of a month, to ensure good…
One of the most common questions I am asked when speaking with evaluators of Foglight is, “Can Foglight integrate with <insert solution here>? …Remedy, ServiceNow, SCOM, Splunk, Teams... The list goes on and on. This inquiry really comes as no…
I recently worked with a customer on the following use case. They've successfully integrated Active Directory logins with Foglight and wish to match up an AD Group with a group on the Databases dashboard in order to implement User Level Access (ULA).…
A customer asked how to implement and email that indicates an alarm has been cleared. In Foglight, there are typically several ways to do that.
In this post, we'll look at creating a new rule that fires when an alarm event occurs. The event we'll focus…
Many of us don’t like to ask for directions….
https://www.youtube.com/watch?v=mqVzRD_nWLQ&t=16s
That said, getting advice, directions, help, or suggestions will provide a faster path to success. My Dad always said, “When in doubt, read…
Time to wrap up automation of alarm blackouts in Foglight.
In this post, we looked at using the command line to implement alarm blackouts. We used topology queries to match a host name or pattern for an instance (eg. dbss_instance.name like '%YOW%').…
In this intro post, we looked at some basics of setting alarm blackouts via the command line. These commands can then be automated via script to include in a maintenance job, for example.
Any object can be referenced in the topology query - in this example…
There are two ways to manage blackouts in Foglight - from the UI and from the command line. The options are generally the same. The command line provides us the ability to automate the blackout by using the command line utility in our maintenance scripts…
In the previous post on User-Defined Collections (UDC's), we looked at using a view to hide the underlying objects of the query, and also the tip of setting the datatype to string.
In this final post, I'll show how to use a stored procedure in the…
By now you may have noticed that I focus on parts of Foglight that you can easily customize in order to solve your specific use cases. We'll build on the previous post on User-Defined Collections (UDC's) in Foglight.
In the previous post, our UDC…
In this post, some tips for working with User-Defined Queries (UDC's) were introduced.
We left off with the idea of creating a custom dashboard showing UDC results from multiple instances.
The Foglight data model is organized with a controlling root…
The ability to enter your own queries into Foglight for SQL Server, Oracle and DB2 opens up a world of additional data that you can use with Foglight. These are called User-Defined Collections, or UDC's for short.
There are some nuances to using them…
I've written about the Service Builder before, but I wanted to step back and go through the steps to create a "simple" service definition. This one will simply have some Oracle instances and some hosts (eg. App server, web server, etc.)
…OK, who took my Postgres tile? Where is my MySQL tile?
(Click on images to enlarge)
If you recently updated your Foglight license file, you may need to take a few additional administrative steps.
1. Navigate to Administration > Cartridges (Cartridge…