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,049 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: Most helpful
Most helpful Newest Oldest
  1. MotoX80 31,556 Reputation points
    2021-10-15T15:58:28.13+00:00

    Start with basic troubleshooting using task manager. Does your system have sufficient CPU and memory? Is your disk overloaded? Do you have an excessive number of threads and handles? Is one particular process using up all of your system's resources?

    140875-capture.jpg

    If you have a runaway process, then you need to identify things like: "what function does this process provide?", "what's it! doing now?" and "when did this problem start?". In the details tab you can right click on a process and select "Go to service(s)" to see it's service name. You could also add the command line column to see what parameters it was launched with. The Resource Monitor can show you which processes have disk activity and what files are being accessed.

    140942-capture1.jpg

    The Application and System event logs should also be analyzed for error events that might provide insight in to whatever your problem is. At this point you need to look for clues as to what is going on with your system.

    https://www.bing.com/search?q=basic+windows+troubleshooting+guide

    2 people found this answer helpful.
    0 comments
  2. 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
  3. 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
  4. Limitless Technology 39,331 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