SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Login
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Tracey
Starting Member

New Zealand
40 Posts

Posted - 07/27/2004 :  01:17:41  Show Profile  Reply with Quote
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

USA
4184 Posts

Posted - 07/27/2004 :  07:28:02  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
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.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000