You are the database administrator for a SQL Server that hosts an application defined as
follows: The database consists of 4 data files and one log file. The physical server has 16
CPUs and 64 GB of memory. Hardware non-uniform memory access (NUMA) is not
available on this server platform. Users of the application report that it is responding slowly.
You use SQL Server Profiler to find out that the I/O performance issue is related to the
lazywriter process. You need to improve the performance of the application by reducing the
I/O performance issue. What should you do? (More than one answer choice may achieve
the goal. Select the BEST answer.)
A.
Add additional RAM to the server.
B.
Add additional data files to the database.
C.
Configure four software non-uniform memory access (soft NUMA) nodes on the server.
D.
Configure a CPU affinity mask on the server to limit the instance of SQL Server to four
CPUs