none
Can Replication cause 100%CPU RRS feed

  • Question

  • I configured transactional replication and in sometime CPU spiked to 100%. Sysadmin guys are saying replication as the root cause. Is it correct? 

    Kiran

    Monday, June 8, 2020 7:52 AM

Answers

All replies

  • Hi juniorkiran,

    >Is it correct? 

    Yes.Entirely possible.Please troubleshooting as this: troubleshooting-slow-sql-server-replication-issue-due-to-distributor-database-growth

    And this could be helpful: high-cpu-in-a-transactional-replication

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by juniorkiran Friday, June 12, 2020 7:31 AM
    Monday, June 8, 2020 10:12 AM
  • It depends on what data you are Replicating and do you have proper Index on replicated table. If you have two much lengthy row (Single row with MAX VARCHAR or TEXT data type fields) then it may impact CPU usage. Try to validate the usage after Ignoring those fields from Replication and test.
    Monday, June 8, 2020 10:49 AM
  • First, please post the results of SELECT @@VERSION.

    Second, it is perfectly normal and expected for the CPU to be 100% for short periods of time.  SQL Server is designed and configured to use 100% of the available hardware when needed in the default configuration.    Short periods of 100% CPU usage is not a problem.

    Monday, June 8, 2020 11:35 AM
  • Hi juniorkiran,

    Is the reply helpful?

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, June 9, 2020 1:13 AM
  • Hi juniorkiran,

    Is the reply helpful?

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, June 10, 2020 1:13 AM
  • If your distribution clean up task is not running and succeeding you may see a high cpu condition. I would also disable immediate sync as this can cause high cpu as well.
    Wednesday, June 10, 2020 2:43 PM
    Moderator
  • Hi juniorkiran,

    Is the reply helpful?

    Looking forward to your response!

    Best Regards.

    m


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, June 12, 2020 4:52 AM