Resource Monitor and Performance Monitor - Microsoft SQL Server 2012 Performance Tuning - page 80

F Network: This tab provides information regarding current network usage. The real-
time graphical view is displayed on the right-hand side along with available network
adapters installed on your machine. You will see all the TCP connections that are
associated with different processes and can filter the network activity by a given
process also, in order to identify network usage by a particular process.
There's more...
By using Resource Monitor, you can quickly identify the processes that are swallowing your
hardware resources. In Resource Monitor, You can also check network usage information
and identify the processes that generate more network traffic.
On a production SQL Server, if you find any processes/applications other than SQL Server that
are consuming more hardware resources and affecting the SQL Server's performance, you
probably would like to move those processes or applications to a different server, so that the
performance of SQL Server does not get affected.
Monitoring CPU usage
The CPU is the most important resource on a server. On a database server, CPU usage
should be monitored from time to time to make sure that the performance of the database
server is optimized.
In this recipe, we will use Reliability and Performance Monitor to capture CPU-related
usage statistics.
You may have used Performance Monitor (where you could add different performance
counters that need to be traced) in the past. Reliability and Performance Monitor is an
enhanced version of the old Performance Monitor tool. In Reliability and Performance
Monitor also, we can use performance objects and counters to analyse system
performance by different parameters.
Performance Counters provide statistical data for various system activities. You will
find hundreds of performance counters that belong to the Windows OS or third-party
applications. SQL Server has hundreds of performance counters of its own that provide
useful performance-statistics information to the DBA.
In this recipe, we will trace the following CPU-related performance counters in our recipe:
F Processor:% Processor Time
F System:Processor Queue Length