web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / High CPU on CRM database
Microsoft Dynamics CRM (Archived)

High CPU on CRM database

(0) ShareShare
ReportReport
Posted on by Joe Woltering 12,163

When running a query on sys.dm_exec_query_stats my CRM database is showing 92% CPUPercent consistently. I am not seeing any major performance issues per se but what would cause this and how can I stabilize it?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at

    Hi, This isn't normal unless you have a very high number of users connected and your SQL Server is overloaded (Time to scale up!)

    You need to find out if it is SQL Server that is consuming the CPU (Use windows task manager) - if it is, you then need to use Activity Monitor to find out what is using the CPU. This could be in the 'Recent Expensive Queries' - look for high CPU time queries.

    mssqlwiki.com/.../troubleshooting-sql-server-high-cpu-usage

    hth

  • Joe Woltering Profile Picture
    Joe Woltering 12,163 on at

    Hmm, well I ran the query that is suggested in your wiki, and I don't believe I see anything out of the ordinary?

    record_id EventTime system_cpu_utilization sql_cpu_utilization

    18218 2013-08-19 13:06:23.710 10 8

    18217 2013-08-19 13:05:23.703 11 9

    18216 2013-08-19 13:04:23.700 10 8

    18215 2013-08-19 13:03:23.697 11 9

    18214 2013-08-19 13:02:23.693 9 7

    18213 2013-08-19 13:01:23.690 11 7

    18212 2013-08-19 13:00:23.687 11 8

    18211 2013-08-19 12:59:23.683 9 7

    18210 2013-08-19 12:58:23.680 10 7

    18209 2013-08-19 12:57:23.677 9 6

    18208 2013-08-19 12:56:23.673 11 9

    18207 2013-08-19 12:55:23.670 12 10

    18206 2013-08-19 12:54:23.667 9 7

    18205 2013-08-19 12:53:23.663 11 8

    18204 2013-08-19 12:52:23.660 10 8

    18203 2013-08-19 12:51:23.657 11 9

    18202 2013-08-19 12:50:23.653 11 9

    18201 2013-08-19 12:49:23.650 9 7

    18200 2013-08-19 12:48:23.647 9 7

    18199 2013-08-19 12:47:23.643 11 8

    One processor (out of 16) is showing higher usage than the others, which I assume to be the one that SQL is using. Again, I don't know that performance is being affected but this is certainly the first time I am seeing this.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    There could be end number of reasons:-

    Missing indexes, Query doing large number of reads, Big async operation table and index fragmentation etc.

    www.microsoft.com/.../details.aspx - check out the performance white paper.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans