Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)

Author  Topic 

Starting Member

40 Posts

Posted - 2004-07-27 : 01:17:41
Greetings Everyone,
Is there any limit for number of logins should be created for a instance?
Does (unwanted) more logins affects the performance?


Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-27 : 07:28:02
It can if they are used. Each login takes about 2k of memory if I recall correctly. They will also have affect connection pooling if you have a lot used at the same time. Besides this, the only issue is maintenance and security. You should always have the smallest amount needed.


When life gives you a lemon, fire the DBA.
Go to Top of Page

- Advertisement -