PrepAway - Latest Free Exam Questions & Answers

which SQL Server activity is causing the high disk activity. You want to accomplish this task by using SQL Ser

You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application is performing poorly. You use System Monitor and discover that disk activity on the volumes that contain the database data files is very high. You need to find out which SQL Server activity is causing the high disk activity. You want to accomplish this task by using SQL Server Profiler. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Search for deadlock events.

B.
Search for events that have high duration values.

C.
Search for events that have high read values or high write values.

D.
Search for transaction log events that have high write values.

Explanation:
Only high read or write values will cause high disk activity.


Leave a Reply