In SQL Optimizer for SQL Server we have built a very useful test run wizard (see my blog post Test Running a Tuned SQL is Not An Easy Job”) to help users select the best SQL alternatives for their spe...
What is a Redo Log Buffer?
The redo log buffer is a part of the Shared Global Area (SGA). This shared memory structure holds information about changes made to the database, called redo. Redo is genera...
