SQL Memory Archives - Page 14 of 14 - SQL Authority with Pinal Dave

March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words

March 20, 2009

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

I was asked question by Jr. DBA that “What is AWE?”. For those who do know what is AWE or where is it located, it can be found at SQL Server Level properties. AWE is properly explained in BOL so we will just have our simple explanation. Address Windowing Extensions…

SQL SERVER – DBCC Commands to Free SQL Server Memory Caches

May 3, 2007

Pinal Dave

SQL Tips and Tricks

SQL Memory, SQL Scripts, SQL Server, SQL Server DBCC, SQL Stored Procedure

Lots of people do not know that following command can be very helpful to clear your memory caches of SQL Server. I have often seen people restarting their entire system to clear the memory caches.