resource governor and connection pooling

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  September 2, 2009 at 5:58 am

  #210394

  does anyone know how the resource governor works if you are using connection pooling?

  doe the governer allocate you to a pool only when the spid first connects? or does it re-allocate when pooling performs an sp_reset connection?

  MVDBA

• aaron.bertrand

  Ten Centuries

  Points: 1260

  More actions

  September 3, 2009 at 8:23 am

  #1048776

  sp_reset_connection will trigger re-classification.

  At least that's what this blog post seems to imply (I haven't tested it):

  http://blogs.msdn.com/psssql/archive/2009/02/23/how-it-works-resource-governor-internal-group.aspx