Mythbusting the Role of Hardware in SQL Server Performance
SQL Server and database experts share insights on how hardware does and does not impact performance.
Read MoreMost Popular Performance Tuning
Partition Tables–Implementing Techniques for Query Enhancement
Learn how to check query performance to see if partitioned tables have made SQL Server faster.
Read MorePartition Tables—Ways to Improve SQL Server Performance
Learn more about why and how to use partitioned tables in SQL Server to improve performance.
Read MoreNot If But When: Best Practices for SQL Server Virtualization
Learn from SQL Server MVPs and virtualization experts about best practices for virtualizing SQL Server.
Read MoreMust-know Tips and Tools for Oracle Virtualization
Learn from Oracle ACE Directors and virtualization experts about tips and tools for virtualizing Oracle.
Read MoreMonitoring Commit Times Without Application Instrumentation in Oracle
Learn how knowing log file sync wait times in Oracle enables a good database commit time approximation, and how this can help you better tune performance.
Read MoreCURSorED Performance: overlooked Oracle configuration settings
Learn how one company addressed latency issues after an Oracle database migration by revisiting configuration parameters.
Read MoreHardware or code? SQL Server Performance Examined
Most database performance issues result not from lack of enough CPU power or IO or other hardware constraint, but rather from poorly written queries and inefficiently designed indexes. Learn more.
Read MoreChanging Default Database File Locations in SQL Server
It’s important to understand how the default locations for the SQL Server data and log file are determined, and how you can specify the locations when creating the database.
Read MoreImprove SQL Server Performance by Looking at Plan Cache (Part 3)
Starting in SQL Server 2008, you can examine the plan cache to quickly identify plans that are similar and may be optimized. Learn how.
Read MoreImprove SQL Server Performance by Looking at Plan Cache (Part 2)
Examining the SQL Server plan cache can help you to quickly identify plans that need tuning, including: plans that have missing indexes, plans that are performing key lookup and plans with implicit conversion warnings.
Read MoreImprove SQL Server Performance by Looking at Plan Cache (Part 1)
The SQL Server plan cache stores details on statements that are being executed over time, and you can use it to investigate performance issues and look for opportunities to improve performance. Learn how.
Read More