Created a monitoring database, stored procedures and
SQL agent jobs to capture index fragmentation, database usage, table usage, LUN usage and stats.
Utilizing
SQL and SSRS, created process monitoring system providing alerts and charts to track, analyze and optimize critical
SQL Server
job agents across multiple production servers.