You are the database administrator for a major electronics chain. You manage all the SQL Server 2008 databases of the company.
The data is stored in databases named Prod1 and Prod2.
These databases areaccessed by users in the company by using four different applications named Cust_sales , Cust_audit , Retail_sales , and Yearly_total.
Users of the Cust_sales and Cust_audit applications complain that either the transactions time out frequently ortake too long to complete.
You want to monitor the applications causing the transaction blocks by using the Activity Monitor.
What should you do to achieve this objective?
A.
In the Process Info page, filter by using the host name.
B.
In the Process Info page, filter by using the process ID.
C.
In the Process Info page, filter by using the application name.
D.
In the Process Info page, filter by using the database name.
Explanation:
You should filter by using the application name in the Process Info page to achieve this objective. You canspecify different filters in the Process Info page of the Activity Monitor. These filters are used to determine theobject-specific data that should be displayed in the output page. The different options available are as follows:
* Application : Specifies the name of the application from which the connections should be monitored.
* Host : Specifies the name of the hosts from which the connections should be monitored.
* Processes : Specifies the ID of the processes that should be monitored.
* Database : Specifies the name of the database that should be monitored.
* User : Specifies the name of the database users whose processes should be monitored.In this scenario, the users accessing the Cust_sales and Cust_audit applications are experiencing problems.Therefore, you should monitor connections to the Cust_sales and Cust_audit applications by specifying thename of these two applications in the Application
filter in the Process Info page shown in the following graphic:
All the other options are incorrect because these options cannot be used to monitor the connections to the Cust_sales and Cust_audit applications.
Objective:
Monitoring and Troubleshooting SQL ServerSub-Objective:
Identify concurrency problems.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > FeatureReference > SQL Server Management Studio F1 Help > Object Explorer F1 Help > Management Node (ObjectExplorer) > Activity Monitor F1 Help > Activity Monitor (Process Info Page) TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > FeatureReference > SQL Server Management Studio F1 Help > Object Explorer F1 Help > Management Node (ObjectExplorer) > Activity Monitor F1 Help > Activity Monitor (Filter Properties Page)
