Your primary tool for monitoring performance of Sybase IQ is the IQ performance monitor, described in Chapter 5, “Monitoring and Tuning Performance.” However, you can also use operating system monitoring tools.
Windows provides two tools for monitoring the performance of your system.
Windows Task Manager has two windows that provide an easy-to-read overview of current system performance. To start the Task Manager type Ctrl-Alt-Del and select the Task Manager button. By selecting the Processes tab you can see a list of all the currently running processes on the system. To customize the columns displayed, select View→Select Columns. The CPU Usage, Memory Usage and Virtual Memory Size columns help you identify CPU or memory bottlenecks. The Performance tab allows you to see various counts and a history of the machine performance.
The System Monitor provides a more detailed analysis of your machine's performance. It allows you to monitor individual counters to various system and application objects, including processors, processes, disks and the network.
