I'm trying to identify what users are describing as slow application performance. I have a hunch it may be related to the application itself and not an issue with the SQL server. I've went over many of the usual suspects to identify common bottlenecks.
- Is there anything i interpreted incorrectly?
- Is there anything i neglected to review?
The MS SQL server (11.0.5058) is running on Hyper-V, 2012r2 with the following assigned to the guest: 72GB ram, 16 processors, 4 disk controllers with tempDB, OS, DB, Program Files all on separate VHDs.
Ran perfmon over the course of a day
% Processor Time < 40% Max
Avg Disk Q Length 0.003 Avg - 0.41 Max
% Disk Time Avg 0.0038
Avg Avail MBytes 5010
Buffer Cache Hit Ratio 99.996 Avg 98.614 Min
I don't see any issues with disk, mem, or processor. Where should i look next?