---
parser: v2
auto_validation: true
primary_tag: products>sap-hana-dynamic-tiering
tags: [ tutorial>beginner, products>sap-hana, products>sap-hana-dynamic-tiering, products>sap-hana-studio, topic>big-data, topic>sql ]
slug: dt-monitoring-hana-part4
canonical_url: https://developers.sap.com/tutorials/dt-monitoring-hana-part4
---

# Additional checks in SAP HANA Cockpit and SAP HANA Studio
<!-- description --> Performing additional checks for SAP HANA

## Prerequisites  
 - **Proficiency:** Beginner
 - **Tutorials:** [Stopping and Restarting the Extended Storage Service](https://developers.sap.com/tutorials/dt-monitoring-hana-part3.html)

## You will learn  
 - Check used memory and set alerts
 - Perform `Dbspace` checks
 - Check which extended storage/dynamic tiering tables have been created
## Time to Complete
**10 Min**

---

### Check Used Memory and Set Alerts

In SAP HANA Cockpit, you can view some of the statistics for each host that you are running. Navigate to your resource and then click on "**Memory Usage**" as shown below.

![Memory Usage](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-monitoring-hana-part4/memory-usage.png)

You will be taken to the following screen where you can see how much memory is being used. You can also choose which services and hosts you want to see used memory for by selecting them in the "**Services & Hosts**" section.

![Used Memory](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-monitoring-hana-part4/performance-monitor.png)

Furthermore, as an administrator, you can also manipulate the thresholds of various alerts. Alerts are already predefined in the system, and you can adjust the threshold of these alerts as desired. There is a pre-requisite step that needs to be done for such authority. You need to go to SAP HANA Studio, open "Administration" and go to the "Configuration" tab. Click on the drop down of "`nameserver.ini`" followed by "`statisticsserver`". Double click on "**active**" and you can set the new value to be "**true**". Click "**Save**".

> Note: If you are unable to edit the value of "active" by double clicking then make the change using the `SYSTEM` user.

![Set statisticsserver to True](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-monitoring-hana-part4/give-authority.png)

Next navigate back to your resource on SAP HANA Cockpit and click on "**Configure Alerts**".

![Navigate to Configure Alerts](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-monitoring-hana-part4/navigate-configure-alerts.png)

In the search bar on the left side, search for the Dynamic Tiering "`Dbspace usage`" alert type. Click on "**Edit**" in the bottom right corner in order to modify the alert. You have the option of configuring the threshold, setting up the schedule to see how often that phase is checked, and adding email recipients for the alerts. Once you have changed the settings, you can click "**Save**" on the bottom right corner.

![Configure Alerts](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-monitoring-hana-part4/configure-alerts.png)

As a test case, you can click on "**Run Check Now**" beside the "**Edit**" button to ensure the alert is working.



### Additional Queries to use in SAP HANA Studio

There are some queries that aid you to see what is up and working and identify if there is anything missing.

To see all the `Dbspaces`, their sizes, whether additional reserve size was added and some additional information, use the following:

```sql
SELECT * FROM "SYS"."M_ES_DBSPACES"
```
To see the inside of a `Dbspace` and identify what files are added to them, use the following:

```sql
SELECT * FROM "SYS"."M_ES_DBSPACE_FILES"
```
To identify what extended tables/Dynamic Tiering tables have been created in your system along with some of their properties, use the following:

```sql
SELECT * FROM "SYS"."M_ES_TABLES"
```