ipsec600
asked on
Performance issue for windows server 2012 R2 Standard
Hi Experts,
Recently I have built a Virtual machine windows server 2012 R2, and installed GIS application in that server, but receiving complain that GIS query is running very slower than old server 2008 R2. I tried to capture performance counter but did not notice anything unusual, in this regard, could you please advise:
1. How can I proceed to troubleshoot the issue and identify the root cause.
2. How can I remotely run the performance counter for collecting data.
Recently I have built a Virtual machine windows server 2012 R2, and installed GIS application in that server, but receiving complain that GIS query is running very slower than old server 2008 R2. I tried to capture performance counter but did not notice anything unusual, in this regard, could you please advise:
1. How can I proceed to troubleshoot the issue and identify the root cause.
2. How can I remotely run the performance counter for collecting data.
Chris Millard
Have you set an appropriate number of processor cores for the virtual machine? I know in Hyper-V that new machines get 1 CPU core by default, and if you forget to increase that number, then the server runs horribly slow.
ASKER
Thanks Chris for your quick reply, the server is running in VM environment, where by it is set "number of virtual sockets 4, "number of cores per socket 1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are using the E1000 network interface, swap it for the VMXNET3 version, ASAP!
Also what memory and vCPU have you set in the VM ?
Also what memory and vCPU have you set in the VM ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Apology that I was away.
Machienet, there was no dirty shutdown of the VM hosts, rather I restarted couple of times but performance did not improve.
Andrew Hancock, network interface is set to VMXNET3 version. Memory is set to 8GB and vCPU is set to 4
compdigit44, I did not try to drop vCPU's to 2, yes it is querying to back end DB, users are accessing GIS app via RDP and from their profile executing the process.
I track server performance once again and notice that Processor (interrupts/sec) is causing bottleneck. Then I follow the below MS link
https://technet.microsoft.com/en-us/library/cc958311.aspx
https://technet.microsoft.com/en-us/library/cc958292.aspx
Assuming that system is generating more processor interrupts than it can handle. probably this is the case, and intend to upgrade memory and run the test to observe the outcome.
Machienet, there was no dirty shutdown of the VM hosts, rather I restarted couple of times but performance did not improve.
Andrew Hancock, network interface is set to VMXNET3 version. Memory is set to 8GB and vCPU is set to 4
compdigit44, I did not try to drop vCPU's to 2, yes it is querying to back end DB, users are accessing GIS app via RDP and from their profile executing the process.
I track server performance once again and notice that Processor (interrupts/sec) is causing bottleneck. Then I follow the below MS link
https://technet.microsoft.com/en-us/library/cc958311.aspx
https://technet.microsoft.com/en-us/library/cc958292.aspx
Assuming that system is generating more processor interrupts than it can handle. probably this is the case, and intend to upgrade memory and run the test to observe the outcome.
ASKER
Hi All, I have increased memory another 8GB, now the server has 16GB memory, but the query time still the same. Not sure what I should look at. Is there any way to tell that application has the bottleneck? please advise.
Sorry, I have nothing more to add at this point.
You can request further assistance by clicking that link below your original post "Request Attention"
You can request further assistance by clicking that link below your original post "Request Attention"
Increase the number of vCPUs
Also what is the technology used by the data store.
Also what is the technology used by the data store.
ASKER
I have increased number of vCPUs additional 2, now it is 6 but the performance is still the same, and it is accessing MS access DB in the back end. Even I saw in the resource monitor it is not parking in all vCPUs
What are the hardware spec of you host running your GIS servers?
What type of DB does the app use... MS SQL, Oracle etc....
Is the DB configuration correctly??? Properly indexing, maintenance plans grooming etc...
Does the DB server what resources do you have assigned to the DB server
Was the app set according to the vendors recommendations?
What type of DB does the app use... MS SQL, Oracle etc....
Is the DB configuration correctly??? Properly indexing, maintenance plans grooming etc...
Does the DB server what resources do you have assigned to the DB server
Was the app set according to the vendors recommendations?
ASKER
After several test, i have now decrease vCPU to 2 instead of 6, and notice performance is somewhat better but not consistent, as soon as vmotion is happening to ESXi host then performance is just varying. Also I tried to reserve vCPU but it did not help much.
Funny thing the process run better in laptop than the server, it just DBASE (.DBF file),
If I can enforce VM guest to consume more CPU from the ESXi host it might help, any advise please.
Funny thing the process run better in laptop than the server, it just DBASE (.DBF file),
If I can enforce VM guest to consume more CPU from the ESXi host it might help, any advise please.
What are the specs on the host? does the VM have any reservations?.... Stupid question but is the application multi-threaded???? If not it will only use one CPU no matter what...
What are the spec of the DB VM??? What OS is it running? Have you run and in guest performance stats on it?
What are the spec of the DB VM??? What OS is it running? Have you run and in guest performance stats on it?
ASKER
Hi Thanks and sorry for reply late, I did couple of test on the servers and after reducing 2 vCPU result is now coming positive, I have created another VM for the user now he is using two VM to perform the task for multiple uses and should be ok now.
Thanks Guys for all your help.
Thanks Guys for all your help.
Hello, would you please close this question if it is all set and working?
ASKER
Thank you Guys for your support.