PostgreSQL 10 High Performance - Third Edition

Saving Windows system monitor data

To replace what's done with sar on Unix systems, you can enable logging for the counters System monitor tracks. It's then possible to see historical data for the logs, not just the live charts. The exact procedure varies based on version; Microsoft's guides are at the following:

• Windows 2000, XP, Server 2003: http://support.microsoft.com/kb/248345
• Vista: http://technet.microsoft.com/en-us/library/cc722173(WS.10).aspx
• Windows 7, Windows Server 2008 R2: http://technet.microsoft.com/en-us/library/dd744567(WS.10).aspx

Another useful trick to know is that once you've set up logging on a server, you can save that setup and even move it onto another system. Just right-click on the trace data and select Save Settings ...