# Can dynatrace see CPU Utilization % per CPU Core & CPU Utilization % per SQL Statement ?

**URL:** <https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301>\
**Category:** Open Q&A\
**Tags:** profiling-and-optimization, mysql\
**Created:** [January 25, 2021, 9:48am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301 "2021-01-25T09:48:12Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![AskMe-Solutions](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/askme-solutions/32/33154_2.png) [@AskMe-Solutions](https://community.dynatrace.com/u/AskMe-Solutions)\
**Post date:** [January 25, 2021, 9:48am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/1 "2021-01-25T09:48:12Z")

</div>

Hi all,

I want to know ?

1.CPU Utilization % per CPU Core

ex. DB server have 8 core. I can see how during perdormance test each CPU core run.

2.CPU Utilization % per SQL Statement

ex. Which SQL statements cause heavy CPU usage?

Thank you

---

<div class="post-metadata">

**Author:** ![Babar\_Qayyum](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/babar_qayyum/32/13620_2.png) [@Babar\_Qayyum](https://community.dynatrace.com/u/Babar_Qayyum)\
**Post date:** [January 25, 2021, 9:53am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/2 "2021-01-25T09:53:46Z")

</div>

Hello [@dynatrace A.](https://answers.dynatrace.com/users/6185/view.html)

According to the below documentation link, database code-level based monitoring can see how much load is placed on your databases by individual services.

[https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/#expand-1833more-on-code-level-based-monitoring](https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/#expand-1833more-on-code-level-based-monitoring)

Regards,

Babar

---

<div class="post-metadata">

**Author:** ![dglugla](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dglugla/32/14492_2.png) [@dglugla](https://community.dynatrace.com/u/dglugla)\
**Post date:** [January 25, 2021, 10:44am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/3 "2021-01-25T10:44:29Z")

</div>

1. no - OneAgent is capable of tracking CPU usage on a host, but without splitting the metric by the CPU core

2. server side and Oracle only - DBInsights. Planned as a part of DB monitoring extensions, but there’s no exact ETA

BR, Darek

---

<div class="post-metadata">

**Author:** ![Krzysztof\_Ziemi](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/krzysztof_ziemi/32/39365_2.png) [@Krzysztof\_Ziemi](https://community.dynatrace.com/u/Krzysztof_Ziemi)\
**Post date:** [January 26, 2021, 9:11am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/4 "2021-01-26T09:11:04Z")

</div>

Hi,

This is correct - on the service level, we cen tell how may queries of what kind is the service issuing against the database and how much time did the database need to serve them. Which characterizes the load placed on the database by the service.

But we can’t universally analyze the load on the database server, i.e. tell that specific queries took more database server CPU and others waited for disks, etc. As Darek said, this would be possible for some databases, but for others it’s not practical or not feasible. We will have it for Oracle, we look to have it for MSSQL, perhaps. For other databases - the jury is still out.

Best regards

Kris

---

<div class="post-metadata">

**Author:** ![fstekelenburg](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/fstekelenburg/32/22029_2.png) [@fstekelenburg](https://community.dynatrace.com/u/fstekelenburg)\
**Post date:** [August 17, 2023, 9:59am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/5 "2023-08-17T09:59:50Z")

</div>

1) Is kind of a pity. It shall have to come from native tools.  
For instance, it would be helpful to detect single-threaded processes. Those that only use one core (and max that core out), while the system itself has plenty.

---

<div class="post-metadata">

**Author:** ![gurugogi](https://avatars.discourse-cdn.com/v4/letter/g/87869e/32.png) [@gurugogi](https://community.dynatrace.com/u/gurugogi)\
**Post date:** [October 17, 2024, 11:34am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/6 "2024-10-17T11:34:08Z")

</div>

[@dglugla](https://community.dynatrace.com/user/27556)&nbsp;still we cant export CPU utilisation at CPU core level ?

---

<div class="post-metadata">

**Author:** ![dglugla](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dglugla/32/14492_2.png) [@dglugla](https://community.dynatrace.com/u/dglugla)\
**Post date:** [October 29, 2024, 8:56am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/7 "2024-10-29T08:56:34Z")

</div>

Sorry&nbsp;[@gurugogi](https://community.dynatrace.com/user/61893), but I’m not able to answer your question.

Maybe&nbsp;[@Radu](https://community.dynatrace.com/user/22272)&nbsp;could help? I believe the question is about Oracle DB extension, right?

---

<div class="post-metadata">

**Author:** ![Tom\_sSeroteRoos](https://avatars.discourse-cdn.com/v4/letter/t/bb73d2/32.png) [@Tom\_sSeroteRoos](https://community.dynatrace.com/u/Tom_sSeroteRoos)\
**Post date:** [October 29, 2024, 9:47am UTC](https://community.dynatrace.com/t/can-dynatrace-see-cpu-utilization-per-cpu-core-cpu-utilization-per-sql-statement/21301/8 "2024-10-29T09:47:56Z")

</div>

[@gurugogi](https://community.dynatrace.com/user/61893)No, the current extension doesn’t export CPU utilization per core.

Tying back to the original question, we now do report CPU time for the top SQL statements though.
