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…

Postgres version 12 is here. Did you miss its introduction like me? My excuse is the year-end holidays (what's yours?). 

Well, version 13 isn't planned for release until the fall, so there's plenty of time to brush up on v.12

To give the nod…

( * 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.

• “Excuse me while I kiss this guy”. Correct lyric: “Excuse…

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…

SQLServer Differential Backups make a lot of sense...they backup only what has changed. However, it seems that many Database Administrators choose not to leverage them. When digging into reasons for this, it is often because DBAs prefer to avoid some…

Spotlight 13.0 introduces a brand new feature of managing access to monitored connections at the user level. It provides the ability to assign or deny a user access to a set of connections that have been configured to be monitored in Spotlight.

The need…

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…

This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle.

Part 1 of the blog covers Foglight’s monitoring for Oracle’s Data Guard.

https://www.quest.com/community/quest/performance…

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…

In 12c, Oracle introduced support for a new architecture - multi-tenant. As such, the Container database (or CDB) was introduced. Think of the CDB as the 'super database'. This multi-tenant container database allows for many 'sub-databases'. These are…

Have you heard the news? PostgreSQL has earned the prestigious 'DBMS of the Year' award by DB-Engines!

**(Postgres won in 2017 as well!)

Who is DB-Engines (.com)?

Solid IT, an Austrian IT consulting company, created and maintains DB-Engines. Solid…

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.

• "Sweet dreams are made of cheese”. Correct lyric: “Sweet dreams are made of these” from The Eurythmics’…

PostgreSQL has entered an exciting new chapter with the release of version 11 (10/18/18). This blog highlights some of the version 11 additions and improvements to PostgreSQL.

** The information shared in this blog was largely gathered from the postgresql…

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…

One of the primary tasks of any DBA is to find and optimize poorly performing queries. This is not a trivial job as often times there is too much data to sort through and pinpoint problems. Quest’s Foglight provides alerts for Postgres queries that have…

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’.…

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 2) blog, the focus is SQL Server Reporting Services or ‘SSRS’.…

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 1) blog, the focus is SQL Server Integration Services or ‘SSIS’…

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…

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…

In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find it here -> https://www.quest.com/community…