SQL scripts commonly used by DBAs in production server environments:
Some SQL scripts commonly used by DBAs in production server environments : Script to Monitor Blocking Queries: SELECT r.session_id, r.blocking_session_id, t.text AS [SQL Text] FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t WHERE r.blocking_session_id <> 0; Script to Monitor Server Performance: SELECT [object_name], [counter_name], [cntr_value] FROM sys.dm_os_performance_counters WHERE [object_name] LIKE '%:SQLServer%' AND [counter_name] IN ('Batch Requests/sec', 'Transactions/sec', 'User Connections') ORDER BY [object_name], [counter_name]; Script to Identify Index Fragmentation : SELECT dbschemas.[name] + '.' + dbtables.[name] AS [Table Nam...