Named Instances of SQL Server -- sql server programming

oj
12/8/2004 10:08:40 PM

In earlier version of sqlserver (<7) you can only have 1 instance of
sqlserver running on a single box. This limit has been lifted by sql2k
through the use of named instance.

In sql2k, you can create upto 100 named instances of sqlserver. Though, only
upto 16 is supported by MS.
Each instance is unique and independent of the other. Each acts as a single
server with its own master/system objects/securities.

[quoted text, click to view]

Mike Epprecht (SQL MVP)
12/8/2004 11:01:02 PM

Hi

There are licensing implications. If you have 'Per Server Licensing', each
instance in licensed separately. If you have 'Per Processor Licenses', you
can install as many instances as are supported. This assumes you have the
correct number of 'Per Processor' licenses for the number of CPU's on your
server.

Regards
Mike

[quoted text, click to view]

David Gugick
12/9/2004 1:23:37 AM

[quoted text, click to view]

You can run up to 16 instances of SQL Server on the same PC - no license
fees either. For development it's great because you can run all SQL
Server service packs if you need to. For production, it's really only
necessary if you reall yneed two separate databases. When using them,
you really need to configure SQL Server memory manually to prevent each
instances from eating all available memory.

For production you also need to be aware that some 3rd party SQL Server
products licensed per instance.

--
David Gugick
Imceda Software
www.imceda.com

Uri Dimant
12/9/2004 8:04:20 AM

Jordan
It's probably time to start reading BOL for the subject
Note , that each instance will consume a memory so make sure you have
enough memory on the server.
Each named instance is made up of a distinct set of services and can have
completely different settings for collations and other options. The
directory structure, registry structure, and service names all reflect the
specific instance name you specify.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server programming

sql server programming : Named Instances of SQL Server