Any advice on the best way to troubleshoot server performance bottlenecks?
- FMSA11 on (virtualised) Windows Server 2008 R2 SP1, 64-bit
- 16GB RAM
- 2.67 GHz Quad Core CPU
- Three drives (OS on C, FMS and live data files on D, backups on E)
- Approx 125 database files, around 100 users connected via Terminal Services
We're experiencing periodic slowdowns at various points, where everything slows to a crawl and client stats go through the roof. This doesn't appear to follow any particular pattern of user activity.
- backup schedules
- virus scanning
- shadow copies
- RAM utilisation
- other services running on the server
I've attempted to set up Performance Monitor, but can't seem to get any useful information out of it...
My only idea so far is that it may be down to a lack of space on the C drive. The C drive is 60GB in size, with approx 12GB free space. However, the total size of the database files is around 13GB, which given the recommendation for at least double the total database size in free space on the C drive, is a little lacking. However, the powers that be seem reluctant to increase the size of this drive. Can anyone confirm whether this would be likely to cause the issues we're experiencing, and if so, any idea why it can be ok for hours then suddenly lock up?
Grateful for any thoughts, especially your methods of troubleshooting issues like this.