What else should you configure on these instance

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What else should you configure on these instances?

You are designing a new server that will hold 2 instances of SQL Server 2005 in a consolidation project. One of the existing servers has 4GB of RAM and the other has 2GB. You do not want either instance to feel memory pressure, so you specify a new server with 8GB of RAM. What else should you configure on these instances?


Min and Max memory for each instance
Explanation
If you are designing multiple instances, you will want to specify the amount of RAM that each has access to. If you do not do this, performance can vary dramatically as the servers compete for memory.

(Continued on next question...)

Other Job Interview Questions

• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• What T-SQL function can achieve this?
• What is the difference between a return parameter and an OUTPUT parameter?
• Which types of replication work with Oracle publishers?
• What is an index? What types of indexes are available in SQL Server 2000?
• How secure are encrypted stored procedures, triggers and views?
• What value should you use for the BROKER_INSTANCE parameter?
• Is it possible to build an index on a view
• In SQL Server 2000, how can you send an alert without sending a message to the client?
• More...