Skip to content

Monthly archives: Agosto, 2017

A DMV a day

by Glen Berry Day 1 sys.dm_os_buffer_descriptorsDay 2 sys.dm_exec_sessionsDay 3 sys.dm_os_sys_infoDay 4 sys.dm_os_sys_memoryDay 5 sys.dm_db_mirroring_auto_page_repairDay 6 sys.dm_db_index_usage_statsDay 7 sys.dm_db_missing_index_group_statsDay 8 sys.dm_fts_active_catalogsDay 9 sys.dm_os_schedulersDay 10 sys.dm_exec_procedure_statsDay 11 sys.dm_db_index_usage_statsDay 12 sys.dm_db_partition_statsDay 13 sys.dm_io_virtual_file_statsDay 14 sys.dm_os_wait_statsDay 15 sys.dm_os_performance_countersDay 16 sys.dm_exec_cached_plansDay 17 sys.dm_db_index_usage_statsDay 18 sys.dm_clr_tasksDay 19 sys.dm_os_wait_statsDay 20 sys.dm_exec_cached_plansDay 21 sys.dm_os_ring_buffersDay 22 sys.dm_exec_query_memory_grantsDay 23 sys.dm_os_process_memoryDay 24 sys.dm_exec_requestsDay 25 sys.dm_os_memory_cache_countersDay 26 sys.dm_exec_procedure_statsDay 27 sys.dm_tran_locksDay 28 sys.dm_io_pending_io_requestsDay 29 sys.dm_exec_connectionsDay 30 sys.dm_os_buffer_descriptors

A SQL Server hardware nugget a day

by Glen Berry Day 1  (Westmere-EP)Day 2 (Westmere-EX)Day 3 (AMD Opteron 6100)Day 4 (AMD Bulldozer)Day 5 (Hardware ID – DMVs)Day 6 (Hardware ID – Built-in)Day 7 (CPU-Z)Day 8 (Recommended Intel Processors)Day 9 (Recommended AMD Processors)Day 10 (Old Intel Processor Numbering)Day 11 (New Intel Processor Numbering)Day 12 (AMD Processor Numbering)Day 13 (Intel Turbo Boost)Day 14 (Intel …