SQL Server Data cache

Introduction

SQL Server uses tools to monitor data, one of which is the dynamic management Management view (DMV).

General Dynamic Server Management Objects

• Dm_db_*: Database and Database objects
• dm_exec_*: Executing user code and associated connections
• dm_os_*: Memory, Lock, schedule
• Dm_tran_*: Transactions and isolation
• dm_io_*: Network and disk input and output

Data caching

For each database cache size in the current data cache, you can use the following DMV to query, sys.dm_os_buffer_descriptiors

Select COUNT(*)*8/1024x768  as 'Cache Size',        Casedatabase_id when 32767  Then 'Resourcedb'        Else db_name(database_id)End  as 'Database' fromsys.dm_os_buffer_descriptorsGroup  by db_name(database_id), database_idOrder  by 'Cache Size' desc

SQL Server Data cache