After the migration, some SQL queries take longer to execute than prior to migration.
The following SQL best practices were applied while creating the SQL VM on Nutanix:
• 8 vDisks per SQL server VM
• Database and Log files on separate vDisk
• 2 TempDB database drives and 1 TempDB log drive
What should the administrator to do improve the SQL Server performance?
A . Redistribute existing data by creating additional database file and enable autogrowth
B . Create multiple TempDB data files and enable autogrowth
C . Create multiple SQL log files and disable autogrowth
D . Redistribute existing data by creating additional database files and disable autogrowth
Answer: A
Latest NCS-Core Dumps Valid Version with 191 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund