July 3, 2007 at 5:50 pm
If you have come across any white papers or articles that deal with the above question in a comprehensive manner, I would appreciate it if you could point me to it.
We have a new module coming up in an existing project and we soon have to make a call on whether to create a DB in the existing instance or create a new instance. The expected volume of data in the new DB will be several orders of magnitude higher than that in the DBs in the existing instance.
Thanks,
Rajesh
July 3, 2007 at 10:51 pm
If you expect the new database wil be of large volume and will be used heavily than the existing database. plan to deploy that in a new server than doing it in the same server.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 10:23 am
I avoid new instances because of the memory limitations of most machines. It might be better to let SQL Server manage the memory and CPU. In SS2K8, there will be resource governers to help manage this.
If you have 8GB or more, then a 2nd instance might make sense.
Can you provide any more info on the comparison of the two apps?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply