1. derfrent New Member

   Has anyone found what type of resources it takes for SQL Server to handle a connection from a Microsoft Access .adp? Since an .adp opens three connections to start with and for me I have 200 users, I thought maybe I could determine the resources it takes to hold open 600 connections.
   
   Thank you,
   
   Jeremy

   derfrent, Nov 17, 2005

   #2
2. FrankKalis Moderator

   BOL specifies, that each connection takes about 24 kb of overhead. No matter if it's being used or not.
   
   --
   Frank Kalis
   Microsoft SQL Server MVP
   http://www.insidesql.de
   Heute schon gebloggt?http://www.insidesql.de/blogs
   Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
   

   FrankKalis, Nov 18, 2005

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in