Optimize for adhoc workloads

• Balance

  SSCrazy

  Points: 2636

  More actions

  April 9, 2013 at 4:20 am

  #276186

  Can anyone please tell me where I can find the optimize for adhoc workloads settings in a table / view because I want to programmatically test for the setting?

  thanks

• Balance

  SSCrazy

  Points: 2636

  More actions

  April 9, 2013 at 4:25 am

  #1604743

  silly me, found it in sys.configurations!

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  April 9, 2013 at 7:07 am

  #1604790

  Yeah, it's a server level setting.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning