Using perfmon to monitor memory bottlenecks
Posted on 2013-01-25
We have a Windows 2003 SBS server with 3 GB of memory. Users have been complaining that running the backup on their large SQL database has been slow, as their program also uses an extensive documentation folder that contains 29k PDFs (3.0 GB of docs) and has to compress and back these up as well into a zip file.
The vendor told us that since we recently reduced our memory from 4 GB to 3 GB, backups are going to take much longer (users are reporting it as three times as long). Is there a way to use performance monitor to verify this shortage in memory? If so, what counters should I look at?