SQL Server with Mr. Denny:

Cache

1

November 24, 2011  2:00 PM

Always set the SEQUENCE cache size



Posted by: Denny Cherry
Cache, SQL Server

One of the really cool features of the new SEQUENCES which were introduced in SQL Server 2012 is that you can specify the size of the cache used for each sequence.  However Microsoft is recommending that when creating sequences you should always specify the cache size of the sequence.  This is...

January 17, 2011  2:00 PM

How much cache to allocate for servers that host 500gb databases?



Posted by: Denny Cherry
Cache, SQL Server, Storage

The short answer is as much as possible. The more exact answer is you typically can’t allocate cache to a specific LUN.  You can usually carve up the total amount of cache into read and write cache.  You want as much write cache as possible so that the database writes directly to the disk as...


November 22, 2010  11:00 AM

What should be done for a Transaction log drive (array) to make sure the log records are ON the disk, even if the power fails?



Posted by: Denny Cherry
Cache, SQL Server, Storage

This is a great question that I got a while back during a web cast that I did during the 24 Hours of PASS.  Most storage arrays, at least the better quality ones, have a battery within them which will keep a portion of the array online in the event of a power outage.  While the array won't be...


October 16, 2008  11:00 AM

Handy Query to look at amount of data in Buffer Cache



Posted by: Denny Cherry
Cache, SQL Server 2005, SQL Server 2008, sys.allocation_units, sys.dm_os_buffer_descriptors, sys.partitions, sys.tables

Here's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache.  It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk. SELECT...


June 10, 2008  6:39 PM

Article: SQL Server memory configurations for procedure cache and buffer cache



Posted by: Denny Cherry
Article, Cache, SQL Server 2000, SQL Server 2005

I've just published another tip over on SearchSQLServer.com.  This one is titled SQL Server...

Bookmark and Share     2 Comments     RSS Feed     Email a friend


May 22, 2008  3:37 PM

EMC World 2008 Day 3



Posted by: Denny Cherry
Billy Crystal, Cache, CLARiiON, EMC, EMC World 2008, Encryption

Wednesday at EMC World was a session packed day to be sure. I started my morning with CLARiiON Rebuild Settings and Data which was an in depth look at how exactly the CLARiiON systems handle rebuilds, and how long various rebuilds take.  In addition we went into detail as to how the CLARiiON...


May 1, 2008  9:00 AM

Checking the cached execution plans



Posted by: Denny Cherry
Cache, Execution Plan, Query tuning, SQL Server 2005, sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, sys.dm_exec_query_plan, sys.dm_exec_requests

As we all know SQL Server, will for good or bad, cache execution plans.  Up until now it's been very tough to see the cached execution plans.  You pretty much had to grab the query or procedure (with the parameters) and run it with Query Analyzer and have it return the execution plan.  The only...


February 13, 2008  10:37 AM

New Article: Configuring SQL Server memory settings



Posted by: Denny Cherry
Article, Cache, RAM, SQL

I’ve published a new tip over on SearchSQLServer.com entitled “   Bookmark and Share     0 Comments     RSS Feed     Email a friend


January 28, 2008  11:56 PM

Slide Decks and Sample Code from SoCal Code Camp



Posted by: Denny Cherry
Beta, Cache, CLR, Config, In Person Events, Query tuning, Resource Governor, SQL, SQL Server 2005, SQL Server 2008, SSMS

The SoCal Code Camp was this last weekend.  I had a great time attending and speaking at the code camp this time around.   I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them.  I did my best to make them as much fun and interactive as I...


October 22, 2007  10:17 AM

How SQL decides how much procedure cache and how much buffer cache to use.



Posted by: Denny Cherry
Cache, Config, SQL

There are two main types of cache which SQL Server deals with, the buffer cache and the procedure cache.  The procedure cache is where the execution plans for procedures and queries are stored.  The buffer cache is where the actual data is cached so that SQL Server doesn't have to go to disk to...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: