RavenDb 5+ cpu usage per query

[Valeriob]

Hi,

what is the best way to find out what is the client workload that is eating the most the cpu of ravendb server ?

I have a workload where the indexes update are not high, and the thread that use the most cpu are unnamed 

I'm kind of blind, is there anything where i can see the cpu usage grouped by for each query with the query cardinality ? I think this would be extremly helpfull.

Thank you

Valerio

[Oren Eini (Ayende Rahien)]

The easiest way to do that is to use the stack traces view.

We don't really track CPU usage per query.

--
You received this message because you are subscribed to the Google Groups "RavenDB - an awesome database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ravendb/8b904e59-c7f5-4c54-a022-2332c9d7ffe5n%40googlegroups.com.

--

Oren Eini CEO   /   Hibernating Rhinos LTD Mobile:  972-52-548-6969 Sales:  sa...@ravendb.net Skype:  ayenderahien Support:  sup...@ravendb.net

[Valerio Borioni]

Thank you Oren,

i tried that, but unfortunately it does not give much insight : 

Valerio

You received this message because you are subscribed to a topic in the Google Groups "RavenDB - an awesome database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ravendb/IqKhjWfkXGo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ravendb+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ravendb/CAF0G-ZgSApXZoj4rmDj6ZVH757uomOqj4mEgyVN49jRQkRy9mg%40mail.gmail.com.

[Oren Eini (Ayende Rahien)]

That being the case, any way you can run this under profiler? Or just use Traffic Watch to see if you have long requests?

To view this discussion on the web visit https://groups.google.com/d/msgid/ravendb/CAPLNmdFBBjyXrRxBWjsv5OOFA0jwkyv_RYD4N2XgrMxT4Uc8kQ%40mail.gmail.com.

[Valeriob]

Thank you Oren,

i'll try with fiddler. Would hooking up to the document store OnBeforeQuery work ? 

It would be awesome to integrate with other infrastructure monitoring tools like newrelic, appinsights, etc...

Thank you

Valerio

[Oren Eini (Ayende Rahien)]

Yes, that would work great

To view this discussion on the web visit https://groups.google.com/d/msgid/ravendb/e8982cec-ab72-4f79-a979-e1a1ee28fa64n%40googlegroups.com.