Performance Tuning Archives - Page 10 of 10

Performance Improvements with Oracle 11g Data Types

Learn how Oracle 11g provides a new data type that will reduce some of the overhead otherwise found using PL/SQL numbers.

1000% Performance Improvement Using Oracle 11g Result Cache

If you have a query that is executed often and reads data that rarely changes, result cache in Oracle 11g can significantly increase performance. Learn how.

Performance Tuning and Time Invested

Read a DBA’s point of view on investing time in performance tuning SQL queries and why it matters.

The forgotten MERGE statement: is it too underutilized?

Learn how the MERGE statement works in SQL Server 2008 and later and explore performance implications.

Wait Statistics are the Bread and Butter of Performance Tuning

Yes, it’s true. Don’t believe me? Fine then, would you believe Paul Randal? It’s a simple fact, really. If you know what your queries are waiting for, then you know how to improve performance. And that is why customers LOVE SolarWinds Database Performance Analyzer because we put the statements and waits right in front of […]

SQL Server WRITELOG Wait Type

WRITELOG wait types in SQL Server can indicate bottlenecks in the disk where the transaction log is stored or inefficient use of transactions. Learn how to tune for this wait type.