March 21, 2013 at 1:45 am
Hi all
I have small doubt, how many instances we can create in production environment
and how many databases we can create on each instance
as per my knowledge we can create only one instance in production environment and also we can create multiple databases
if create multiple instances it will effect on performance on os level or system level
is this correct if anything wrong please correct it
March 21, 2013 at 2:51 am
Much of the information you need is here http://msdn.microsoft.com/en-gb/library/ms143432(v=sql.105).aspx. Although a lot of this would be dependant on if your hardware could cope with it.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 21, 2013 at 3:22 am
Thank you very much
March 22, 2013 at 4:29 am
Multiple instances will absolutely affect performance, yes. You just need to monitor your systems to understand how much they will affect it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply