SQL Server DBA tips
by Ted Krueger SQL Server DBA Tip 1 – Server Configuration – MAX MemorySQL Server DBA Tip 2 – Server […]
SQL Server
SQL Server
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
SQL Server
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
SQL Server
An XEvent a day
di Jonathan Kehayias (1 of 31) – An Overview of Extended Events(2 of 31) – Querying the Extended Events Metadata(3
SQL Server
31 days with SQL Server Management Studio
Una interessante panoramica sulle funzionalità del SQL Server Management Studio scritta da Russ Thomas. Day 1: Knowing Options Leads to
SQL Server
A SQL Server DBA myth a day
di Paul Randal (1/30) in-flight transactions continue after a failover(2/30) DBCC CHECKDB causes blocking(3/30) instant file initialization can be controlled