Thread Allocation

• brk5tr

  Ten Centuries

  Points: 1360

  More actions

  March 14, 2016 at 10:02 am

  #305636

  Hi, please could someone answer the question below if possible.

  Is a thread required for a Login to SQL Server? I'm aware that a task is allocated to a thread from the threadpool; however, are threads only required for query execution, or other actions too (such as logins mentioned above)

  Thanks for any help.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 14, 2016 at 10:06 am

  #1864986

  Threads are required to process logins.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• brk5tr

  Ten Centuries

  Points: 1360

  More actions

  March 14, 2016 at 10:16 am

  #1864989

  Thanks