# DAshboard for SQL Database Performance

**URL:** <https://community.squaredup.com/t/dashboard-for-sql-database-performance/788>\
**Category:** Dashboard Server\
**Tags:** sqljobs, sql, dashboards\
**Created:** [August 30, 2018, 3:01am UTC](https://community.squaredup.com/t/dashboard-for-sql-database-performance/788 "2018-08-30T03:01:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![saiyadra](https://community.squaredup.com/letter_avatar_proxy/v4/letter/s/e274bd/32.png) [@saiyadra](https://community.squaredup.com/u/saiyadra)\
**Post date:** [August 30, 2018, 3:01am UTC](https://community.squaredup.com/t/dashboard-for-sql-database-performance/788/1 "2018-08-30T03:01:53Z")

</div>

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.

 ![SQL-view-1.png](https://community-cdn.squaredup.com/original/1X/7a402566b25687278b1504fb0e6d99af5494dcf7.png)

Any ideas

---

<div class="post-metadata">

**Author:** ![Jelly](https://community.squaredup.com/user_avatar/community.squaredup.com/jelly/32/812_2.png) [@Jelly](https://community.squaredup.com/u/Jelly)\
**Post date:** [September 3, 2018, 10:42am UTC](https://community.squaredup.com/t/dashboard-for-sql-database-performance/788/2 "2018-09-03T10:42:34Z")

</div>

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.

&nbsp;

Open Access is unauthenticated, allowing you to have all the objects and metrics you require, without any interactivity.

&nbsp;

[https://support.squaredup.com/v3/Deployment/UsersAndSecurity/AboutOpenAccess](https://support.squaredup.com/v3/Deployment/UsersAndSecurity/AboutOpenAccess)

&nbsp;

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.

&nbsp;

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

---

<div class="post-metadata">

**Author:** ![saiyadra](https://community.squaredup.com/letter_avatar_proxy/v4/letter/s/e274bd/32.png) [@saiyadra](https://community.squaredup.com/u/saiyadra)\
**Post date:** [September 12, 2018, 11:25pm UTC](https://community.squaredup.com/t/dashboard-for-sql-database-performance/788/3 "2018-09-12T23:25:47Z")

</div>

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

&nbsp;

What do i use for Database I/O??

How do I display Process and Resources Waitings view?

&nbsp;

Regards  
SR

---

<div class="post-metadata">

**Author:** ![nickd9999](https://community.squaredup.com/letter_avatar_proxy/v4/letter/n/58956e/32.png) [@nickd9999](https://community.squaredup.com/u/nickd9999)\
**Post date:** [September 14, 2018, 12:01pm UTC](https://community.squaredup.com/t/dashboard-for-sql-database-performance/788/4 "2018-09-14T12:01:08Z")

</div>

Hi

You can use the SQL Tile to query the DMV’s.

Regards  
Nick

---

<div class="post-metadata">

**Author:** ![Jelly](https://community.squaredup.com/user_avatar/community.squaredup.com/jelly/32/812_2.png) [@Jelly](https://community.squaredup.com/u/Jelly)\
**Post date:** [January 8, 2019, 12:14pm UTC](https://community.squaredup.com/t/dashboard-for-sql-database-performance/788/5 "2019-01-08T12:14:38Z")

</div>

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
