question

JohnLenz-5880 avatar image
0 Votes"
JohnLenz-5880 asked JohnLenz-5880 answered

Performace degradation

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-serverwindows-server-update-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JohnLenz-5880 avatar image
0 Votes"
JohnLenz-5880 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MotoX80 avatar image
2 Votes"
MotoX80 answered

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



capture1.jpg (135.8 KiB)
capture.jpg (91.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RitaHu-MSFT avatar image
0 Votes"
RitaHu-MSFT answered RitaHu-MSFT edited

@JohnLenz-5880
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

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://docs.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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JohnLenz-5880 avatar image
0 Votes"
JohnLenz-5880 answered RitaHu-MSFT commented

I will work on this, this week and rport back

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Looking forward for your feedback.

Have a nice day.

Regards,
Rita

0 Votes 0 ·
JohnLenz-5880 avatar image
1 Vote"
JohnLenz-5880 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.