Databases Reference
In-Depth Information
3.
Click on the + button in the toolbar to add counters.
4.
In the Add Counters dialog box, type the name of the computer or let it be <Local
computer> under the Select counters from computer: drop-down list, if you are
monitoring a local machine.
5.
In the list of available performance counter objects, expand
SQLServer:ResourcePoolStats and select CPU usage %.
6.
In the list under Instances of selected object:, you will see resource pools that
have been created previously. Select <All instances> and then click on the Add > >
button. This will add the CPU usage % counter to the list of Added counters on the
right-hand side.
7.
After adding the performance counter object, your screen should look as shown in
the following screenshot:
8.
Open SQL Server Management Studio and connect to an instance of SQL Server
containing the
AdventureWorks2012
database, by using the
AW_WebAppUser
login account (Connection-1).
9.
Open another instance of SQL Server Management Studio and connect to another
instance of SQL Server containing the
AdventureWorks2012
database, by using
AW_ReportAppUser
login account (Connection-2).
Search WWH ::
Custom Search