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

SQL SERVER – Plan Cache and Data Cache in Memory

December 28, 2010

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

I get following question almost all the time when I go for consultations or training. I often end up providing the scripts to my clients and attendees. Instead of writing new blog post, today in this single blog post, I am going to cover both the script and going to…

SQL SERVER – Minimum Maximum Memory – Server Memory Options

October 30, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Memory

I was recently reading about SQL Server Memory Options over here. While reading this one line really caught my attention is minimum value allowed for maximum memory options. The default setting for min server memory is 0, and the default setting for max server memory is 2147483647. The minimum amount…

SQL SERVER – Queries Waiting for Memory Allocation to Execute

October 9, 2009

Pinal Dave

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

SQL Memory, SQL Scripts

In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not…

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

March 20, 2009

Pinal Dave

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

Best Practices, Database, SQL Memory

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.