SQL DB Engine

Microsoft.KnowledgeServices.SQLServer.DBEngine (ClassType)

Element properties:

Show References:

Base Class	Microsoft.SQLServer.DBEngine
Abstract	False
Hosted	True
Singleton	False
Extension	False
Accessibility	Public
ElementId	edff2cce-bc66-f326-6032-10be1d189b3d

Class Hierarchy:

System.Entity

System.LogicalEntity

System.ComputerRole

Microsoft.Windows.ComputerRole

Microsoft.SQLServer.ServerRole

Microsoft.SQLServer.DBEngine

Microsoft.KnowledgeServices.SQLServer.DBEngine

Class Properties:

Property Name	Type	Display Name (ENU)	Description (ENU)	Key	Max Length	Min Length	Case Sensitive
System.Entity:
DisplayName	string	Display Name	Display name of monitoring object.	false	256	0	False
Microsoft.SQLServer.ServerRole:
InstanceName	string	Instance Name		true	256	0	False
Microsoft.SQLServer.DBEngine:
Version	string	Version		false	256	0	False
Edition	string	Edition		false	256	0	False
AuthenticationMode	string	Authentication Mode		false	256	0	False
ServiceName	string	SQL Server Windows Service Name		false	256	0	False
ServiceClusterName	string	SQL Server Windows Service Name If Clustered Resource		false	256	0	False
FullTextSearchServiceName	string	Full Text Search Service Name		false	256	0	False
FullTextSearchServiceClusterName	string	Full Text Search Service Name If Clustered Resource		false	256	0	False
AgentName	string	SQL Server Agent Windows Service Name		false	256	0	False
AgentClusterName	string	SQL Server Agent Windows Service Name If Clustered Resource		false	256	0	False
ConnectionString	string	Connection String		false	256	0	False
MasterDatabaseLocation	string	Master Database Location		false	256	0	False
MasterDatabaseLogLocation	string	Master Database Log Location		false	256	0	False
ErrorLogLocation	string	Error Log Location		false	256	0	False
Language	string	Language		false	256	0	False
ServicePackVersion	string	Service Pack Version		false	256	0	False
AuditLevel	string	Audit Level		false	256	0	False
InstallPath	string	Install Path		false	256	0	False
ToolsPath	string	Tools Path		false	256	0	False
EnableErrorReporting	string	Error Reporting Enabled		false	256	0	False
ReplicationWorkingDirectory	string	Replication Working Directory		false	256	0	False
ReplicationDistributionDatabase	string	Replication Distribution Database		false	256	0	False
PerformanceCounterObject	string	Performance Counter Object Name		false	256	0	False
Cluster	string	Cluster		false	256	0	False
Account	string	Account Name		false	256	0	False
Microsoft.KnowledgeServices.SQLServer.DBEngine:
ManagementPackVersion	string			false	256	0	False
ProductVersion	string	ProductVersion	Product Version from the ServerProperty	false	256	0	False
MajorVersion	int	MajorVersion	Build Major Version	false	256	0
MinorVersion	int	MinorVersion	Build Minor Version	false	256	0
BuildNumber	int	BuildNumber	Build Number	false	256	0
BuildRevisionNumber	int	BuildRevisionNumber	Build Revision Number	false	256	0
NtoskrnlVersion	string			false	256	0	False
NtoskrnlMajor	int			false	256	0
NtoskrnlMinor	int			false	256	0
NtoskrnlBuild	int			false	256	0
NtoskrnlRevision	int			false	256	0
Platform	string	Platform	SQL Platform	false	256	0	False
AffinityMaskUncommittedValue	int	AffinityMaskUncommittedValue	affinity mask config	false	256	0
AffinityIOMaskUncommittedValue	int	AffinityIOMaskUncommittedValue	affinity I/O Mask config	false	256	0
Affinity64MaskUncommittedValue	int	Affinity64MaskUncommittedValue	Affinity64 Mask config	false	256	0
Affinity64IOMaskUncommittedValue	int	Affinity64IOMaskUncommittedValue	affinity64 I/O Mask config	false	256	0
AffinityMask	int	AffinityMask	affinity mask config from value_in_use column	false	256	0
AffinityIOMask	int	AffinityIOMask	affinity I/O mask config from value_in_use column	false	256	0
Affinity64Mask	int	Affinity64Mask	affinity64 mask config from value_in_use column	false	256	0
Affinity64IOMask	int	Affinity64IOMask	affinity64 I/O mask config from value_in_use column	false	256	0
BuildClrVersion	string	BuildClrVersion	BuildClrVersion	false	256	0	False
Collation	string	Collation	Collation	false	256	0	False
ComparisonStyle	int	ComparisonStyle	ComparisonStyle	false	256	0
ComputerNamePhysicalNetBIOS	string	ComputerNamePhysicalNetBIOS	ComputerNamePhysicalNetBIOS	false	256	0	False
EngineEdition	int	EngineEdition	EngineEdition	false	256	0
IsClustered	bool	IsClustered	IsClustered	false	256	0
IsFullTextInstalled	bool	IsFullTextInstalled	IsFullTextInstalled	false	256	0
IsIntegratedSecurityOnly	bool	IsIntegratedSecurityOnly	IsIntegratedSecurityOnly	false	256	0
IsSingleUser	bool	IsSingleUser	IsSingleUser	false	256	0
LCID	int	LCID	LCID	false	256	0
NumLicenses	int	NumLicenses	NumLicenses	false	256	0
ProcessID	int	ProcessID	ProcessID	false	256	0
ProductLevel	string	ProductLevel	ProductLevel	false	256	0	False
ResourceLastUpdateDateTime	string	ResourceLastUpdateDateTime	ResourceLastUpdateDateTime	false	256	0	False
SqlCharSetName	string	SqlCharSetName	SqlCharSetName	false	256	0	False
SqlSortOrderName	string	SqlSortOrderName	SqlSortOrderName	false	256	0	False
FilestreamShareName	string	FilestreamShareName	FilestreamShareName	false	256	0	False
FilestreamConfiguredLevel	string	FilestreamConfiguredLevel	FilestreamConfiguredLevel	false	256	0	False
FilestreamEffectiveLevel	string	FilestreamEffectiveLevel	FilestreamEffectiveLevel	false	256	0	False
RecoveryInterval	int	RecoveryInterval	Maximum recovery interval in minutes	false	256	0
AllowUpdates	bool	AllowUpdates	Allow updates to system tables	false	256	0
UserConnections	int	UserConnections	Number of user connections allowed	false	256	0
Locks	int	Locks	Number of locks for all users	false	256	0
OpenObjects	int	OpenObjects	Number of open database objects	false	256	0
FillFactor	int	FillFactor	Default fill factor percentage	false	256	0
DisallowResultsFromTriggers	bool	DisallowResultsFromTriggers	Disallow returning results from triggers	false	256	0
NestedTriggers	bool	NestedTriggers	Allow triggers to be invoked within triggers	false	256	0
ServerTriggerRecursionEnabled	bool	ServerTriggerRecursionEnabled	Allow recursion for server level triggers	false	256	0
RemoteAccess	bool	RemoteAccess	Allow remote access	false	256	0
DefaultLanguage	int	DefaultLanguage	default language	false	256	0
CrossDBOwnershipChaining	bool	CrossDBOwnershipChaining	Allow cross db ownership chaining	false	256	0
MaxWorkerThreads	int	MaxWorkerThreads	Maximum worker threads	false	256	0
NetworkPacketSize	int	NetworkPacketSize	Network packet size	false	256	0
NetworkPacketSizeUncommittedValue	int	NetworkPacketSizeUncommittedValue	Network packet size uncommitted value	false	256	0
ShowAdvancedOptions	bool	ShowAdvancedOptions	show advanced options	false	256	0
RemoteProcTrans	bool	RemoteProcTrans	Create DTC transaction for remote procedures	false	256	0
C2AuditMode	bool	C2AuditMode	c2 audit mode	false	256	0
DefaultFullTextLanguage	int	DefaultFullTextLanguage	default full-text language	false	256	0
TwoDigitYearCutoff	int	TwoDigitYearCutoff	two digit year cutoff	false	256	0
IndexCreateMemory	int	IndexCreateMemory	Memory for index create sorts (kBytes)	false	256	0
PriorityBoost	bool	PriorityBoost	Priority boost	false	256	0
RemoteLoginTimeout	int	RemoteLoginTimeout	remote login timeout	false	256	0
RemoteQueryTimeout	int	RemoteQueryTimeout	remote query timeout	false	256	0
CursorThreshold	int	CursorThreshold	cursor threshold	false	256	0
SetWorkingSetSize	bool	SetWorkingSetSize	set working set size	false	256	0
UserOptions	int	UserOptions	user options	false	256	0
ReplicationMaxTextSize	int	ReplicationMaxTextSize	Maximum size of a text field in replication.	false	256	0
MediaRetention	int	MediaRetention	Tape retention period in days	false	256	0
CostThresholdForParallelism	int	CostThresholdForParallelism	cost threshold for parallelism	false	256	0
MaxDegreeOfParallelism	int	MaxDegreeOfParallelism	maximum degree of parallelism	false	256	0
MinMemoryPerQuery	int	MinMemoryPerQuery	minimum memory per query (kBytes)	false	256	0
QueryWait	int	QueryWait	maximum time to wait for query memory (s)	false	256	0
MinServerMemory	int	MinServerMemory	Minimum size of server memory (MB)	false	256	0
MaxServerMemory	int	MaxServerMemory	Maximum size of server memory (MB)	false	256	0
QueryGovernorCostLimit	int	QueryGovernorCostLimit	Maximum estimated cost allowed by query governor	false	256	0
LightweightPooling	bool	LightweightPooling	User mode scheduler uses lightweight pooling	false	256	0
ScanForStartupProcedures	bool	ScanForStartupProcedures	scan for startup stored procedures	false	256	0
AweEnabled	bool	AweEnabled	AWE enabled in the server	false	256	0
TransformNoiseWords	bool	TransformNoiseWords	Transform noise words for full-text query	false	256	0
PrecomputeRank	bool	PrecomputeRank	Use precomputed rank for full-text query	false	256	0
ProtocolHandlerTimeout	int	ProtocolHandlerTimeout	DB connection timeout for full-text protocol handler (s)	false	256	0
IsSqlClrEnabled	bool	IsSqlClrEnabled	CLR user code execution enabled in the server	false	256	0
IsSqlClrLoaded	bool	IsSqlClrLoaded	.NET Framework loaded into SQL Server instance memory	false	256	0
MemoryReserveSize	int	MemoryReserveSize	Current value used for memory_to_reserve startup parameter	false	256	0
FullTextCrawlRangeMax	int	FullTextCrawlRangeMax	Maximum crawl ranges allowed in full-text indexing	false	256	0
FullTextNotifyBandwidthMin	int	FullTextNotifyBandwidthMin	Number of reserved full-text notifications buffers	false	256	0
FullTextNotifyBandwidthMax	int	FullTextNotifyBandwidthMax	Max number of full-text notifications buffers	false	256	0
FullTextCrawlBandwidthMin	int	FullTextCrawlBandwidthMin	Number of reserved full-text crawl buffers	false	256	0
FullTextCrawlBandwidthMax	int	FullTextCrawlBandwidthMax	Max number of full-text crawl buffers	false	256	0
DefaultTraceEnabled	bool	DefaultTraceEnabled	Enable or disable the default trace	false	256	0
BlockedProcessThreshold	int	BlockedProcessThreshold	Blocked process reporting threshold	false	256	0
InDoubtTransactionResolution	int	InDoubtTransactionResolution	Recovery policy for DTC transactions with unknown outcome	false	256	0
RemoteAdminConnections	bool	RemoteAdminConnections	Dedicated Admin Connections are allowed from remote clients	false	256	0
CommonCriteriaComplianceEnabled	bool	CommonCriteriaComplianceEnabled	Common Criteria compliance mode enabled	false	256	0
ExtensibleKeyManagementEnabled	bool	ExtensibleKeyManagementEnabled	Enable or disable EKM provider	false	256	0
DefaultBackupCompression	bool	DefaultBackupCompression	Enable compression of backups by default	false	256	0
FilestreamAccessLevel	int	FilestreamAccessLevel	Sets the FILESTREAM access level	false	256	0
OptimizeForAdHocWorkloads	bool	OptimizeForAdHocWorkloads	When this option is set	false	256	0
AccessCheckCacheBucketCount	int	AccessCheckCacheBucketCount	Default hash bucket count for the access check result security cache	false	256	0
AccessCheckCacheQuota	int	AccessCheckCacheQuota	Default quota for the access check result security cache	false	256	0
AgentXPsEnabled	bool	AgentXPsEnabled	Enable or disable Agent XPs	false	256	0
SqlMailXPsEnabled	bool	SqlMailXPsEnabled	Enable or disable SQL Mail XPs	false	256	0
DatabaseMailEnabled	bool	DatabaseMailEnabled	Enable or disable Database Mail XPs	false	256	0
SmoAndDmoXPsEnabled	bool	SmoAndDmoXPsEnabled	Enable or disable SMO and DMO XPs	false	256	0
OleAutomationProceduresEnabled	bool	OleAutomationProceduresEnabled	Enable or disable Ole Automation Procedures	false	256	0
XPCmdShellEnabled	bool	XPCmdShellEnabled	Enable or disable command shell	false	256	0
AdHocDistributedQueriesEnabled	bool	AdHocDistributedQueriesEnabled	Enable or disable Ad Hoc Distributed Queries	false	256	0
ReplicationXPsEnabled	bool	ReplicationXPsEnabled	Enable or disable Replication XPs	false	256	0
InstanceId	string	InstanceId	Instance ID of the database	false	256	0	False
MaxWorkersCount	int	Max workers count	Max workers count	false	256	0
SqlServerStartTime	datetime	SqlServer start time	The start time of SqlServer	false	256	0
StartupParameters	string	Startup parameters	SqlServer startup parameters	false	512	0	False
SqlProtocols	string	SQL Protocols	SQL protocals.	false	256	0	False
TraceFlagsEnabled	string	TraceFlagsEnabled	List of trace flags that are enabled	false	256	0	False
LinkedServersCount	int	LinkedServersCount	Linked Servers Count	false	256	0
SQLMemoryModel	string	SQLMemoryModel	SQL Memory Model	false	256	0	False
MaxWorkersConfig	string	MaxWorkersConfig	Max Workers Config	false	256	0	False
SchedulerCount	int	SchedulerCount	Scheduler Count	false	256	0
ProcessorGroupsTotal	int	ProcessorGroupsTotal	Processor Groups Total	false	256	0
NumaNodesTotal	int	NumaNodesTotal	Numa Nodes Total	false	256	0
NumaNodesUsed	int	NumaNodesUsed	Numa Nodes Used	false	256	0

