Category Archives: Tutorials

SQL Server Wait Types

In this article we will talk about sql server wait type wait stats queues and some common wait types. These are the baseline of the performance tuning. This is not… Read more »

Database Internals

Checkpoint: Checkpoint is an internal process that writes all dirty pages (modified pages) from Buffer Cache to Physical disk, apart from this it also writes the log records from log… Read more »