I would like to create a dashboard for performance view for one particular server.
The DBA’s have access to the SQL server but not the Tech Team.
I would like to create the view below in SquaredUp and put it on the board for my Team.
Create the dashboard as you would normally (presumably as a SCOM Admin who can see everything), then share with Open Access the dashboard and give the URL to the relevant teams.
Open Access is unauthenticated, allowing you to have all the objects and metrics you require, without any interactivity.
The caveat here is that SCOM tasks won’t run in Open Access, as the user that loads the page is a read only operator (see Admin > user roles > squared up open access). You can create an operator role with access to only the tasks that you want to display on an OA dashboard added, but this can be a security hole.
As Nick mentioned, using the SQL tile to query the DB, to gain the Process and Resources Waitings. For the performance metrics, you would need to ensure that they are collected by SCOM. It’s likely that they are contained in the MS SQL MP, but not enabled by default. worth having a look in SCOM under Authoring to find out
What i am looking for here is how to get the display with the correct details as in the SQL Mgmt Studio view shown above.
For example, i can use %CPU Utilisation for % Processor Time.
Locks Waiting for Waiting Tasks
Transactions/sec for Batch Requests/sec
What do i use for Database I/O??
How do I display Process and Resources Waitings view?