We run 3 virtual servers running windows server 2008 on our hp server that runs xenserver 5.6. All workstations are actually on a workgroup but we run active directory on same vm as sql. Application server on 2nd vm. 3rd vm is the terminal server.
We run one application in that rdp session. We have 2 cisco small business smart switch one 48port and one 50 port with poe. I have reset both configs. We have Avg business 2013 installed and have it on every vm, saying up to date and no infections. We are having random freezing or slowness but all rdp sessions stay connected.
After i have done some performance monitor on our sql server, that seems to be the issue. it has pages/sec as high as 1100. we have about 50 computers rdp into the ts then they open the application that pulls from the sql server.
the picture i took was off hours, i will be taking one during hours. the virtual machine has 40gb of memory and 33gb sql keeps taking from the system. the page file is around 35gb and everyone is complaining about slowness. what can i do to improve this?