New database or new instance

25 April,2015 by Jack Vamvas

Question: I’m setting up some new database for a spate set of Agile developers. I need to decide whether I’ll add the new database into an existing instance or create  a new instance. What criteria should I use to decide?

Answer: The main decision about deciding whether to create a new database in an existing instance or into a new instance is based on how you want to manage server resources

1)Do the databases communicate with each other? If not , then I’d place them in separate instances.

If separate instances are used, it’s much easier to ring fence server and instance resources via the Max Server Memory configurable.

Separating out into a separate instance may require some extra memory. But if extra memory is available, then I’d separate out the databases

Read More on SQL Server Instance management

SQL Server - How much resource is a SQL database using - memory, disk, IOPS,CPU

List SQL Server Instances with Powershell remote registry search ...

List SQL Server Instances using Powershell and Get-ItemProperty ...

Hide instance of SQL Server - SQL Server DBA


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on New database or new instance


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer