I do not have a fixation on ring buffers but I keep finding them in my path. For example, recently I was writting about the new DMVs introduced by SQL Server 2008. One of the sys.dm_os_memory_brokers DMV returns information about memory brokers. [quote] Allocations that are internal to SQL Server use the SQL Server memory manager. Tracking the ...

Recently my article on Dynamic Management Views and Functions from AspToday became a featured articled which means that you can read it for free. I wrote it a year ago but it can still give you a good start with DMVs and DMFs. If it's worth it you can decide by clicking this link: SQL Server 2005 Dynamic Management and Views

A year and a half ago I wrote about the undocumented Dynamic Management View sys.dm_os_ring_buffers in SQL Server Professional. Shortly the ring buffers expose internal server state information about memory, exceptions, or schedulers. Each ring buffer is giving you 64K of live information that you can get usually using a trace, by ...

Script Repository: SQL Server 2005 If you follow the above link you will find scripts that will help you manage your SQL Server. To give you an idea of what you can get from this site I included the list of topics:Buffer CacheCPU and OptimizationIndexes and IndexingInput/OutputPerformance (General)Processor CacheSQL ...