Posted by: Pdfprep
Post Date: November 2, 2020
You deploy a Microsoft SQL Server instance to support a new application. The application uses the tempdb database maintain session state data.
Users reports performance issues with the application. You observer performance problems immediately and begin troubleshooting. You observer numerous instances of the page PAGE_up and PAGEELATCH_EX wait events in the logs for the server. The resources for the description for the wait is 2:1:1.
A . Increase the number of tempdb files.
B . Increase the values of the Cost Threshold parallelism settings.
C . Increase the size of the tempdb.
D . Enable trace flag 3226.
Answer: A
Leave a Reply