Note: This question is part of a series of questions that present the same scenario. Each question in this series contains a unique solution.
Determine whether the solution meets the stated goals.
You are developing a new application that uses a stored procedure. The stored procedure inserts thousands of records as a single batch into the Employees table.
Users report that the application resp
onse time has worsened since the stored procedure was updated. You examine disk-related performance counters for the Microsoft SQL Server instance and observe several high values that include a disk performance issue. You examine wait statistics and observ
e an unusually high WRITELOG value.
You need to improve the application response time.
Solution: You add a unique clustered index to the Employees table.
Does the solution meet the goal?
A. Yes
B. No
Explanation:
References:
https://msdn.microsoft.com/en-us/library/ms190457.aspx
B
8
2
cant see how adding an index will improve insert
B
3
0
WRITELOG means disk bottleneck. Adding index on the table it means adding more overhead to disk due to this fact answer is B
1
0