Monitoring
Microsoft SQL Server
-
On the
Real-Time Monitoring tab, in the
Monitor group, click
System.
The
Data Source wizard opens.
-
Click the
Select from predefined Data Sources option button.
-
Click
Next.
The
System selection page opens.
-
Expand the
Database System folder and the
SQL Server <version> folder.
-
Click the
System Statistics (PERFMON) node and then click
Next. The
Connection parameters page opens.
-
In the
Hostname text box, specify the host on which SQL Server is running.
-
In the
User and
Password text boxes, specify a user with administrator permissions on the above-specified host.
-
Optional: In the
Alias text box, specify an alias for the monitored server.
-
Click
Next.
The
Select displayed measures page opens.
-
Check the check boxes for those measures that you want to include in the initial monitor view.
-
Click
Finish.