How to find out memory overhead per Connection?

• Mohan Kumar VS

  SSCommitted

  Points: 1724

  More actions

  December 28, 2009 at 6:02 am

  #136153

  Hi

  I need to find out how much memory is consumed per user connection / process.

  Is there any method to find out? In our application, we have around 100 concurrent users.

  Server : Sql Server 2005 Standard Edition

  Rgds

  Mohan Kumar VS

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 28, 2009 at 9:25 am

  #1096732

  Try starting with this article.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Mohan Kumar VS

  SSCommitted

  Points: 1724

  More actions

  December 29, 2009 at 3:56 am

  #1096960

  Thank you very much.