It’s easy to start tinkering with the gears of SQL query optimization. You open up SQL Server Management Studio (SSMS), monitor wait time, review the execution plan, gather object information and begin optimizing SQL until you’re running a finely…
It’s easy to start tinkering with the gears of SQL query optimization. You open up SQL Server Management Studio (SSMS), monitor wait time, review the execution plan, gather object information and begin optimizing SQL until you’re running a finely…
We’re all in the same global boat. In response to COVID-19, and to curtail the spread and keep employees and the general population well, companies worldwide have suddenly sent their employees home to work.
In case you missed the December webcast, “Mitigate Your Oracle Database to AWS Cloud Migration Challenges,” you can catch the replay on Quest.com.
Representing Quest® is John Pocknell, senior solutions product manager in information management…
Foglight SQL Performance Investigator (PI) is a powerful workload analysis tool set for database professionals, which brings deep visibility into database performance. It comes with unique features such as historical multi-dimensional analysis…
It’s common for IT solutions to solve a challenge or two. What’s uncommon is the vast amount of database challenges you can solve with SharePlex®. This affordable data replication solution is a powerhouse of a tech tool, regarded as the…
With the pressures they face every day, database administrators and developers sometimes need a friendly voice of encouragement – someone who understands their struggles and can speak their…
How is your database performance holding up in the midst of all the #WorkingFromHome (WFH)? Are you relying on database monitoring more than before COVID-19? Less? About the same?
It’s not so hard to combine database monitoring with keeping social…
As part of Quest’s Database Training Days webcast series, Oracle ACE Janis Griffin presented her top 5 Oracle performance tuning tips. Janis’ webcasts are always packed with valuable information, and this one didn’t disappoint as she imparted her…
It’s always an educational experience to listen to Oracle ACE Director, Janis Griffin talk about database performance tuning and the features that help make life easier. In a recent Database Training Days webcast session, Janis brought a whole new…
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…
Brent Ozar knows all about going fast – he races cars and he revs up SQL Servers with breathtaking performance results daily. In his recent webcast “How to Measure SQL Server,” for Quest’s Database Training Days series, Brent reminded…
According to Microsoft SQL Master, Brent Ozar, he’s made some terrible database performance tuning decisions throughout his career. Luckily for us, we can benefit from his mistakes and don’t have to figure everything out on our own. He’s shared his hard…
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.
We all get excited when our cell phone plan includes so called “Unlimited Data.” But, you know what happens if we push your luck. That’s right; we start to experience performance issues and get tossed into the dreaded 2G zone!
A similar…
Sure, it’d be great if you’re Fozzie Bear or some other old-timey comedian. But for the rest of us? It would totally suck.
Spaghetti, a pile of sad, limp noodles…
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…
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…