Installing another instance. Best practices ?

hi, installing sql 2005 x64 standard instance on server.

can please tell me or link best practices ?

for example, can assign higher priority system resources instance ?

are there security related, performance related, maintainance related topics aware of, adding instance server ?

thanks help.

regards.

hello,

consider following balance memory usage across instances:

http://msdn.microsoft.com/en-us/library/ms178067.aspx  (running multiple instances of sql server)

if planning have multiple instance of analysis services, following link may help:

http://msdn.microsoft.com/en-us/library/ms174906(sql.90).aspx

if planning have multiple instances of reporting services, following link may help:

http://msdn.microsoft.com/en-us/library/ms403426(sql.90).aspx

hope helps.

regards,

alberto morillo
sqlcoffee.com

SQL Server  >  SQL Server Setup & Upgrade