System Center 120 R2 Operations Manager SQL 2012 Dashboard not available

Posted on 9 December, 2013. Filed under: opsmgr, SCOM 2012 | Tags: , , , |

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:

  • Microsoft.SystemCenter.Visualization.Component.Extensions.Library.mpb

  • Microsoft.SQLServer.Presentation.mp

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.

image

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.

Regards,
Walter Eikenboom
http://systemcenterdynamics.wordpress.com


Read Full Post | Make a Comment ( None so far )

Recently on System Center Dynamics by wwwally…

What can System Center Advisor in OpsMgr 2012 R2 do for you!

Posted on 3 December, 2013. Filed under: Advisor, opsmgr, System Center 2012 R2 | Tags: |

What is Service Reporting in System Center 2012 R2

Posted on 27 November, 2013. Filed under: System Center 2012 R2 | Tags: |

Audit Collection Services (ACS) on System Center Operations Manager 2012 SP1 with Dynamic Access Control

Posted on 18 November, 2012. Filed under: SC2012, SCOM 2012 | Tags: , , , |

Service Manager 2012 Data warehouse jobs

Posted on 15 October, 2012. Filed under: Uncategorized |

Auto close process automation for Service Manager 2012 (and SP1) with PowerShell

Posted on 1 October, 2012. Filed under: SCSM | Tags: |

Global Service Monitor on OpsMgr 2012

Posted on 16 July, 2012. Filed under: SCOM 2012 | Tags: , , |

System Center Advisor an Overview

Posted on 25 May, 2012. Filed under: Advisor | Tags: |

Deploying Lync Jump Start series with free virtual LAB!!

Posted on 26 April, 2012. Filed under: Uncategorized |

SCOM 2012 distributed management group topology

Posted on 16 March, 2012. Filed under: SCOM 2012 |

Liked it here?
Why not try sites on the blogroll...

Follow

Get every new post delivered to your Inbox.