After showing the really cool SQL 2012 Database dashboard a few times I’ve got some question that customers could not find the dashboard in their SCOM environment. Which is really odd if you have installed the complete SQL 2012 management pack from the online catalog, but the Dashboard MP are not available in the online catalog so that’s why it’s not there.
If you want the dashboard you have to download the SQL Management pack from the download site here: Download and install the management pack to get the MP’s that will import the dashboard into OpsMgr. SQL 2012 Management pack needs to in place!
The Management packs you need to import are:
After this you will find the SQL dashboard in the Microsoft SQL server => Databases => SQL Server 2012 Databases Summery dashboard. Note that only SQL 2012 databases will be showed in the dashboard!!
One of the really cool features is the widget that will show the related health state color so you have a quick overview of the selected SQL 2012 Database.
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 (stay blue). Since there are no monitors for DB Active Sessions, DB Active Requests, DB Active Connections and DB Transactions/sec they do not have health state indication. Next monitors are linked with top four performance widgets: Transaction Log Free Space (%), DB Total Space, Disk Read Latency and Disk Write Latency monitors. To make the widget represent the health state we have to perform the following action to override these four monitors.
To override these monitors go to the authoring pane select management pack and select monitors. Now past the first monitor name “Transaction Log Free Space” into the search bar and select the monitor in the SQL 2012 DB management pack. You can now enable this monitor to right click the monitor and select override “For all object of the class: SQL 2012 DB” and go to enable and select the check box. In the override column change false to true and save this setting in a SQL server override Management pack.
You need to full fill these steps for or four monitors below to make it work:
- Transaction Log Free Space (%)
- DB Total Space
- Disk Read Latency
- Disk Write Latency
By default the performance counters show a two day interval, if you want to change this to seven days you need select the settings image in the right top corner of the screen an changes the setting to the required one.
Read Full Post | Make a Comment ( None so far )