You work as the database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a SQL Server 2005 database server named MiracleInfocom -DB01. MiracleInfocom -DB01 hosts a database named MI_Sales that stores sales data for the company. MiracleInfocom -DB01 also hosts two financial applications. Several MiracleInfocom .com users in the Sales department complain that queries against the MI_Sales database perform very poorly at times. You use System Monitor to monitor the performance of by using MiracleInfocom -DB01 and discover that SQL Server 2005 does not have sufficient memory to run efficiently. You need to ensure that SQL Server 2005 always has sufficient memory to run efficiently. What should you do?
A. Decrease the min memory per query server option.
B. Increase the min server memory server option.
C. Increase the max worker threads server option.
D. Decrease the max server memory server option.
Answer:B
You work as the database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a SQL Server 2005 database server named MiracleInfocom -DB01. MiracleInfocom -DB01 hosts a database named MI_Sales that stores sales data for the company. MiracleInfocom -DB01 also hosts two financial applications. Several MiracleInfocom .com users in the Sales department complain that queries against the MI_Sales database perform very poorly at times. You use System Monitor to monitor the performance of by using MiracleInfocom -DB01 and discover that SQL Server 2005 does not have sufficient memory to run efficiently. You need to ensure that SQL Server 2005 always has sufficient memory to run efficiently. What should you do?
A. Decrease the min memory per query server option. B. Increase the min server memory server option. C. Increase the max worker threads server option. D. Decrease the max server memory server option.