Understanding Oracle Explain Plans
Learn how to use the Oracle PLAN_TABLE and explain plans to guide performance tuning.
Read MoreMost Popular
How Oracle Architecture Affects Performance Tuning
Key aspects of Oracle architecture may impact tuning efforts. Learn more.
Read MoreHave you made these 5 database design mistakes?
Want to save your company money, headaches for end-users, and ensure data quality? Avoid these five database design mistakes.
Read MoreSQL Server Buffer Cache Hit Ratio
The buffer cache hit ratio details the percentage of pages found in the SQL Server buffer pool. Learn why it doesn’t tell enough about SQL Server performance.
Read MoreSQL Server NETWORKIO Wait Type
The NETWORKIO wait type occurs when SQL Server is waiting on the network for data to be sent to or from the server. Learn about performance impacts.
Read MoreSQL Server SOS_SCHEDULER_YIELD Wait Type
SQL Server instances with high CPU usage often show the SOS_SCHEDULER_YIELD wait type, which can indicate a need for further research and action.
Read MoreSQL Server sp_addmessage System Stored Procedure
Learn how to use the sp_addmessage system stored procedure to add error messages to SQL Server that can be referenced in code.
Read MoreSQL Server CXPacket Wait Type
SQL Server CXPACKET wait types mean there are queries running in parallel on the SQL Server instance and that they may be taking longer than desired to complete.
Read MoreOracle Log File Switch Completion
Log file switch completion is the time a session waits for recording and archiving changes to data through redo log generation. Learn about performance hits.
Read MoreOracle Buffer Busy Wait Event
Buffer busy wait occurs when a session tries to access a block in the buffer cache but the buffer is busy. Learn about performance impact.
Read MoreOracle Control File Read & Write Wait Events
The three control file read and write wait events all contribute to the time Oracle takes to keep the control file current. Learn more.
Read MoreSQL Server fn_dblog() Function Details and Example
DBCC LOG lets you view the commands in the Transaction Log file and can provide essential information about changes to data in the SQL Server database.
Read More