• If you want to concentrate on connections, monitor the performance counter SQLServer: General Statistics – User Connections. For a more sophisticated analysis, you might also include other counters such as SQLServer: SQL Statistics – Batch Requests/sec and Processor – % Processor Time. There's a lot of articles out there on the best performance counters for particular situations.

    John