Foglight Infographic highlight compelling Tech Validate survey statements/results/research findings. Each statement will be supported by a customer quote.
Do you have a large SQL Server estate, which is complex to manage, contains a mixture of on-premises and cloud databases, multiple editions, many SQL Agent jobs, and large backups that need to be encrypted? And, what about recovery and auditing?
Databases and applications are not islands in a calm sea. They run as part of a bigger infrastructure, perhaps as a virtual machine on-premises or in the cloud. Poor conditions in that environment will have an impact on the availability and performance o
RAC for SE is gone – what are your options? Since Oracle19c, RAC is no longer available for Standard Edition (SE) databases. A year later, Oracle announced a high availability (HA) concept for SE, but it is merely a standby database requiring downtime dur
Learn how to quickly identify the root cause of performance anomalies in databases, applications and infrastructure. Get an overview of extensible architecture, statistical methodology for performance anomaly detection and diagnosis using Foglight® for Cr
Frustrated with query tuning? Learn an Oracle ACE Director’s tips to quickly find and fix slow queries.
Learn Brent’s tips to fix deadlocks. He’ll discuss tables in long transactions and why you need to work through them in a consistent order and touch them as few times as possible; then, he'll rewrite a stored procedure that's having deadlocking problems.
Speaker: Brent Ozar
If you've managed database performance, you've come across the wait types CXPACKET and CXCONSUMER. You've seen a lot of conflicting instructions on how to go about fixing them, and you know that setting MAXDOP to 1 isn't the right thing to do. Learn what happens when SQL Server parallelizes queries correctly, what causes parallelism to go awry, and what you can do about it.
MySQL query tuning. See how to monitor and review the execution plan.