How to see what is in your buffer cache

If you have ever wondered what database or tables/indexes were consuming the most memory/buffer in your database, this post can help with that. How do I see this? The key DMV’s to view this  are sys.dm_os_buffer_descriptors, sys.allocation_units, and sys.partitions.  The key piece to identifying what is currently in the buffer cache is sys.dm_os_buffer_descriptors.  The use […]

Read More

Are VARCHAR or CHAR Hurting Your Performance Due To Implicit Conversions?

A common issue I’ve seen with code developed in ADO.Net is parameterized SQL performing full scans as a result of implicit conversions (despite appropriate indexing).  This seems to occur most commonly if a database uses VARCHAR/CHAR datatypes as opposed to NVARCHAR/NCHAR datatypes.  I’ll explain later in this posting why VARCHAR and CHAR datatypes seem to […]

Read More