Refer to the exhibit.
A Microsoft SQL 2016 deployment is shown in the exhibit. The administrator receives user reports that database queries take too long to return.
Which optimization should be made to this configuration to improve performance?

Question

Refer to the exhibit.A Microsoft SQL 2016 deployment is shown in the exhibit. The administrator receives user reports that database queries take too long to return.Which optimization should be made to this configuration to improve performance?

Damodar Daesrath · Accepted Answer

TempDB, and Logs disk Separate the Database. TempDB, and Logs onto their own disks

Damodar Daesrath · Answer

Combine both of the OS and SQL Binaries disks

Damodar Daesrath · Answer

Add a second SCSI controller for the Database.

Damodar Daesrath · Answer

Configure the VM to use a PCI disk controller

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 20 - NCM-MCI discussion

Suggested answer: C

0 comments