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.
Answer: D
Explanation:
Faster disks would reduce this problem.