check coonection pooling

• Kim, Dohyun

  Newbie

  Points: 1

  More actions

  March 27, 2006 at 5:49 pm

  #171720

  I administrate two SQL 2000 DB that manage ticket booking.

   - one is for movie ticket, one is for concert & art performance.

  As you can imagine, the user connection is so high when so famous concert starting.

  But when idle... connecton is so low.

  My company use own-made dll to manage DB coonection.

  In usual, each connection is about 150.

   

  My question is...

  Yesterday I talked about DB coonection with my ex-coworker.

  He told me, although peak time connection over 2000 is unusual.

  So he adviced "check coonection pooling".

   

  What's the checking  point in this situation in IIS & DLL?

  Thanks

   

• Amit Lohia

  SSCertifiable

  Points: 6104

  More actions

  March 27, 2006 at 5:55 pm

  #629054

  This article may be a good start

  http://www.sql-server-performance.com/sk_connection_pooling_myths.asp

  ---

  Kindest Regards,

  Amit Lohia