Image by Mohamed Hassan from Pixabay TempDB provides a workspace for temporary data storage during query execution and plays a crucial role in the performance and stability of SQL Server databases. To ensure optimized performance in your specific environment, it is important to follow best practices for TempDB. In this blog post, we will discuss … Read more 6 Best Practices for SQL Server TempDB

If you are utilizing a SQL Server, monitoring needs to be an essential part of your database management process. Without keeping a close eye on your Microsoft SQL Server performance, you run the risk of increased performance-related outages and incidents along with potential higher costs. With effective monitoring, you can reduce risk and take the … Read more SolarWinds SQL Sentry vs. Idera Diagnostic Manager

The most common databases used today are relational databases, where data is stored in interconnected tables. You query those tables using Standard Query Language (SQL). To get the most value of the SQL databases you use as a developer, system administrator, or database administrator, it’s vital that you have visibility into what’s going on. That … Read more The Most Effective SQL Server Activity Monitor Strategy

Microsoft SQL Server®, a leading relational database management system, was first launched in 1993 and specifically designed for Microsoft Windows. Since then, the system has grown in popularity thanks to its centralized tooling, ease of administration, and common authorization and security settings. That popularity led to Microsoft’s re-architecture of SQL Server in 2016, designed to … Read more 3 Benefits of Running SQL Server on Linux

The Oracle “log file sync” wait event is triggered when a user session issues a commit (or a rollback). The user session will signal or post the LGWR to write the log buffer to the redo log file. When the LGWR has finished writing, it will post the user session. The wait is entirely dependent … Read more Oracle Log File Sync Wait Event

About the direct path read temp wait event When a session reads buffers from disk directly into the PGA, the wait is on direct path read temp. This is closely related to the direct path read wait. If the I/O subsystem doesn’t support asynchronous I/Os, then each wait corresponds to a physical read request. If … Read more Oracle Wait Event Explained: Direct Path Read Temp

The db file sequential read wait event has three parameters: file#, first block#, and block count. In Oracle Database 10g, this wait event falls under the User I/O wait class. Keep the following key thoughts in mind when dealing with the db file sequential read wait event. Common Causes, Diagnosis, and Actions The db file … Read more Understanding the Oracle db file sequential read Wait Event

In order for DDL (Data Definition Language) to execute, it must acquire a row cache lock to lock the data dictionary information. The shared pool contains a cache of rows from the data dictionary that helps reduce physical I/O to the data dictionary tables and allows locking of individual data dictionary rows. The locks on the … Read more Oracle Row Cache Lock Wait Event Explained

When a session waits on the “read by other session” event, it indicates a wait for another session to read the data from disk into the Oracle buffer cache. If this happens too often the performance of the query or the entire database can suffer. Typically this is caused by contention for “hot” blocks or … Read more Oracle Read By Other Session Wait Event

The fn_dblog() function (formerly known as the DBCC command) is one of several undocumented functions for SQL Server; it allows you to view the transaction log records in the active part of the transaction log file for the current database. Note that use of the fn_dblog() function (and all other undocumented commands) against a production … Read more SQL Server fn_dblog() Function Details and Example