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.
Any ideas
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.
https://support.squaredup.com/v3/Deployment/UsersAndSecurity/AboutOpenAccess
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
Hi Jelly,
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?
Regards
SR
Hi
You can use the SQL Tile to query the DMV’s.
Regards
Nick
As Nick mentioned, using the SQL tile to query the DB. 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