We will be using .NET but I didn’t want to post it there since I want to see if there is anything we can see from the Couchbase Database server side.
Is there a way for Couchbase to be able to monitor what queries are running slow/long/takes a lot of CPU/doing a lot of reads/etc? Say an application is connected to the Couchbase Database and running a query slowly. Without looking on the application logs, is there a way that Couchbase will show this information – either via command line or the web console? I believe cbstats is looking at server/node/bucket-level metrics but not necessarily at the query level.
Coming from Oracle, there are a lot of tools available that will show query-level information. Does Couchbase have anything similar?
I believe I read that with 4.5DP, there is a Query Monitor process that might provide some details, but I’m not sure to what extend. I also read that with the Java SDK, there is a QueryMetrics object that has the info() method that might have some details. Is that only available in Java and not .NET? With that said, that relies on the application to put the information into a log.