Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Tracey
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?Thanks Tracey |
|
derrickleggett
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.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|