SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL Server Management Objects (SMO) Class Library
Microsoft.SqlServer.Management.Smo Namespace
IServerConfigurationFacet Interface
IServerConfigurationFacet Properties
AdHocRemoteQueriesEnabled Property
Affinity64IOMask Property
Affinity64Mask Property
AffinityIOMask Property
AffinityMask Property
AgentXPsEnabled Property
AllowUpdates Property
AweEnabled Property
BlockedProcessThreshold Property
C2AuditTracingEnabled Property
ClrIntegrationEnabled Property
CommonCriteriaComplianceEnabled Property
CostThresholdForParallelism Property
CrossDBOwnershipChainingEnabled Property
CursorThreshold Property
DatabaseMailEnabled Property
DefaultBackupCompressionEnabled Property
DefaultFullTextLanguage Property
DefaultLanguage Property
DefaultTraceEnabled Property
DisallowResultsFromTriggers Property
DynamicLocks Property
ExtensibleKeyManagementEnabled Property
FilestreamAccessLevel Property
FillFactor Property
FullTextCrawlBandwidthMax Property
FullTextCrawlBandwidthMin Property
FullTextCrawlRangeMax Property
FullTextNotifyBandwidthMax Property
FullTextNotifyBandwidthMin Property
IndexCreateMemory Property
InDoubtTransactionResolution Property
LightweightPoolingEnabled Property
MaxDegreeOfParallelism Property
MaxServerMemory Property
MaxWorkerThreads Property
MediaRetention Property
MinMemoryPerQuery Property
MinServerMemory Property
NestedTriggersEnabled Property
NetworkPacketSize Property
OleAutomationEnabled Property
OpenObjects Property
OptimizeAdhocWorkloads Property
PrecomputeRank Property
PriorityBoost Property
ProtocolHandlerTimeout Property
QueryGovernorCostLimit Property
QueryWait Property
RecoveryInterval Property
RemoteAccessEnabled Property
RemoteDacEnabled Property
RemoteLoginTimeout Property
RemoteProcTransEnabled Property
RemoteQueryTimeout Property
ReplicationMaxTextSize Property
ReplicationXPsEnabled Property
ScanForStartupProcedures Property
ServerTriggerRecursionEnabled Property
SetWorkingSetSize Property
ShowAdvancedOptions Property
SmoAndDmoXPsEnabled Property
SqlMailEnabled Property
TransformNoiseWords Property
TwoDigitYearCutoff Property
UserConnections Property
UserInstancesEnabled Property
UserInstanceTimeout Property
UserOptions Property
WebAssistantEnabled Property
XPCmdShellEnabled Property
Expand Minimize
This topic has not yet been rated - Rate this topic

IServerConfigurationFacet.OptimizeAdhocWorkloads Property

SQL Server 2008 R2

Gets or sets a value that determines whether ad hoc workloads will be optimized.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
bool OptimizeAdhocWorkloads { get; set; }

Property Value

Type: System.Boolean
Returns True if workloads will be optimized; otherwise, False (default).
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.