What should you do?

You have an application that queries a database. Users report that the application is slower than

expected. You discover that several server process identifiers (SPIDs) have PAGELATCH_UP and PAGELATCH_EX waits. The resource descriptions of the SPIDs contains 2:1:1.

You need to resolve the issue.

What should you do?
A . Reduce the Fill factor of all the clustered indexes.
B . Reduces the number of table variales used in the application.
C . Use identity integers as primary key fields in the tables.
D . Move the database files to SSD storage.

View Answer

Answer: D

Explanation:

Faster disks would reduce this problem.