When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.  Read more...

Describes the gains experienced in my environment by impleenting AWE.  Read more...

Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.  Read more...

Tweaking SQL Server memory settings to provide support for managed code.   Read more...

Often I tell clients better to much memory than too little. This can be applied to any database engine essentially. If your data set is growing over time you will end up using any memory that is not consumed today.  Read more...