You deploy a Microsoft SQL Server instance to support a new application. The application uses the tempdb database to maintain session state data.
Users report performance issues with the application. You observe performance problems immediately and begin troubleshooting. You observe numerous instances of the page PAGELATCH_UP and PAGELATCH_EX wait events in the logs for the server. The resource description for the wait is 2:1:1.
You need to resolve the performance problem.
What should you do?
A. Increase the number of tempdb log files.
B. Use the Read Committed Snapshot Isolation mode.
C. Replace temporary tables with table-valued functions.
D. Increase the value of the Cost Threshold for Parallelism setting.
E. Increase the size of the tempdb.
F. Increase the value of the MAXDOP setting.
