This is our in house web app we use within our company to allow our employees to run background checks, as that is what we do. The server is a Win2k3 Standard OS and is a VM running on ESXi 5. As of late, our application has become very slow for our. I am the sysadmin for my company, and is currently working with the development team who built the app. From a server standpoint, everything seems fine. Development see's no issues with their codes. There has been no current deployment that would cause any issue. I've even tried v-motioning the VM to another host to no avail. We look at the storage layer, networking, codes, SQL DB to no avail. We cannot determine the root cause. It's been a week. It's driving us nuts! Being that this is an in-house app, I would think it will be difficult for anyone on Expert Exchange to comment or give advice on what steps to perform next. I don’t expect anyone to provide a fix for the app as it is our app. However, if there is any suggestion as to what to look for to determine root cause, that would be appreciative. Maybe some advice on the server, network, SQL, or ESX layer?
Here are steps we've performed thus far to troubleshoot:
- J2EE server and performance was showing as normal.
- The server was then restarted
- The logs on the server were reviewed and a few errors were found that were forwarded to Development for further review. Per Development, the errors seem as usual behavior and were no indication of the slowness issue.
- Profiler was running the entire morning, from 8 am, without seeing any deadlocks. The SQL server logs were also clear of deadlock entries.