This metric tells you whether a database is online, restoring, recovering, recovery pending, suspect, emergency, offline or does not exist on the server. Read more
Author: Louis Davidson
OS Wait Time: CXPACKET
CXPACKET waits may or may not be an issue for a system, but on an OLTP style system, they can indicate costly queries that are executing and requiring parallelized plans. Read more
OS Wait Time: Async_Network_IO
This metric gives you an indication of how much time is spent waiting to send information over a network. Read more
Average runnable task count
This metric gives an idea of how many task are in a runnable state and trying to execute in the system concurrently. Read more
CPU signal wait time
This metric measures the percentage of time spent waiting for CPU resources to service a thread. A high signal wait time for all wait types may indicate that CPUs are being overused, forcing tasks to wait for SQL Server processes. Read more