How would you check to see if the query is being blocked?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
database server with a default instance. During routine maintenance you notice that a query
against a database is taking long to complete.
How would you check to see if the query is being blocked?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
database server with a default instance. During routine maintenance you notice that a query
against a database is taking long to complete.
How would you check to see if the query is being blocked?

A.
You should consider using the Performance Monitor.

B.
You should consider using the Process Monitor utility.

C.
You should consider using the Job Activity Monitor utility.

D.
You should consider using the Activity Monitor utility.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *