Databases Archives - Page 56 of 58

SQL 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.

SQL 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.

SQL 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.

SQL 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.

Oracle 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.

Oracle 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.

Oracle 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.

SQL 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.

SQL Server OLEDB Wait Type

OLEDB wait types in SQL Server indicate that a query is waiting on something outside of the SQL instance. Tuning the query will involve tuning what is being accessed.