GeezerVison is showing github.com — GitHub - vanterx/sqlserver-dba-scripts: 🚀 A curated collection of SQL Server DBA scripts for monitoring, performance tuning, backup/restore, Always On AG, security, and troubleshooting, plus links to essential community tools.
Folders and files
| Name | Name | Last commit message | Last commit date |
|---|
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
|
Repository files navigation
Essential DBA Tools & Resources
Key SQL Server Performance Counters
Memory - Available MBytes
Physical Disk - Avg. Disk sec/Read
Physical Disk - Avg. Disk sec/Write
Physical Disk - Disk Reads/sec
Physical Disk - Disk Writes/sec
Processor - % Processor Time
SQLServer: General Statistics - User Connections
SQLServer: Memory Manager - Memory Grants Pending
SQLServer: SQL Statistics - Batch Requests/sec
SQLServer: SQL Statistics - Compilations/sec
SQLServer: SQL Statistics - Recompilations/sec
System - Processor Queue Length
Performance Data Collection Commands
# Create performance counter log
logman.exe create counter Perf-Log -o "C:\PerfLogs\Admin\Perf-Log" -f bincirc -v mmddhhmm -max 500 -c "\Memory\Available MBytes" "\PhysicalDisk(*)\Avg. Disk sec/Read" "\PhysicalDisk(*)\Avg. Disk sec/Write" "\PhysicalDisk(*)\Disk Reads/sec" "\PhysicalDisk(*)\Disk Writes/sec" "\Processor(_Total)\% Processor Time" "\SQLServer:General Statistics\User Connections" "\SQLServer:Memory Manager\Memory Grants Pending" "\SQLServer:SQL Statistics\Batch Requests/sec" "\SQLServer:SQL Statistics\SQL Compilations/sec" "\SQLServer:SQL Statistics\SQL Re-Compilations/sec" "\System\Processor Queue Length" -si 00:00:01
# Start performance logging
logman start Perf-Log
# Stop performance logging
logman stop Perf-Log
# Convert binary log to CSV
relog C:\PerfLogs\Admin\Perf-Log_000001.blg /o C:\Perflogs\Admin\Reduced_Log_000001.csv /f csv
About
🚀 A curated collection of SQL Server DBA scripts for monitoring, performance tuning, backup/restore, Always On AG, security, and troubleshooting, plus links to essential community tools.
Topics
Resources
Stars
4 stars
Watchers
1 watching
Forks