One of the most heard questions is: Why don’t I see the Performance widgets change colors in order to reflect the Health State of the currently selected SQL database?
The answer to it is relatively simple: RTFM (Read The Friendly Manual) .
As the guide related to this SQL MP states on pages 66 & 67:
’…Performance section contains eight performance collection rules, four of them can be linked with monitors. If linked monitors are disabled widgets display performance collection data without heath state indication…’
The 4 widgets that don’t work :
- DB Active Sessions;
- DB Active Requests;
- DB Active Connections;
- DB Transactions/sec.
The 4 widgets that work (AFTER the related monitors are enabled):
Syntax: <NR> Widget <> Monitor to enable:
- DB Total Free Space (%) <> Transaction Log Free Space (%),
- DB Total Free Space (%) <> DB Total Space,
- DB Avg. Disk ms/Read <> Disk Read Latency
- DB Avg. Disk ms/Write <> Disk Write Latency
SQL MP and the related MP guide can be downloaded from here.