1. SQL Server Data Archiving Scheme
2. SQL Server High-availability scenarios
3. SQLIO simulate random or sequential ways to test disk IO performance
4. SQLIOSim Simulation of SQL Server behavior to test IO performance
5. Capture and store SQL Server performance counter data through DMVs
6. Collect SQL Server performance counters and create reports with SSRS
SQL Server default trace series:
7. SQL Server Default Trace--Introduction
8. SQL Server Default trace--capture event details
9. SQL SERVER default tracking app 1--Delete object events
SQL SERVER default tracking app 2-audit backup and recovery events
One . SQL SERVER Default tracking application 3--Detect DDL operations on tables
SQL SERVER default tracking app 4-Detect log file autogrow
SQL Server default trace report
This article is from the "Dripping Stone Wear" blog, please be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1582513
SQL Server blog post summary