Page History

The Baseline Configuration tab of the Monitored SQL Server Properties window allows you to configure your server baseline options. SQL Diagnostic Manager calculates a baseline out of a pool of collected data based on the selected period and collection interval , and is represented by mean, standard deviation, minimum, maximum, and count statistics.

...

• Effective alert thresholds - SQL Diagnostic Manager uses the baseline to provide alert recommendations which you can use to set effective alert thresholds.
• Effective baseline periods - Use the Baseline Visualizer to clearly visualize when to establish baseline periods.
• Alerting and recommendations -  Enable alerting based on baseline violations.
• Multiple baselines - Define and schedule multiple baselines per server.
  
• Quick propagation of baselines - Apply baselines to more than one instance.
• Baseline display in metric graphs - View relevant baseline in effect in various metric graphs of the Resources tab.

...

You can access the Baseline Configuration tab of the Monitor SQL Server Properties window by right-clicking the appropriate monitored SQL Server instance, and then selecting Baseline Configuration.

 Image Added Image Removed

Select a baseline period

...

SQL Diagnostic Manager allows you to add and schedule multiple baseline periods in addition to the default one. Open the Add baseline window by clicking the Manage Baseline button. For more information, see Schedule multiple baselines.

Anchor
multichange multichange

Apply the baseline to more than one instance

...

• Available Memory
• Batches Per Second
• Blocked Sessions
• Buffer Cache Hit Ratio
• Buffer Cache Size
• Checkpoint Writes Per Second
• Client Computers
• Data File Count
• Data File Space Allocated
• Data File Space Used
• Data File Space Used (Percent)
• Database Count
• Disk Queue Length
• Disk Time (Percent)
• Distribution Latency
• Host CPU Usage
• Host CPU Usage MHz
• Host Disk Device Latency
• Host Disk Kernel Latency
• Host Disk Queue Latency
• Host Disk Read
• Host Disk Total Latency
• Host Disk Usage
• Host Disk Write
• Host Memory Swap In Rate
• Host Memory Swap Out Rate
• Host Memory Active
• Host Memory Ballooned
• Host Memory Consumed
• Host Memory Granted
• Host Memory Usage
• Host Net Received
• Host Net Transmitted
• Host Net Usage
• Full Scans Per Second
• Lazy Writer Writes Per Second
• Lock Waits Per Second
• Log File Count
• Log File Space Allocated
• Log File Space Used
• Log File Space Used (Percent)
• Log Flushes Per Second
• Logins Per Second
• Oldest Open Transaction (Minutes)
• Open Transactions
• OS CPU Privileged Activity
• OS CPU User Time
• OS Memory Used (Percent)
• OS Total Processor Activity
• Packet Errors Per Second
• Packets Received Per Second
• Packets Sent Per Second
• Page Life Expectancy
• Page Lookups Per Second
• Page Reads Per Second
• Page Splits Per Second
• Page Writes Per Second
• Pages Per Second
• Physical Memory
• Procedure Cache Hit Ratio
• Procedure Cache Size
• Processor Queue Length
• Read Ahead Pages Per Second
• Replication Latency (Seconds)
• Replication Subscribed
• Response Time
• SQL Compilations Per Second
• SQL CPU Activity
• SQL Memory Allocated
• SQL Memory Used
• SQL Recompilations Per Second
• System Processes
• System Processes Consuming CPU
• Table Lock Escalations
• Tempdb GAM Wait Time Milliseconds
• Tempdb PFS Wait Time Milliseconds
• Tempdb SGAM Wait Time Milliseconds
• Tempdb Size
• Tempdb Size Percent
• Undistributed Transactions
• Unsubscribed Transactions
• Used Memory (Percent)
• User Connections (Percent)
• User Processes
• User Processes Consuming CPU
• Version Store Generation
• Version Store Size
• VM CPU Ready
• VM CPU Swap Wait
• VM CPU Usage
• VM CPU Usage MHz
• VM Disk Read
• VM Disk Usage
• VM Disk Write
• VM Memory Active
• VM Memory Ballooned
• VM Memory Consumed
• VM memory Granted
• VM Memory Swap In Wait
• VM Memory Swap Out Rate
• VM Memory Swapped
• VM Memory Usage
• VM Net Received
• VM Net Transmitted
• VM Net Usage
• Workfiles Created Per Second
• Worktables Created Per Second
  
  

SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.