Health Model:

System.Health.EntityState

Source Code:

<ClassType ID="Microsoft.KnowledgeServices.SQLServer.DBEngine" Accessibility="Public" Abstract="false" Base="SQL!Microsoft.SQLServer.DBEngine" Hosted="true" Singleton="false">

  <Property ID="ManagementPackVersion" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ProductVersion" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MajorVersion" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MinorVersion" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="BuildNumber" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="BuildRevisionNumber" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NtoskrnlVersion" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NtoskrnlMajor" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NtoskrnlMinor" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NtoskrnlBuild" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NtoskrnlRevision" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="Platform" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AffinityMaskUncommittedValue" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AffinityIOMaskUncommittedValue" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="Affinity64MaskUncommittedValue" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="Affinity64IOMaskUncommittedValue" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AffinityMask" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AffinityIOMask" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="Affinity64Mask" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="Affinity64IOMask" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="BuildClrVersion" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="Collation" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ComparisonStyle" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ComputerNamePhysicalNetBIOS" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="EngineEdition" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="IsClustered" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="IsFullTextInstalled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="IsIntegratedSecurityOnly" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="IsSingleUser" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="LCID" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NumLicenses" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ProcessID" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ProductLevel" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ResourceLastUpdateDateTime" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="SqlCharSetName" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="SqlSortOrderName" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FilestreamShareName" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FilestreamConfiguredLevel" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FilestreamEffectiveLevel" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="RecoveryInterval" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AllowUpdates" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="UserConnections" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="Locks" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="OpenObjects" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FillFactor" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="DisallowResultsFromTriggers" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NestedTriggers" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ServerTriggerRecursionEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="RemoteAccess" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="DefaultLanguage" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="CrossDBOwnershipChaining" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MaxWorkerThreads" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NetworkPacketSize" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NetworkPacketSizeUncommittedValue" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ShowAdvancedOptions" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="RemoteProcTrans" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="C2AuditMode" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="DefaultFullTextLanguage" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="TwoDigitYearCutoff" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="IndexCreateMemory" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="PriorityBoost" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="RemoteLoginTimeout" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="RemoteQueryTimeout" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="CursorThreshold" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="SetWorkingSetSize" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="UserOptions" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ReplicationMaxTextSize" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MediaRetention" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="CostThresholdForParallelism" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MaxDegreeOfParallelism" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MinMemoryPerQuery" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="QueryWait" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MinServerMemory" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MaxServerMemory" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="QueryGovernorCostLimit" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="LightweightPooling" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ScanForStartupProcedures" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AweEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="TransformNoiseWords" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="PrecomputeRank" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ProtocolHandlerTimeout" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="IsSqlClrEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="IsSqlClrLoaded" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MemoryReserveSize" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FullTextCrawlRangeMax" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FullTextNotifyBandwidthMin" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FullTextNotifyBandwidthMax" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FullTextCrawlBandwidthMin" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FullTextCrawlBandwidthMax" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="DefaultTraceEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="BlockedProcessThreshold" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="InDoubtTransactionResolution" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="RemoteAdminConnections" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="CommonCriteriaComplianceEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ExtensibleKeyManagementEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="DefaultBackupCompression" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="FilestreamAccessLevel" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="OptimizeForAdHocWorkloads" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AccessCheckCacheBucketCount" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AccessCheckCacheQuota" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AgentXPsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="SqlMailXPsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="DatabaseMailEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="SmoAndDmoXPsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="OleAutomationProceduresEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="XPCmdShellEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="AdHocDistributedQueriesEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="ReplicationXPsEnabled" Type="bool" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="InstanceId" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="MaxWorkersCount" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="SqlServerStartTime" Type="datetime" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="StartupParameters" Type="string" Key="false" CaseSensitive="false" Length="512" MinLength="0"/>

  <Property ID="SqlProtocols" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="TraceFlagsEnabled" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="LinkedServersCount" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <!--BEGIN : Edited by ericzha-->

  <Property ID="SQLMemoryModel" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <!--END : Edited by ericzha-->

  <!--BEGIN : Edited by v-jobzha-->

  <Property ID="MaxWorkersConfig" Type="string" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="SchedulerCount" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <!--END : Edited by v-jobzha-->

  <!--BEGIN: Edited by v-taliu-->

  <Property ID="ProcessorGroupsTotal" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NumaNodesTotal" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <Property ID="NumaNodesUsed" Type="int" Key="false" CaseSensitive="false" Length="256" MinLength="0"/>

  <!--END: Edited by v-taliu-->

</ClassType>