For environments that have lots of instances to be monitored, registering each of them one by one can be a bit time-consuming.
A time-saving alternative is to import your instance list from a file.
Step 1:
Right-click on the SQL Server node in the navigation…
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…
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…
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…
(Click images to enlarge.)
The conversation continues...
Jim: " Tell me more! "
Kim: " Foglight is Quest's award-winning cross-DBMS platform monitoring and diagnostics solution. Think of Foglight as a monitoring platform. It uses what they…
Spotlight users sometimes ask if it offers baseline capabilities. Though Spotlight does not learn a baseline of workload activity, it does provide the ability to view particular metric values over customizable timeframes. In doing so, it may allow for…
IT Administrators need to keep an eye on Availability, Performance, and Storage of mission-critical environments.
There are many things to consider as you develop a Monitoring and Diagnostics strategy.
Items to consider include:
Traditionally, DBAs are the ones primarily tasked with maintaining high availability and peak performance of the database environment. Therefore, they assume the responsibility of evaluating Performance Monitoring solutions. This requires identifying the…
Hey look, an Amazon Cloud!
To recap,
Part 1 covers 'As A Service' (...aaS) options - https://www.quest.com/community/blogs/b/performance-monitoring/posts/are-your-database-implementations-becoming-a-bit-cloudy-part-1-3-part-series-aas-the-world…
These are difficult times we are in now but we will persevere. Hopefully, you and your loved ones are staying safe and healthy. Most of us are anxious to get back to some sort of normalcy. But, for now, for many of us, the situation has created the need…
Foglight can help identify SQL Tuning candidates?
Yes!
Foglight can tune the SQL?
With seamless integration with Quest’s SQL Optimizer, yes!
OK, let’s stick a fork in this....
(Click on images to enlarge)
What is SQL Optimizer?
Caution…
In the spirit of keeping my blogs light and fun (?), the title was an attempt at that. In these interesting times (COVID-19 pandemic) and the need to stay home, I have been doing my share of yard work. It is the time of the year with lots of pollen in…
Cumulus, Stratus, Cirrus….no…not that THAT kind of CLOUDY.
The increasing number of cloud options can be confusing. With that in mind, I thought I’d ‘clear the air’ and review some of the more popular implementations.
…( * This blog has been updated from last year's.... )
We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics.
All is well. Megan is having a good day. She’s a SQLServer DBA and her environment is humming along. Then…. someone drops a critical table bringing efficient data retrieval to a screeching halt. Now what? It’s a weekday morning and business…
What’s that you say? You think it may not be appropriate that a technology blog dive into politics?
Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.
Administration options are available…
This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. These monitoring options come included at no additional cost and illustrate how broad and complete Foglight is as an Oracle monitoring solution…
April 15, 2019.....Let’s give a shout out to all those men and women running the Boston Marathon today.
Man, running for that long must be taxing. Taxing…..wait…what day is it again?
So, as my way of giving a nod to long runners,…
Hold on, grammar and spelling enthusiasts. Already, you might be thinking, did he mean ‘Complementary’ or ‘Complimentary’? The answer? YES. This blog series focuses on additional Oracle monitoring capabilities beyond monitoring the Oracle instance…’complementary…
Many things can happen if the database runs out of disk space. None of them are good. DBAs understand that it is essential to monitor database disk space so that critical business processes are uninterrupted. Quest’s Foglight provides peace of mind by…
To compare is to measure, estimate, or make note of two or more “ things’ “ similarities and/or differences. It helps us better understand the items. A versus B. Sometimes it is done to learn which one is ‘better’. Other times, it is to determine those…
Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.
In this (Part 3) blog, the focus is SQL Server Analysis Services or ‘SSAS’.…
Congratulations! You have Foglight installed and it is collecting meaningful performance data. There’s no doubt it is providing a ‘smorgasbord’ of actionable information about your mission-critical environment. Help yourself to delicious servings of baseline…
I often find Foglight for Virtualization environments that aren't taking full advantage of all the features of Foglight. One such feature is scheduled reports. Foglight comes with dozens of out-of-the-box reports waiting to be run.
Here is a list…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
