Performace degradation

John Lenz 1,721 Reputation points
2021-10-15T13:51:18.863+00:00

Server2012R2 STD (Hyper-V)

My performance has become degraded recently. Many times "server connection lost". I looked in task manager and found WID running ~25% of CPU, continuously.

Is this the issue, suggestions please. I can access via SSMS.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,178 questions
0 comments
Accepted answer
  1. John Lenz 1,721 Reputation points
    2021-10-27T15:39:42.75+00:00

    OK, I left system running for over a week. The CPU load is now very low, as before. Performance is normal.
    There must have been a long running process that impacted SQLServer WID.

    Memory is 21GB with 19 used, CPU <5%, DIsk little activity.

    Thanks for your support

    0 comments

5 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. John Lenz 1,721 Reputation points
    2021-10-23T19:02:43.85+00:00

    unfortunayely, 2 clients had blown systems this week. I'll get to this next week.

    1 person found this answer helpful.
    0 comments
  2. John Lenz 1,721 Reputation points
    2021-10-18T12:35:22.703+00:00

    I will work on this, this week and rport back

  3. Limitless Technology 39,376 Reputation points
    2021-10-18T09:21:25.417+00:00

    Hi there,

    Microsoft windows server and their components use the Microsoft WID database to store their data. It is used to store relational services.

    I would suggest you to check with the process monitor and pinpoint the reason behind the performance issues. Process Monitor is an advanced monitoring tool for Windows that shows real-time file system, Registry, and process/thread activity.

    https://learn.microsoft.com/en-us/sysinternals/downloads/procmon
    Once you narrow down the issue then we can try resolving it by taking necessary actions.

    --------------------------------------------------------------------------------------------------------------------------------

    If the reply is helpful, please Upvote and Accept it as an answer

    0 comments
  4. Rita Hu -MSFT 9,626 Reputation points
    2021-10-18T01:14:24.88+00:00

    @John Lenz
    Thanks for your posting on Q&A.

    Please follow this link to troubleshot why the high usage CPU in WSUS server.

    Hope the link will be helpful. Please feedback to me if there are any updates of the case.

    Regards,
    Rita

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments