# How to implement OpenSearch stack monitoring similar to elastic stack monitoring

**URL:** <https://forum.opensearch.org/t/how-to-implement-opensearch-stack-monitoring-similar-to-elastic-stack-monitoring/16754>\
**Category:** OpenSearch Dashboards\
**Created:** [November 20, 2023, 6:58am UTC](https://forum.opensearch.org/t/how-to-implement-opensearch-stack-monitoring-similar-to-elastic-stack-monitoring/16754 "2023-11-20T06:58:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Reddy](https://avatars.discourse-cdn.com/v4/letter/r/f9ae1b/32.png) [@Reddy](https://forum.opensearch.org/u/Reddy)\
**Post date:** [November 20, 2023, 6:58am UTC](https://forum.opensearch.org/t/how-to-implement-opensearch-stack-monitoring-similar-to-elastic-stack-monitoring/16754/1 "2023-11-20T06:58:51Z")

</div>

Hi Team,

I am looking for the procedure to implement open search stack monitoring, is there any way to implement like the stack monitoring available in kibana.

Regards  
LG Reddy

---

<div class="post-metadata">

**Author:** ![Gsmitt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/gsmitt/32/1718_2.png) [@Gsmitt](https://forum.opensearch.org/u/Gsmitt)\
**Post date:** [November 21, 2023, 6:18am UTC](https://forum.opensearch.org/t/how-to-implement-opensearch-stack-monitoring-similar-to-elastic-stack-monitoring/16754/2 "2023-11-21T06:18:53Z")

</div>

Hey @Reddy

> [@Reddy](#):
>
> open search stack monitoring

I assume you seen this?

> **[Monitoring your cluster](https://opensearch.org/docs/latest/monitoring-your-cluster/index/)**
>
> Monitoring your cluster

---

<div class="post-metadata">

**Author:** ![Reddy](https://avatars.discourse-cdn.com/v4/letter/r/f9ae1b/32.png) [@Reddy](https://forum.opensearch.org/u/Reddy)\
**Post date:** [December 2, 2023, 3:55am UTC](https://forum.opensearch.org/t/how-to-implement-opensearch-stack-monitoring-similar-to-elastic-stack-monitoring/16754/3 "2023-12-02T03:55:42Z")

</div>

1. I started opensearch-performance-analyzer as per documentation and I am gettting only partial response for the query as shown below.  
(OpSh3)[root@worker ~]# curl -X GET [http://192.168.56.110:9600/\_plugins/\_performanceanalyzer/rca?name=HighHeapUsageClusterRca](http://192.168.56.110:9600/_plugins/_performanceanalyzer/rca?name=HighHeapUsageClusterRca)  
{“HighHeapUsageClusterRca”:[{“rca\_name”:“HighHeapUsageClusterRca”,“timestamp”:1701489113347,“state”:“healthy”}]}(OpSh3)[root@worker ~]#

2.I am getting error in logs related to sqlite  
2023-12-02 04:54:46.167 [PA:Reader] [ipLWDOfkQmaRDejHSG4VSw-task-0-] ERROR org.opensearch.performanceanalyzer.rca.store.metric.AggregateMetric - RCA: Caught an exception while getting the DB SQL [select IndexName, ShardID, sum(max) from Shard\_Size\_In\_Bytes where ShardID is not null group by IndexName, ShardID order by sum(max) desc]; [SQLITE\_ERROR] SQL error or missing database (no such table: Shard\_Size\_In\_Bytes)  
2023-12-02 04:54:46.167 [PA:Reader] [ipLWDOfkQmaRDejHSG4VSw-task-0-] ERROR org.opensearch.performanceanalyzer.rca.store.metric.AggregateMetric - RCA: Caught an exception while getting the DB SQL [select sum(max) SUM\_of\_max from Shard\_Size\_In\_Bytes]; [SQLITE\_ERROR] SQL error or missing database (no such table: Shard\_Size\_In\_Bytes)  
2023-12-02 04:54:46.168 [PA:Reader] [ipLWDOfkQmaRDejHSG4VSw-task-1-] ERROR org.opensearch.performanceanalyzer.rca.store.metric.AggregateMetric - RCA: Caught an exception while getting the DB SQL [select avg(sum\_max) shard\_avg from (select IndexName, ShardID, sum(max) sum\_max from Shard\_Size\_In\_Bytes where ShardID is not null group by IndexName, ShardID order by sum\_max desc) alias\_97600446]; [SQLITE\_ERROR] SQL error or missing database (no such table: Shard\_Size\_In\_Bytes)