Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Optimize for adhoc workloads Expand / Collapse
Author
Message
Posted Tuesday, April 9, 2013 4:20 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:06 PM
Points: 485, Visits: 848
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
Post #1440246
Posted Tuesday, April 9, 2013 4:25 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:06 PM
Points: 485, Visits: 848
silly me, found it in sys.configurations!
Post #1440247
Posted Tuesday, April 9, 2013 7:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 14,205, Visits: 28,533
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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1440300
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse