Check reads per sec and CPU utilization
I was not able to find any information how to check CPU utilization and read per sec for a query. Any ideas how to get these results?
Thanks in advance.
indeed. for such details you should become an OS expert, starting by understanding memory-mapped file technology.
On 11 apr. 2016, at 18:12, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:
I was not able to find any information how to check CPU utilization and read per sec for a query. Any ideas how to get these results?
Thanks in advance. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Maybe there are already some scripts at least to get some raw data?
On Mon, Apr 11, 2016 at 6:52 PM, Martin Kersten Martin.Kersten@cwi.nl wrote:
indeed. for such details you should become an OS expert, starting by understanding memory-mapped file technology.
On 11 apr. 2016, at 18:12, Shmagi Kavtaradze kavtaradze.s@gmail.com
wrote:
I was not able to find any information how to check CPU utilization and
read per sec for a query. Any ideas how to get these results?
Thanks in advance. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi,
here are links to timing and performance monitoring tools that MonetDB provides, i.e., "stethoscope", "tomograph", & "tachograph": https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming
For more, please consult the tools that your OS provides and their documentation.
Best, Stefan
----- On Apr 11, 2016, at 7:07 PM, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:
Maybe there are already some scripts at least to get some raw data?
On Mon, Apr 11, 2016 at 6:52 PM, Martin Kersten < Martin.Kersten@cwi.nl > wrote:
indeed. for such details you should become an OS expert, starting by understanding memory-mapped file technology.
On 11 apr. 2016, at 18:12, Shmagi Kavtaradze < kavtaradze.s@gmail.com > wrote:
I was not able to find any information how to check CPU utilization and read per sec for a query. Any ideas how to get these results?
Thanks in advance. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Martin Kersten
-
Shmagi Kavtaradze
-
Stefan Manegold