How to isolate window server issue

I have a Warehouse Management Systems running on window server 2008. It seem slow accessing the WMS at times and I don’t see any issue with the network.

I run Wireshark on the network and see everything is working just fine and run continuous ping using ping plotter show latency within 4ms Avg.

Asking if anyone has any idea on how isolate if the issue is with the WMS application, window server itself or some services on the server that causes the issue.

The window server is hosted on VMWare with 8vcpu and 8gb ram
AwalliskAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jose Gabriel Ortega CEE Solution Guide - CEO Faru Bonon ITCommented:
Check the event viewer
https://gallery.technet.microsoft.com/office/Get-event-logs-errors-and-6871f163

search for frequent errors and warnings.
1
John TsioumprisSoftware & Systems EngineerCommented:
4ms is bad news if you are on wired network...is this a VM or a physical machine ? (ping should be <1ms)
1
bbaoIT ConsultantCommented:
technically, the issue depends on how clients access the WMS over the network, e.g. how a database file is accessed? how is the computing model (client/server, three-tier architecture, web service model etc). please provide more details about how the WMS works with the client program.
1
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

AwalliskAuthor Commented:
Hi Jose,

Thanks will go thru the link and check the event log. I am not that experience in window server. I am more of a network guy.
0
AwalliskAuthor Commented:
Hi John,

It wired but host in a datacenter and access via a L2VPN with a 1 gig connection. I don't see issue with the connection and 4ms is quite Avg based on the distance.
0
AwalliskAuthor Commented:
Hi John,

  It a VM not a physical machine. I have increase it to 8vcpu and 8GB of Ram and still the same. Intermittent lag . Where client try to access it and it just waiting to be process on WMS.
0
AwalliskAuthor Commented:
The client access thru the network via chrome on a laptop or surface pro. The DB is from Microsoft and I tested the network and I see no issue with network.
0
bbaoIT ConsultantCommented:
are the DB (MS SQL Server?) and the web server (IIS?) located on the same server or on different servers across the network?
0
AwalliskAuthor Commented:
Hi BBao,

The MS SQL is running on different server but IIS is on the same server.  I trying to find out what causes the issue so I can request dev team to relook at their end. Cause they keep blaming network issue but I been monitoring the network and see no issue at all.
0
John TsioumprisSoftware & Systems EngineerCommented:
So its via Internet..4ms in this case is great...probably there is something with the application...maybe you are making too many individual requests to SQL server or something similar...if its a Warehouse Management Systems probably you are using wireless terminals to enter/retrieve the data so the wireless network is a key factor here...
Also from a similar case ...the web entry has its own secrets in order to be "speedy"...so they were also slow and they were forced to switch to Windows Mobile (short of...they were using RDP) ...which should provide direct connection to the SQL without extra delays and handling..
1
bbaoIT ConsultantCommented:
obviously, two segments of network are involved here. first the part from the client to the IIS, and the other is from the IIS to the database server at the back-end. hopefully there are two subnets here, one for each segment respectively.

the client to IIS segment can be tested or measured in two approaches, from the chrome side and from the web app code at the IIS side.

the chrome side can be simply monitored using its built-in tools for network admin and developers - Task Manager and Developer Tools. you may start from the Task Manager which can allow you visually monitor CPU and memory usage and network speed! please check if a simple home webpage will cause a peak on CPU and memory usage and slow network speed. a few more test on query page, uploading page and reporting page etc.

similarly, the developer tools will tell me more details about each web components.

at the web app side, you may ask the developer to do timing on key components or API calls. the same or similar method will be applied until moving to the last tier of the WMS - the database. MS SQL Server's profile analyzer can you on this, just like the Developer Tools at the Chrome side.

in a few words, from the Tier-1 to Tier-2 then Tier-3, one by one, step by step, along the data follow over the network.

make sense?
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AwalliskAuthor Commented:
Hi John,

You are right we are using wireless terminal scan directly to the WMS and I have setup a very robust wifi mesh with no dead spot and making sure the signal strength is in optimal condition. I have also been constantly monitoring the wifi env and would receive an alert if there any issue.

I believe the issue is with the WMS or the MS SQL. But unable to pinpoint on it. As I check the cpu process during the incident on the VMWare it just show 50 percent and during peak period 70 percent  cpu usage for the WMS server
0
AwalliskAuthor Commented:
Hi BBao,

It does make sense on your approach and just to let you know it running on the same subnet.  It was setup by the previous engineer.

Thank you so much for helping out I am trying your approach. I hope it will help to isolate it.
0
bbaoIT ConsultantCommented:
if the Chrome requests and IIS requests are sent over the same subnet, better test the whole thing during a controlled period of time such as off hours so you can make sure there is no irrelevant traffic having impacts to the test or troubleshooting.
1
AwalliskAuthor Commented:
Hi BBao,

  Yeah that is what being planned now and hope to be able to isolate what the issue is.
0
John TsioumprisSoftware & Systems EngineerCommented:
I am afraid there is a short of testing solution but is not easy...you have to setup a Windows Mobile Dev environment (old...) and design a couple of forms with a lot of data manipulation...enter/retrieve/enter/retrieve...this *should* perform lightning fast ...if not then you have a network issue somehow...( i reckon you have Windows Mobile Wireless Terminals)
The easiet check is to design a small normal windows form and RDP to it...There are options in the RDP mobile to match to the form size...this would be much quicker...a bit slower but it should give you good info about the performance
1
AwalliskAuthor Commented:
Hi John,

 With the test I did on the network didn't show any issue with the network. It more of the WMS and other internal site like leave system and purchase request system is running okay
0
AwalliskAuthor Commented:
I just like to thank you guys for helping me out. Thank you so much for all the help...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.