SQL Server 2008

Dependencies

Microsoft.SQLServer.2008.Discovery

Pack Contents

Dashboards

• SQL 2008 Performance
• SQL 2008 Servers

Perspectives

• Database (SQL 2008)
• SQL Instance (2008)
• SQL Server (2008)
• SQL Server 2008

Section Titles

Perspective Section Titles

• File Group
• Log Files
• SQL Instance
• Free Space %
• Alerts
• Active Connections
• Active Sessions
• Active Requests
• Active Transactions
• Databases
• Average Wait Time (ms)
• Thread Count
• Buffer cache hit ratio
• Lock Requests/sec
• Lock Waits/sec
• Number of Deadlocks/sec
• Transactions/sec
• CPU Utilization (%)
• Page Life Expectancy
• SQL Re-Compilations/sec
• Lock Timeouts/sec
• Logins/sec
• SQL Compilations/sec
• User Connections
• Instances
• State
• CPU
• Mem
• Connections

Dashboard Section Titles

• DB - Disk Space Free %
• Server - CPU Used %
• Server - Memory Used %
• User Connections
• Lock Waits / Sec (Keep close to 0)
• Thread Count
• Buffer Cache Hit Ratio (Closer to 100% the better)
• DB - Active Requests (What database is being used the most)
• DB - SQL Compilations/sec (Should be ~1/10th of Active Requests)
• DB - SQL Re-Compilations/sec (Should be ~1/10th of Compilations/sec)
• Buffer Page Life Expectancy (If below 300 server needs more memory)
• Servers