Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Using DATABASEPROPERTYEX to Find the Last Good DBCC CHECKDB Time

DZone's Guide to

Using DATABASEPROPERTYEX to Find the Last Good DBCC CHECKDB Time

Need to know when the last known DBCC CHECKDB was run on your database? See how to do it with ease in SQL Server 2016 and 2017.

· Database Zone ·
Free Resource

Running out of memory? Learn how Redis Enterprise enables large dataset analysis with the highest throughput and lowest latency while reducing costs over 75%! 

For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database. Microsoft has not exposed this information in an easily digestible format. You can find a handful of options available online for returning this information. My favorite was this post by Rob Sewell.

It was my favorite.

And then I read this post by Pedro Lopes regarding SQL Server 2016 SP2 features. Buried deep in that post is this gem:

Expose last known good DBCC CHECKDB information — A new database option has been added to programmatically return the date of the last successful DBCC CHECKDB run. Users can now query DATABASEPROPERTYEX([database], ‘lastgoodcheckdbtime’) to obtain a single value representing the date/time of the last successful DBCC CHECKDB run on the specified database.

That’s right, we no longer need complicated scripts to find the last known good DBCC CHECKDB date. It’s as simple as a SELECT statement. This SELECT statement, to be exact:

SELECT DATABASEPROPERTYEX ('dbname' , 'LastGoodCheckDbTime' )


This is a wonderful addition. I have no idea why we didn’t have something so simple many, many years ago. But we have it now. So, let’s enjoy it a bit.

Using DATABASEPROPERTYEX to Find the Last Good DBCC CHECKDB Time

The statement above will return a DATETIME with the last known good date. If there is no CHECKDB recorded, it returns our old friend, 01-Jan-1900. I suppose it could have returned NULL, but NULL is “unknown”, and the answer here isn’t “unknown”. If there is no CHECKDB and you need to return a date, 01-Jan-1900 is your best friend. This is how Data Janitors earn their money.

Warrants mentioning: This feature is *NOT* available in SQL Server 2017 yet. So, if you try running this command on an instance of SQL 2017 you will get back a NULL result. You might think that means “no DBCC CHECKDB”, but you’d be wrong. The documentation for DATABASEPROPERTYEX is clear what a NULL result means.

Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time

So, if DATABASEPROPERTYEX (‘dbname’, ‘LastGoodCheckDbTime’) returns NULL, that means ‘Input not valid’. It is likely you are trying to run this command against an instance for which it is not supported. To make matters more confusing, the documentation suggests that this *is* supported for SQL2017. So, don’t be like me and spend an hour trying to make it work on SQL 2017. It’s not there yet. I can’t say this enough.

Finding Policy-Based Management Facets for DBCC CHECKDB

Since this new feature has made life so much easier for SQL Server administrators, I decided to check and see if there was a policy facet for DBCCCHECKDB.

You can’t query a DMV for the list of policy facets. The only way I’ve found to get this list is to use some Powershell. Here is the code I’ve used in the past to output the list to a file:

$conn = New-Object Microsoft.SQLServer.Management.Sdk.Sfc.SqlStoreConnection("server=PORC\SQL2016;Trusted_Connection=true");
$PolicyStore = New-Object Microsoft.SQLServer.Management.DMF.PolicyStore($conn);
$facets = [Microsoft.SqlServer.Management.Dmf.PolicyStore]::Facets
out-file "C:\TeamData\PBM_facet_counts_2016.txt"
foreach ($i in $facets)
{
    $f = $facets[$i.Name]
    $fp = $f.FacetProperties
    foreach ($j in $fp)
    {
        $fpstring = $i.name + "," + $j.Name
        $fpstring | out-file "C:\TeamData\PBM_facet_counts_2016.txt" -append
    }
}


I’ve included the long list of facets at the bottom of this post if you are interested in viewing them. Two things worth mentioning here. The list of facets is identical from SQL2016 to SQL2017. So, no advancements in Policy-Based Management (PBM), and I don’t know if there are any advancements in PBM coming. I think PBM is a great feature that is not being used. And if it is not being used it is hard to justify engineering time.

The second thing worth mentioning is that there is no facet for DBCC CHECKDB. Again, this seems like a silly oversight from Microsoft going back to 2008. That’s an important piece of information and it should not have taken so long to make this detail easily discoverable. Then again…they have the telemetry to know how important this would be to customers…and I’m not going to argue with how they spend their time. I trust they are doing the best they can with the data they have.

Using Policy-Based Management to Find the Last Good DBCC CHECKDB Time

So, there is no facet for us to use. That’s OK. We can create a custom condition using the ExecuteSql() function. The code we need is very simple now, thanks to the DATABASEPROPERTYEX feature.

We will create a new condition:

Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time

Here’s the code being used. Two things to mention here. First, you need two single quotes around the LastGoodCheckDbTime. That is not a typo. Second, I am using the DB_NAME() function, as the policy is being executed against a database target. This will allow the current database to be checked.

ExecuteSql('Numeric', '
SELECT DATEDIFF(dd
, (SELECT CONVERT(DATETIME, DATABASEPROPERTYEX (DB_NAME() , ''LastGoodCheckDbTime'' )))
, GETDATE())
')


Also, I am using DATEDIFF to return the difference in days since the last known DBCC CHECKDB command. How often you decide to run CHECKDB is up to you. For this example, I will set the condition to be less than or equal to 7 days.

Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time


You should use a number that works best for you. OK, now we are ready to create the policy.

Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time

Now we can evaluate against my instance:

Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time

As you can see, I’m not up to date on my maintenance for this instance. I only have one database that has a CHECKDB in the past 7 days.

Reporting

I’m not going to lie, the PBM GUI is not the best for viewing results. And unless you are using a Central Management Server, you are going to spend a lot of time going from one instance to another to review the results. Thankfully we have some options.

Here’s what I would do as a production SQL Server DBA, and I wanted to roll my own PBM solution.

First, I’d build the policy, make certain it worked, and then export it as an XML file.

Then, I’d use Powershell and the Invoke-PolicyEvaluation cmdlet, and execute the policy against all my instances.

I would output the results to XML and use a tool to parse those files into something readable. A tool like PowerBI, perhaps. Or something like Log and Event Manager, or Loggly, or Papertrail, or anything that lets me input a file and get value.

Lastly, I’d sit back with some scotch and some bacon. You should do what works for you though.

Summary

The DATABASEPROPERTYEX feature with LastGoodCheckDbTime is a great new feature inside of SQL Server. It is only in SQL Server 2016 SP2 right now. I am hopeful it will be in SQL Server 2017 soon.

You can use this new feature to create a policy using PBM to help you stay on top of your database maintenance tasks. It’s easy to implement. It’s also easy to implement a solution across your entire enterprise using Powershell.

List of Policy-Based Management Facets for SQL Server 2016 and 2017

Here’s the list of facets returned from my instances of SQL Server 2016 and SQL Server 2017. Use this list to find a facet that may be useful for you to wrap into a policy. If you need help with a custom policy feel free to contact me.

ApplicationRole,CreateDate
ApplicationRole,DateLastModified
ApplicationRole,ID
ApplicationRole,DefaultSchema
ApplicationRole,Name
AsymmetricKey,ID
AsymmetricKey,KeyEncryptionAlgorithm
AsymmetricKey,KeyLength
AsymmetricKey,Owner
AsymmetricKey,PrivateKeyEncryptionType
AsymmetricKey,PublicKey
AsymmetricKey,Sid
AsymmetricKey,Thumbprint
AsymmetricKey,ProviderName
AsymmetricKey,Name
Audit,CreateDate
Audit,DateLastModified
Audit,DestinationType
Audit,Enabled
Audit,FileName
Audit,FilePath
Audit,Guid
Audit,ID
Audit,MaximumFileSize
Audit,MaximumFileSizeUnit
Audit,MaximumRolloverFiles
Audit,OnFailure
Audit,QueueDelay
Audit,ReserveDiskSpace
Audit,Filter
Audit,MaximumFiles
Audit,Name
AvailabilityDatabase,IsFailoverReady
AvailabilityDatabase,IsJoined
AvailabilityDatabase,IsPendingSecondarySuspend
AvailabilityDatabase,IsSuspended
AvailabilityDatabase,RecoveryLSN
AvailabilityDatabase,SynchronizationState
AvailabilityDatabase,TruncationLSN
AvailabilityDatabase,UniqueId
AvailabilityDatabase,Name
AvailabilityGroup,AutomatedBackupPreference
AvailabilityGroup,FailureConditionLevel
AvailabilityGroup,HealthCheckTimeout
AvailabilityGroup,ID
AvailabilityGroup,LocalReplicaRole
AvailabilityGroup,PrimaryReplicaServerName
AvailabilityGroup,UniqueId
AvailabilityGroup,BasicAvailabilityGroup
AvailabilityGroup,DatabaseHealthTrigger
AvailabilityGroup,DtcSupportEnabled
AvailabilityGroup,IsDistributedAvailabilityGroup
AvailabilityGroup,ClusterType
AvailabilityGroup,RequiredCopiesToCommit
AvailabilityGroup,Name
IAvailabilityGroupState,IsOnline
IAvailabilityGroupState,IsAutoFailover
IAvailabilityGroupState,NumberOfSynchronizedSecondaryReplicas
IAvailabilityGroupState,NumberOfNotSynchronizingReplicas
IAvailabilityGroupState,NumberOfNotSynchronizedReplicas
IAvailabilityGroupState,NumberOfReplicasWithUnhealthyRole
IAvailabilityGroupState,NumberOfDisconnectedReplicas
AvailabilityReplica,AvailabilityMode
AvailabilityReplica,BackupPriority
AvailabilityReplica,ConnectionModeInPrimaryRole
AvailabilityReplica,ConnectionModeInSecondaryRole
AvailabilityReplica,ConnectionState
AvailabilityReplica,CreateDate
AvailabilityReplica,DateLastModified
AvailabilityReplica,EndpointUrl
AvailabilityReplica,FailoverMode
AvailabilityReplica,JoinState
AvailabilityReplica,LastConnectErrorDescription
AvailabilityReplica,LastConnectErrorNumber
AvailabilityReplica,LastConnectErrorTimestamp
AvailabilityReplica,MemberState
AvailabilityReplica,OperationalState
AvailabilityReplica,Owner
AvailabilityReplica,QuorumVoteCount
AvailabilityReplica,ReadonlyRoutingConnectionUrl
AvailabilityReplica,Role
AvailabilityReplica,RollupRecoveryState
AvailabilityReplica,RollupSynchronizationState
AvailabilityReplica,SessionTimeout
AvailabilityReplica,UniqueId
AvailabilityReplica,SeedingMode
AvailabilityReplica,Name
BackupDevice,BackupDeviceType
BackupDevice,PhysicalLocation
BackupDevice,SkipTapeLabel
BackupDevice,Name
BrokerPriority,ContractName
BrokerPriority,ID
BrokerPriority,LocalServiceName
BrokerPriority,PriorityLevel
BrokerPriority,RemoteServiceName
BrokerPriority,Name
BrokerService,ID
BrokerService,IsSystemObject
BrokerService,Owner
BrokerService,QueueName
BrokerService,QueueSchema
BrokerService,Name
Certificate,ActiveForServiceBrokerDialog
Certificate,ExpirationDate
Certificate,ID
Certificate,Issuer
Certificate,Owner
Certificate,PrivateKeyEncryptionType
Certificate,Serial
Certificate,Sid
Certificate,StartDate
Certificate,Subject
Certificate,Thumbprint
Certificate,LastBackupDate
Certificate,Name
ColumnEncryptionKey,CreateDate
ColumnEncryptionKey,DateLastModified
ColumnEncryptionKey,ID
ColumnEncryptionKey,Name
ColumnEncryptionKeyValue,ColumnEncryptionKeyName
ColumnEncryptionKeyValue,ColumnMasterKeyID
ColumnEncryptionKeyValue,ColumnMasterKeyName
ColumnEncryptionKeyValue,EncryptedValue
ColumnEncryptionKeyValue,EncryptionAlgorithm
ColumnMasterKey,CreateDate
ColumnMasterKey,DateLastModified
ColumnMasterKey,ID
ColumnMasterKey,KeyPath
ColumnMasterKey,KeyStoreProviderName
ColumnMasterKey,Name
Computer,Name
Computer,ID
Computer,IsClustered
Computer,ProcessorUtilization
Computer,CpuName
Computer,CpuMaxClockSpeed
Credential,CreateDate
Credential,DateLastModified
Credential,ID
Credential,Identity
Credential,MappedClassType
Credential,ProviderName
Credential,Name
CryptographicProvider,AsymmetricKeyExportable
CryptographicProvider,AsymmetricKeyImportable
CryptographicProvider,AsymmetricKeyPersistable
CryptographicProvider,AsymmetricKeySupported
CryptographicProvider,AuthenticationType
CryptographicProvider,DllPath
CryptographicProvider,Enabled
CryptographicProvider,ID
CryptographicProvider,ProviderGuid
CryptographicProvider,SymmetricKeyExportable
CryptographicProvider,SymmetricKeyImportable
CryptographicProvider,SymmetricKeyPersistable
CryptographicProvider,SymmetricKeySupported
CryptographicProvider,Name
DataFile,AvailableSpace
DataFile,FileName
DataFile,Growth
DataFile,GrowthType
DataFile,ID
DataFile,IsPrimaryFile
DataFile,MaxSize
DataFile,Size
DataFile,UsedSpace
DataFile,BytesReadFromDisk
DataFile,BytesWrittenToDisk
DataFile,IsOffline
DataFile,IsReadOnly
DataFile,IsReadOnlyMedia
DataFile,IsSparse
DataFile,NumberOfDiskReads
DataFile,NumberOfDiskWrites
DataFile,VolumeFreeSpace
DataFile,Name
IDataFilePerformanceFacet,SpaceUtilization
Database,ActiveConnections
Database,AutoClose
Database,AutoShrink
Database,CompatibilityLevel
Database,CreateDate
Database,DataSpaceUsage
Database,DboLogin
Database,DefaultFileGroup
Database,DefaultSchema
Database,ID
Database,IndexSpaceUsage
Database,IsAccessible
Database,IsDbAccessAdmin
Database,IsDbBackupOperator
Database,IsDbDatareader
Database,IsDbDatawriter
Database,IsDbDdlAdmin
Database,IsDbDenyDatareader
Database,IsDbDenyDatawriter
Database,IsDbOwner
Database,IsDbSecurityAdmin
Database,IsFullTextEnabled
Database,IsSqlDw
Database,IsSystemObject
Database,Owner
Database,PrimaryFilePath
Database,ReplicationOptions
Database,Size
Database,SpaceAvailable
Database,Status
Database,UserName
Database,AnsiNullDefault
Database,AnsiNullsEnabled
Database,AnsiPaddingEnabled
Database,AnsiWarningsEnabled
Database,ArithmeticAbortEnabled
Database,AutoCreateStatisticsEnabled
Database,AutoUpdateStatisticsEnabled
Database,CaseSensitive
Database,CloseCursorsOnCommitEnabled
Database,Collation
Database,ConcatenateNullYieldsNull
Database,DatabaseOwnershipChaining
Database,IsUpdateable
Database,LastBackupDate
Database,LastDifferentialBackupDate
Database,LastLogBackupDate
Database,LocalCursorsDefault
Database,NumericRoundAbortEnabled
Database,PageVerify
Database,QuotedIdentifiersEnabled
Database,ReadOnly
Database,RecoveryModel
Database,RecursiveTriggersEnabled
Database,UserAccess
Database,Version
Database,AutoUpdateStatisticsAsync
Database,BrokerEnabled
Database,DatabaseGuid
Database,DatabaseSnapshotBaseName
Database,DateCorrelationOptimization
Database,DefaultFullTextCatalog
Database,IsDatabaseSnapshot
Database,IsDatabaseSnapshotBase
Database,IsMailHost
Database,IsMirroringEnabled
Database,IsParameterizationForced
Database,IsReadCommittedSnapshotOn
Database,IsVarDecimalStorageFormatEnabled
Database,LogReuseWaitStatus
Database,MirroringFailoverLogSequenceNumber
Database,MirroringID
Database,MirroringPartner
Database,MirroringPartnerInstance
Database,MirroringRedoQueueMaxSize
Database,MirroringRoleSequence
Database,MirroringSafetyLevel
Database,MirroringSafetySequence
Database,MirroringStatus
Database,MirroringTimeout
Database,MirroringWitness
Database,MirroringWitnessStatus
Database,RecoveryForkGuid
Database,ServiceBrokerGuid
Database,SnapshotIsolationState
Database,Trustworthy
Database,ChangeTrackingAutoCleanUp
Database,ChangeTrackingEnabled
Database,ChangeTrackingRetentionPeriod
Database,ChangeTrackingRetentionPeriodUnits
Database,DefaultFileStreamFileGroup
Database,EncryptionEnabled
Database,HonorBrokerPriority
Database,IsManagementDataWarehouse
Database,AvailabilityDatabaseSynchronizationState
Database,AvailabilityGroupName
Database,ContainmentType
Database,FilestreamDirectoryName
Database,FilestreamNonTransactedAccess
Database,NestedTriggersEnabled
Database,TargetRecoveryTime
Database,TransformNoiseWords
Database,TwoDigitYearCutoff
Database,AutoCreateIncrementalStatisticsEnabled
Database,DelayedDurability
Database,HasFileInCloud
Database,HasMemoryOptimizedObjects
Database,MemoryAllocatedToMemoryOptimizedObjectsInKB
Database,MemoryUsedByMemoryOptimizedObjectsInKB
Database,LegacyCardinalityEstimation
Database,LegacyCardinalityEstimationForSecondary
Database,MaxDop
Database,ParameterSniffing
Database,ParameterSniffingForSecondary
Database,QueryOptimizerHotfixes
Database,QueryOptimizerHotfixesForSecondary
Database,RemoteDataArchiveCredential
Database,RemoteDataArchiveEnabled
Database,RemoteDataArchiveEndpoint
Database,RemoteDataArchiveLinkedServer
Database,RemoteDataArchiveUseFederatedServiceAccount
Database,RemoteDatabaseName
Database,Name
DatabaseAuditSpecification,AuditName
DatabaseAuditSpecification,CreateDate
DatabaseAuditSpecification,DateLastModified
DatabaseAuditSpecification,Enabled
DatabaseAuditSpecification,Guid
DatabaseAuditSpecification,ID
DatabaseAuditSpecification,Name
DatabaseDdlTrigger,AnsiNullsStatus
DatabaseDdlTrigger,AssemblyName
DatabaseDdlTrigger,BodyStartIndex
DatabaseDdlTrigger,ClassName
DatabaseDdlTrigger,CreateDate
DatabaseDdlTrigger,DateLastModified
DatabaseDdlTrigger,ExecutionContext
DatabaseDdlTrigger,ExecutionContextUser
DatabaseDdlTrigger,ID
DatabaseDdlTrigger,ImplementationType
DatabaseDdlTrigger,IsEnabled
DatabaseDdlTrigger,IsEncrypted
DatabaseDdlTrigger,IsSystemObject
DatabaseDdlTrigger,MethodName
DatabaseDdlTrigger,NotForReplication
DatabaseDdlTrigger,QuotedIdentifierStatus
DatabaseDdlTrigger,Text
DatabaseDdlTrigger,Name
IDatabaseMaintenanceFacet,RecoveryModel
IDatabaseMaintenanceFacet,ReadOnly
IDatabaseMaintenanceFacet,PageVerify
IDatabaseMaintenanceFacet,Status
IDatabaseMaintenanceFacet,LastBackupDate
IDatabaseMaintenanceFacet,LastLogBackupDate
IDatabaseMaintenanceFacet,DataAndBackupOnSeparateLogicalVolumes
IDatabaseMaintenanceFacet,TargetRecoveryTime
IDatabaseMaintenanceFacet,DelayedDurability
IDatabaseOptions,AnsiNullDefault
IDatabaseOptions,AnsiNullsEnabled
IDatabaseOptions,AnsiPaddingEnabled
IDatabaseOptions,AnsiWarningsEnabled
IDatabaseOptions,ArithmeticAbortEnabled
IDatabaseOptions,AutoClose
IDatabaseOptions,AutoCreateStatisticsEnabled
IDatabaseOptions,AutoCreateIncrementalStatisticsEnabled
IDatabaseOptions,AutoShrink
IDatabaseOptions,AutoUpdateStatisticsAsync
IDatabaseOptions,AutoUpdateStatisticsEnabled
IDatabaseOptions,BrokerEnabled
IDatabaseOptions,ChangeTrackingAutoCleanUp
IDatabaseOptions,ChangeTrackingEnabled
IDatabaseOptions,ChangeTrackingRetentionPeriod
IDatabaseOptions,ChangeTrackingRetentionPeriodUnits
IDatabaseOptions,CloseCursorsOnCommitEnabled
IDatabaseOptions,Collation
IDatabaseOptions,CompatibilityLevel
IDatabaseOptions,ConcatenateNullYieldsNull
IDatabaseOptions,CreateDate
IDatabaseOptions,DatabaseOwnershipChaining
IDatabaseOptions,DatabaseSnapshotBaseName
IDatabaseOptions,DateCorrelationOptimization
IDatabaseOptions,DefaultFileGroup
IDatabaseOptions,DefaultFileStreamFileGroup
IDatabaseOptions,EncryptionEnabled
IDatabaseOptions,HonorBrokerPriority
IDatabaseOptions,ID
IDatabaseOptions,IsParameterizationForced
IDatabaseOptions,IsReadCommittedSnapshotOn
IDatabaseOptions,IsSystemObject
IDatabaseOptions,IsUpdateable
IDatabaseOptions,LocalCursorsDefault
IDatabaseOptions,Name
IDatabaseOptions,Owner
IDatabaseOptions,NumericRoundAbortEnabled
IDatabaseOptions,MirroringTimeout
IDatabaseOptions,PageVerify
IDatabaseOptions,PrimaryFilePath
IDatabaseOptions,QuotedIdentifiersEnabled
IDatabaseOptions,ReadOnly
IDatabaseOptions,RecoveryModel
IDatabaseOptions,RecursiveTriggersEnabled
IDatabaseOptions,RemoteDataArchiveEnabled
IDatabaseOptions,RemoteDataArchiveEndpoint
IDatabaseOptions,RemoteDataArchiveLinkedServer
IDatabaseOptions,RemoteDatabaseName
IDatabaseOptions,RemoteDataArchiveUseFederatedServiceAccount
IDatabaseOptions,RemoteDataArchiveCredential
IDatabaseOptions,Trustworthy
IDatabaseOptions,UserAccess
IDatabaseOptions,TargetRecoveryTime
IDatabaseOptions,DelayedDurability
IDatabasePerformanceFacet,AutoClose
IDatabasePerformanceFacet,AutoShrink
IDatabasePerformanceFacet,Size
IDatabasePerformanceFacet,DataAndLogFilesOnSeparateLogicalVolumes
IDatabasePerformanceFacet,CollationMatchesModelOrMaster
IDatabasePerformanceFacet,IsSystemObject
IDatabasePerformanceFacet,Status
DatabaseReplicaState,AvailabilityDatabaseName
DatabaseReplicaState,AvailabilityDateabaseId
DatabaseReplicaState,AvailabilityGroupId
DatabaseReplicaState,AvailabilityGroupName
DatabaseReplicaState,AvailabilityReplicaId
DatabaseReplicaState,AvailabilityReplicaServerName
DatabaseReplicaState,DatabaseId
DatabaseReplicaState,EndOfLogLSN
DatabaseReplicaState,EstimatedDataLoss
DatabaseReplicaState,EstimatedRecoveryTime
DatabaseReplicaState,FileStreamSendRate
DatabaseReplicaState,IsFailoverReady
DatabaseReplicaState,IsJoined
DatabaseReplicaState,IsLocal
DatabaseReplicaState,IsSuspended
DatabaseReplicaState,LastCommitLSN
DatabaseReplicaState,LastCommitTime
DatabaseReplicaState,LastHardenedLSN
DatabaseReplicaState,LastHardenedTime
DatabaseReplicaState,LastReceivedLSN
DatabaseReplicaState,LastReceivedTime
DatabaseReplicaState,LastRedoneLSN
DatabaseReplicaState,LastRedoneTime
DatabaseReplicaState,LastSentLSN
DatabaseReplicaState,LastSentTime
DatabaseReplicaState,LogSendQueueSize
DatabaseReplicaState,LogSendRate
DatabaseReplicaState,RecoveryLSN
DatabaseReplicaState,RedoQueueSize
DatabaseReplicaState,RedoRate
DatabaseReplicaState,ReplicaAvailabilityMode
DatabaseReplicaState,ReplicaRole
DatabaseReplicaState,SuspendReason
DatabaseReplicaState,SynchronizationPerformance
DatabaseReplicaState,SynchronizationState
DatabaseReplicaState,TruncationLSN
DatabaseRole,CreateDate
DatabaseRole,DateLastModified
DatabaseRole,ID
DatabaseRole,IsFixedRole
DatabaseRole,Owner
DatabaseRole,Name
IDatabaseSecurityFacet,Trustworthy
IDatabaseSecurityFacet,IsOwnerSysadmin
Default,CreateDate
Default,ID
Default,Schema
Default,Name
DeployedDac,Id
DeployedDac,Name
DeployedDac,ServerInstanceName
DeployedDac,DeployedDate
DeployedDac,Description
DeployedDac,ProcessorUtilization
DeployedDac,DatabaseName
DeployedDac,ComputerName
DeployedDac,Collation
DeployedDac,CompatibilityLevel
DeployedDac,EncryptionEnabled
DeployedDac,RecoveryModel
DeployedDac,Trustworthy
DeployedDac,DacProcessorHealthState
DeployedDac,ComputerProcessorHealthState
DeployedDac,FileSpaceHealthState
DeployedDac,VolumeSpaceHealthState
DeployedDac,ContainsOverUtilizedVolumes
DeployedDac,ContainsUnderUtilizedVolumes
DeployedDac,ContainsOverUtilizedFileGroups
DeployedDac,ContainsUnderUtilizedFileGroups
DeployedDac,IsPolicyOverridden
DeployedDac,DatabaseState
Endpoint,EndpointState
Endpoint,EndpointType
Endpoint,ID
Endpoint,IsAdminEndpoint
Endpoint,IsSystemObject
Endpoint,Owner
Endpoint,ProtocolType
Endpoint,Name
FileGroup,ID
FileGroup,IsDefault
FileGroup,ReadOnly
FileGroup,Size
FileGroup,FileGroupType
FileGroup,IsFileStream
FileGroup,Name
FullTextCatalog,ErrorLogSize
FullTextCatalog,FullTextIndexSize
FullTextCatalog,HasFullTextIndexedTables
FullTextCatalog,ID
FullTextCatalog,ItemCount
FullTextCatalog,PopulationCompletionDate
FullTextCatalog,PopulationStatus
FullTextCatalog,RootPath
FullTextCatalog,UniqueKeyCount
FullTextCatalog,FileGroup
FullTextCatalog,IsAccentSensitive
FullTextCatalog,IsDefault
FullTextCatalog,Owner
FullTextCatalog,Name
FullTextIndex,CatalogName
FullTextIndex,ChangeTracking
FullTextIndex,IsEnabled
FullTextIndex,PopulationStatus
FullTextIndex,UniqueIndexName
FullTextIndex,DocumentsProcessed
FullTextIndex,ItemCount
FullTextIndex,NumberOfFailures
FullTextIndex,PendingChanges
FullTextIndex,FilegroupName
FullTextIndex,StopListName
FullTextIndex,StopListOption
FullTextIndex,SearchPropertyListName
FullTextStopList,ID
FullTextStopList,Owner
FullTextStopList,Name
Index,DisallowPageLocks
Index,DisallowRowLocks
Index,FileGroup
Index,FillFactor
Index,HasSparseColumn
Index,ID
Index,IgnoreDuplicateKeys
Index,IndexKeyType
Index,IndexType
Index,IsClustered
Index,IsFullTextKey
Index,IsSystemNamed
Index,IsSystemObject
Index,IsUnique
Index,NoAutomaticRecomputation
Index,PadIndex
Index,SpaceUsed
Index,IsDisabled
Index,IsPartitioned
Index,IsXmlIndex
Index,ParentXmlIndex
Index,PartitionScheme
Index,SecondaryXmlIndexType
Index,BoundingBoxXMax
Index,BoundingBoxXMin
Index,BoundingBoxYMax
Index,BoundingBoxYMin
Index,CellsPerObject
Index,FileStreamFileGroup
Index,FileStreamPartitionScheme
Index,FilterDefinition
Index,HasCompressedPartitions
Index,HasFilter
Index,IsSpatialIndex
Index,Level1Grid
Index,Level2Grid
Index,Level3Grid
Index,Level4Grid
Index,SpatialIndexType
Index,IndexedXmlPathName
Index,IsFileTableDefined
Index,BucketCount
Index,IsMemoryOptimized
Index,CompressionDelay
Index,ResumableOperationState
Index,Name
LinkedServer,Catalog
LinkedServer,CollationCompatible
LinkedServer,DataAccess
LinkedServer,DataSource
LinkedServer,DistPublisher
LinkedServer,Distributor
LinkedServer,ID
LinkedServer,Location
LinkedServer,ProductName
LinkedServer,ProviderName
LinkedServer,Publisher
LinkedServer,Rpc
LinkedServer,RpcOut
LinkedServer,Subscriber
LinkedServer,CollationName
LinkedServer,ConnectTimeout
LinkedServer,LazySchemaValidation
LinkedServer,QueryTimeout
LinkedServer,UseRemoteCollation
LinkedServer,DateLastModified
LinkedServer,IsPromotionofDistributedTransactionsForRPCEnabled
LinkedServer,Name
LogFile,FileName
LogFile,Growth
LogFile,GrowthType
LogFile,ID
LogFile,MaxSize
LogFile,Size
LogFile,UsedSpace
LogFile,BytesReadFromDisk
LogFile,BytesWrittenToDisk
LogFile,IsOffline
LogFile,IsReadOnly
LogFile,IsReadOnlyMedia
LogFile,IsSparse
LogFile,NumberOfDiskReads
LogFile,NumberOfDiskWrites
LogFile,VolumeFreeSpace
LogFile,Name
ILogFilePerformanceFacet,SpaceUtilization
Login,CreateDate
Login,DateLastModified
Login,DefaultDatabase
Login,DenyWindowsLogin
Login,HasAccess
Login,IsSystemObject
Login,Language
Login,LanguageAlias
Login,LoginType
Login,Sid
Login,WindowsLoginAccessType
Login,AsymmetricKey
Login,Certificate
Login,Credential
Login,ID
Login,IsDisabled
Login,IsLocked
Login,IsPasswordExpired
Login,MustChangePassword
Login,PasswordExpirationEnabled
Login,PasswordPolicyEnforced
Login,PasswordHashAlgorithm
Login,Name
ILoginOptions,AsymmetricKey
ILoginOptions,Certificate
ILoginOptions,CreateDate
ILoginOptions,Credential
ILoginOptions,DefaultDatabase
ILoginOptions,ID
ILoginOptions,IsDisabled
ILoginOptions,IsLocked
ILoginOptions,IsSystemObject
ILoginOptions,Language
ILoginOptions,LanguageAlias
ILoginOptions,MustChangePassword
ILoginOptions,Name
ILoginOptions,PasswordExpirationEnabled
ILoginOptions,PasswordPolicyEnforced
MessageType,ID
MessageType,IsSystemObject
MessageType,MessageTypeValidation
MessageType,Owner
MessageType,ValidationXmlSchemaCollection
MessageType,ValidationXmlSchemaCollectionSchema
MessageType,Name
IMultipartNameFacet,Name
IMultipartNameFacet,Schema
INameFacet,Name
PartitionFunction,CreateDate
PartitionFunction,ID
PartitionFunction,NumberOfPartitions
PartitionFunction,RangeType
PartitionFunction,Name
PartitionScheme,ID
PartitionScheme,NextUsedFileGroup
PartitionScheme,PartitionFunction
PartitionScheme,Name
PlanGuide,Hints
PlanGuide,ID
PlanGuide,IsDisabled
PlanGuide,Parameters
PlanGuide,ScopeBatch
PlanGuide,ScopeObjectName
PlanGuide,ScopeSchemaName
PlanGuide,ScopeType
PlanGuide,Statement
PlanGuide,Name
RemoteServiceBinding,CertificateUser
RemoteServiceBinding,ID
RemoteServiceBinding,IsAnonymous
RemoteServiceBinding,Owner
RemoteServiceBinding,RemoteService
RemoteServiceBinding,Name
ResourceGovernor,ClassifierFunction
ResourceGovernor,Enabled
ResourceGovernor,ReconfigurePending
ResourceGovernor,MaxOutstandingIOPerVolume
ResourcePool,ID
ResourcePool,IsSystemObject
ResourcePool,MaximumCpuPercentage
ResourcePool,MaximumMemoryPercentage
ResourcePool,MinimumCpuPercentage
ResourcePool,MinimumMemoryPercentage
ResourcePool,CapCpuPercentage
ResourcePool,MaximumIopsPerVolume
ResourcePool,MinimumIopsPerVolume
ResourcePool,Name
Rule,CreateDate
Rule,ID
Rule,DateLastModified
Rule,Schema
Rule,Name
Schema,ID
Schema,IsSystemObject
Schema,Owner
Schema,Name
SearchPropertyList,DateCreated
SearchPropertyList,DateLastModified
SearchPropertyList,ID
SearchPropertyList,Owner
SearchPropertyList,Name
Sequence,CacheSize
Sequence,CreateDate
Sequence,DateLastModified
Sequence,ID
Sequence,IsCycleEnabled
Sequence,IsExhausted
Sequence,IsSchemaOwned
Sequence,Owner
Sequence,SequenceCacheType
Sequence,Schema
Sequence,Name
Server,AuditLevel
Server,BackupDirectory
Server,BuildNumber
Server,DefaultFile
Server,DefaultLog
Server,ErrorLogPath
Server,HostPlatform
Server,InstallDataDirectory
Server,IsCaseSensitive
Server,IsFullTextInstalled
Server,IsXTPSupported
Server,Language
Server,MailProfile
Server,MasterDBLogPath
Server,MasterDBPath
Server,MaxPrecision
Server,NumberOfLogFiles
Server,OSVersion
Server,PerfMonMode
Server,PhysicalMemory
Server,Platform
Server,Processors
Server,Product
Server,RootDirectory
Server,ServerType
Server,ServiceName
Server,VersionMajor
Server,VersionMinor
Server,Collation
Server,Edition
Server,EngineEdition
Server,InstanceName
Server,IsClustered
Server,IsSingleUser
Server,NetName
Server,ProductLevel
Server,Status
Server,TapeLoadWaitTime
Server,VersionString
Server,BrowserServiceAccount
Server,BrowserStartMode
Server,BuildClrVersionString
Server,CollationID
Server,ComparisonStyle
Server,ComputerNamePhysicalNetBIOS
Server,InstallSharedDirectory
Server,NamedPipesEnabled
Server,ResourceLastUpdateDateTime
Server,ResourceVersionString
Server,ServiceAccount
Server,ServiceInstanceId
Server,ServiceStartMode
Server,SqlCharSet
Server,SqlCharSetName
Server,SqlSortOrder
Server,SqlSortOrderName
Server,TcpEnabled
Server,FilestreamLevel
Server,FilestreamShareName
Server,PhysicalMemoryUsageInKB
Server,SqlDomainGroup
Server,ProcessorUsage
Server,ClusterName
Server,ClusterQuorumState
Server,ClusterQuorumType
Server,HadrManagerStatus
Server,IsHadrEnabled
Server,IsPolyBaseInstalled
Server,HostDistribution
Server,HostRelease
Server,HostServicePackLevel
Server,HostSku
IServerAuditFacet,DefaultTraceEnabled
IServerAuditFacet,C2AuditTracingEnabled
IServerAuditFacet,LoginAuditLevel
ServerAuditSpecification,AuditName
ServerAuditSpecification,CreateDate
ServerAuditSpecification,DateLastModified
ServerAuditSpecification,Enabled
ServerAuditSpecification,Guid
ServerAuditSpecification,ID
ServerAuditSpecification,Name
IServerConfigurationFacet,ContainmentEnabled
IServerConfigurationFacet,AdHocRemoteQueriesEnabled
IServerConfigurationFacet,AffinityMask
IServerConfigurationFacet,Affinity64Mask
IServerConfigurationFacet,AffinityIOMask
IServerConfigurationFacet,Affinity64IOMask
IServerConfigurationFacet,AgentXPsEnabled
IServerConfigurationFacet,AllowUpdates
IServerConfigurationFacet,AweEnabled
IServerConfigurationFacet,BlockedProcessThreshold
IServerConfigurationFacet,C2AuditTracingEnabled
IServerConfigurationFacet,ClrIntegrationEnabled
IServerConfigurationFacet,CommonCriteriaComplianceEnabled
IServerConfigurationFacet,CostThresholdForParallelism
IServerConfigurationFacet,CrossDBOwnershipChainingEnabled
IServerConfigurationFacet,CursorThreshold
IServerConfigurationFacet,DatabaseMailEnabled
IServerConfigurationFacet,DefaultTraceEnabled
IServerConfigurationFacet,DefaultFullTextLanguage
IServerConfigurationFacet,DefaultLanguage
IServerConfigurationFacet,DisallowResultsFromTriggers
IServerConfigurationFacet,FillFactor
IServerConfigurationFacet,FullTextCrawlBandwidthMin
IServerConfigurationFacet,FullTextCrawlBandwidthMax
IServerConfigurationFacet,FullTextNotifyBandwidthMin
IServerConfigurationFacet,FullTextNotifyBandwidthMax
IServerConfigurationFacet,FullTextCrawlRangeMax
IServerConfigurationFacet,InDoubtTransactionResolution
IServerConfigurationFacet,IndexCreateMemory
IServerConfigurationFacet,LightweightPoolingEnabled
IServerConfigurationFacet,DynamicLocks
IServerConfigurationFacet,MaxDegreeOfParallelism
IServerConfigurationFacet,MaxServerMemory
IServerConfigurationFacet,MaxWorkerThreads
IServerConfigurationFacet,MediaRetention
IServerConfigurationFacet,MinMemoryPerQuery
IServerConfigurationFacet,MinServerMemory
IServerConfigurationFacet,NestedTriggersEnabled
IServerConfigurationFacet,NetworkPacketSize
IServerConfigurationFacet,OleAutomationEnabled
IServerConfigurationFacet,OpenObjects
IServerConfigurationFacet,PrecomputeRank
IServerConfigurationFacet,PriorityBoost
IServerConfigurationFacet,ProtocolHandlerTimeout
IServerConfigurationFacet,QueryGovernorCostLimit
IServerConfigurationFacet,QueryWait
IServerConfigurationFacet,RecoveryInterval
IServerConfigurationFacet,RemoteAccessEnabled
IServerConfigurationFacet,RemoteDacEnabled
IServerConfigurationFacet,RemoteLoginTimeout
IServerConfigurationFacet,RemoteProcTransEnabled
IServerConfigurationFacet,RemoteQueryTimeout
IServerConfigurationFacet,ReplicationMaxTextSize
IServerConfigurationFacet,ReplicationXPsEnabled
IServerConfigurationFacet,ScanForStartupProcedures
IServerConfigurationFacet,ServerTriggerRecursionEnabled
IServerConfigurationFacet,SetWorkingSetSize
IServerConfigurationFacet,ShowAdvancedOptions
IServerConfigurationFacet,SmoAndDmoXPsEnabled
IServerConfigurationFacet,SqlMailEnabled
IServerConfigurationFacet,TransformNoiseWords
IServerConfigurationFacet,TwoDigitYearCutoff
IServerConfigurationFacet,UserConnections
IServerConfigurationFacet,UserInstanceTimeout
IServerConfigurationFacet,UserInstancesEnabled
IServerConfigurationFacet,UserOptions
IServerConfigurationFacet,WebAssistantEnabled
IServerConfigurationFacet,XPCmdShellEnabled
IServerConfigurationFacet,DefaultBackupCompressionEnabled
IServerConfigurationFacet,ExtensibleKeyManagementEnabled
IServerConfigurationFacet,FilestreamAccessLevel
IServerConfigurationFacet,OptimizeAdhocWorkloads
IServerConfigurationFacet,RemoteDataArchiveEnabled
ServerDdlTrigger,AnsiNullsStatus
ServerDdlTrigger,AssemblyName
ServerDdlTrigger,BodyStartIndex
ServerDdlTrigger,ClassName
ServerDdlTrigger,CreateDate
ServerDdlTrigger,DateLastModified
ServerDdlTrigger,ExecutionContext
ServerDdlTrigger,ExecutionContextLogin
ServerDdlTrigger,ID
ServerDdlTrigger,ImplementationType
ServerDdlTrigger,IsEnabled
ServerDdlTrigger,IsEncrypted
ServerDdlTrigger,IsSystemObject
ServerDdlTrigger,MethodName
ServerDdlTrigger,QuotedIdentifierStatus
ServerDdlTrigger,Text
ServerDdlTrigger,Name
IServerInformation,Collation
IServerInformation,Edition
IServerInformation,ErrorLogPath
IServerInformation,IsCaseSensitive
IServerInformation,IsClustered
IServerInformation,IsFullTextInstalled
IServerInformation,IsPolyBaseInstalled
IServerInformation,IsSingleUser
IServerInformation,Language
IServerInformation,MasterDBLogPath
IServerInformation,MasterDBPath
IServerInformation,MaxPrecision
IServerInformation,NetName
IServerInformation,OSVersion
IServerInformation,PhysicalMemory
IServerInformation,Platform
IServerInformation,Processors
IServerInformation,Product
IServerInformation,ProductLevel
IServerInformation,RootDirectory
IServerInformation,VersionString
IServerInformation,EngineEdition
IServerInformation,VersionMajor
IServerInformation,VersionMinor
IServerInformation,BuildClrVersionString
IServerInformation,BuildNumber
IServerInformation,CollationID
IServerInformation,ComparisonStyle
IServerInformation,ComputerNamePhysicalNetBIOS
IServerInformation,ResourceLastUpdateDateTime
IServerInformation,ResourceVersionString
IServerInformation,SqlCharSet
IServerInformation,SqlCharSetName
IServerInformation,SqlSortOrder
IServerInformation,SqlSortOrderName
IServerInformation,IsHadrEnabled
IServerInformation,IsXTPSupported
IServerSetupFacet,ServiceName
IServerSetupFacet,EngineServiceAccount
IServerSetupFacet,ServiceStartMode
IServerSetupFacet,InstanceName
IServerSetupFacet,ServiceInstanceIdSuffix
IServerSetupFacet,FilestreamLevel
IServerSetupFacet,FilestreamShareName
IServerSetupFacet,UserInstancesEnabled
IServerSetupFacet,Collation
IServerSetupFacet,SqlDomainGroup
IServerSetupFacet,WindowsUsersAndGroupsInSysadminRole
IServerSetupFacet,LoginMode
IServerSetupFacet,InstallDataDirectory
IServerSetupFacet,BackupDirectory
IServerSetupFacet,DefaultFile
IServerSetupFacet,DefaultLog
IServerSetupFacet,TempdbPrimaryFilePath
IServerSetupFacet,TempdbLogPath
IServerSetupFacet,AgentStartMode
IServerSetupFacet,AgentServiceAccount
IServerSetupFacet,AgentDomainGroup
IServerSetupFacet,NamedPipesEnabled
IServerSetupFacet,TcpEnabled
IServerSetupFacet,InstallSharedDirectory
IServerSetupFacet,BrowserStartMode
IServerSetupFacet,BrowserServiceAccount
IServerPerformanceFacet,AffinityMask
IServerPerformanceFacet,Affinity64Mask
IServerPerformanceFacet,AffinityIOMask
IServerPerformanceFacet,Affinity64IOMask
IServerPerformanceFacet,BlockedProcessThreshold
IServerPerformanceFacet,DynamicLocks
IServerPerformanceFacet,LightweightPoolingEnabled
IServerPerformanceFacet,MaxDegreeOfParallelism
IServerPerformanceFacet,CostThresholdForParallelism
IServerPerformanceFacet,MaxWorkerThreads
IServerPerformanceFacet,NetworkPacketSize
IServerPerformanceFacet,OpenObjects
IServerProtocolSettingsFacet,ExtendedProtection
IServerProtocolSettingsFacet,ForceEncryption
IServerProtocolSettingsFacet,AcceptedNTLMSPNs
ServerRole,ID
ServerRole,DateCreated
ServerRole,DateModified
ServerRole,IsFixedRole
ServerRole,Owner
ServerRole,Name
IServerSecurityFacet,PublicServerRoleIsGrantedPermissions
IServerSecurityFacet,LoginMode
IServerSecurityFacet,XPCmdShellEnabled
IServerSecurityFacet,CrossDBOwnershipChainingEnabled
IServerSecurityFacet,CommonCriteriaComplianceEnabled
IServerSecurityFacet,CmdExecRightsForSystemAdminsOnly
IServerSecurityFacet,ProxyAccountIsGrantedToPublicRole
IServerSecurityFacet,ReplaceAlertTokensEnabled
IServerSecurityFacet,ProxyAccountEnabled
IServerSelectionFacet,BuildNumber
IServerSelectionFacet,Collation
IServerSelectionFacet,Edition
IServerSelectionFacet,IsCaseSensitive
IServerSelectionFacet,Language
IServerSelectionFacet,NamedPipesEnabled
IServerSelectionFacet,OSVersion
IServerSelectionFacet,Platform
IServerSelectionFacet,TcpEnabled
IServerSelectionFacet,VersionMajor
IServerSelectionFacet,VersionMinor
IServerSettings,AuditLevel
IServerSettings,BackupDirectory
IServerSettings,DefaultFile
IServerSettings,DefaultLog
IServerSettings,LoginMode
IServerSettings,MailProfile
IServerSettings,NumberOfLogFiles
IServerSettings,PerfMonMode
IServerSettings,TapeLoadWaitTime
ServiceContract,ID
ServiceContract,IsSystemObject
ServiceContract,Owner
ServiceContract,Name
ServiceQueue,ActivationExecutionContext
ServiceQueue,CreateDate
ServiceQueue,DateLastModified
ServiceQueue,ExecutionContextPrincipal
ServiceQueue,FileGroup
ServiceQueue,ID
ServiceQueue,IsActivationEnabled
ServiceQueue,IsEnqueueEnabled
ServiceQueue,IsRetentionEnabled
ServiceQueue,IsSystemObject
ServiceQueue,MaxReaders
ServiceQueue,ProcedureDatabase
ServiceQueue,ProcedureName
ServiceQueue,ProcedureSchema
ServiceQueue,RowCount
ServiceQueue,IsPoisonMessageHandlingEnabled
ServiceQueue,Schema
ServiceQueue,Name
ServiceRoute,Address
ServiceRoute,BrokerInstance
ServiceRoute,ExpirationDate
ServiceRoute,ID
ServiceRoute,MirrorAddress
ServiceRoute,Owner
ServiceRoute,RemoteService
ServiceRoute,Name
SmartAdmin,BackupEnabled
SmartAdmin,BackupRetentionPeriodInDays
SmartAdmin,CredentialName
SmartAdmin,EncryptionAlgorithm
SmartAdmin,EncryptorName
SmartAdmin,EncryptorType
SmartAdmin,MasterSwitch
SmartAdmin,StorageUrl
ISmartAdminState,IsMasterSwitchEnabled
ISmartAdminState,IsBackupEnabled
ISmartAdminState,NumberOfStorageConnectivityErrors
ISmartAdminState,NumberOfSqlErrors
ISmartAdminState,NumberOfInvalidCredentialErrors
ISmartAdminState,NumberOfOtherErrors
ISmartAdminState,NumberOfCorruptedOrDeletedBackups
ISmartAdminState,NumberOfBackupLoops
ISmartAdminState,NumberOfRetentionLoops
Statistic,FileGroup
Statistic,ID
Statistic,IsAutoCreated
Statistic,IsFromIndexCreation
Statistic,LastUpdated
Statistic,NoAutomaticRecomputation
Statistic,FilterDefinition
Statistic,HasFilter
Statistic,IsTemporary
Statistic,Name
StoredProcedure,AnsiNullsStatus
StoredProcedure,CreateDate
StoredProcedure,ForReplication
StoredProcedure,ID
StoredProcedure,ImplementationType
StoredProcedure,IsEncrypted
StoredProcedure,IsSchemaBound
StoredProcedure,IsSystemObject
StoredProcedure,Owner
StoredProcedure,QuotedIdentifierStatus
StoredProcedure,Recompile
StoredProcedure,Startup
StoredProcedure,AssemblyName
StoredProcedure,ClassName
StoredProcedure,ExecutionContext
StoredProcedure,ExecutionContextPrincipal
StoredProcedure,IsSchemaOwned
StoredProcedure,MethodName
StoredProcedure,IsNativelyCompiled
StoredProcedure,Schema
StoredProcedure,Name
ISurfaceAreaFacet,AdHocRemoteQueriesEnabled
ISurfaceAreaFacet,DatabaseMailEnabled
ISurfaceAreaFacet,ClrIntegrationEnabled
ISurfaceAreaFacet,OleAutomationEnabled
ISurfaceAreaFacet,RemoteDacEnabled
ISurfaceAreaFacet,SqlMailEnabled
ISurfaceAreaFacet,WebAssistantEnabled
ISurfaceAreaFacet,XPCmdShellEnabled
ISurfaceAreaFacet,ServiceBrokerEndpointActive
ISurfaceAreaFacet,SoapEndpointsEnabled
ISurfaceAreaConfigurationForAnalysisServer,AdHocDataMiningQueriesEnabled
ISurfaceAreaConfigurationForAnalysisServer,AnonymousConnectionsEnabled
ISurfaceAreaConfigurationForAnalysisServer,LinkedObjectsLinksToOtherInstancesEnabled
ISurfaceAreaConfigurationForAnalysisServer,LinkedObjectsLinksFromOtherInstancesEnabled
ISurfaceAreaConfigurationForAnalysisServer,UserDefinedFunctionsEnabled
ISurfaceAreaConfigurationForAnalysisServer,ListenOnlyOnLocalConnections
ISurfaceAreaConfigurationForReportingServices,WebServiceAndHTTPAccessEnabled
ISurfaceAreaConfigurationForReportingServices,ScheduleEventsAndReportDeliveryEnabled
ISurfaceAreaConfigurationForReportingServices,ReportManagerEnabled
SymmetricKey,CreateDate
SymmetricKey,DateLastModified
SymmetricKey,EncryptionAlgorithm
SymmetricKey,ID
SymmetricKey,IsOpen
SymmetricKey,KeyGuid
SymmetricKey,KeyLength
SymmetricKey,Owner
SymmetricKey,ProviderName
SymmetricKey,Name
Synonym,BaseDatabase
Synonym,BaseObject
Synonym,BaseSchema
Synonym,BaseServer
Synonym,BaseType
Synonym,CreateDate
Synonym,DateLastModified
Synonym,ID
Synonym,IsSchemaOwned
Synonym,Owner
Synonym,Schema
Synonym,Name
Table,CreateDate
Table,DataSpaceUsed
Table,FakeSystemTable
Table,FileGroup
Table,HasClusteredIndex
Table,HasSparseColumn
Table,ID
Table,IndexSpaceUsed
Table,IsSystemObject
Table,Owner
Table,Replicated
Table,RowCount
Table,TextFileGroup
Table,AnsiNullsStatus
Table,HasAfterTrigger
Table,HasDeleteTrigger
Table,HasIndex
Table,HasInsertTrigger
Table,HasInsteadOfTrigger
Table,HasUpdateTrigger
Table,IsIndexable
Table,QuotedIdentifierStatus
Table,DateLastModified
Table,HasHeapIndex
Table,IsPartitioned
Table,IsSchemaOwned
Table,IsVarDecimalStorageFormatEnabled
Table,PartitionScheme
Table,ChangeTrackingEnabled
Table,FileStreamFileGroup
Table,FileStreamPartitionScheme
Table,HasCompressedPartitions
Table,LockEscalation
Table,TrackColumnsUpdatedEnabled
Table,FileTableDirectoryName
Table,FileTableNameColumnCollation
Table,FileTableNamespaceEnabled
Table,IsFileTable
Table,Durability
Table,HasClusteredColumnStoreIndex
Table,IsMemoryOptimized
Table,DataSourceName
Table,FileFormatName
Table,HasSystemTimePeriod
Table,HistoryTableID
Table,HistoryTableName
Table,HistoryTableSchema
Table,IsExternal
Table,IsSystemVersioned
Table,Location
Table,RejectSampleValue
Table,RejectType
Table,RejectValue
Table,RemoteDataArchiveDataMigrationState
Table,RemoteDataArchiveEnabled
Table,RemoteDataArchiveFilterPredicate
Table,RemoteTableName
Table,RemoteTableProvisioned
Table,SystemTimePeriodEndColumn
Table,SystemTimePeriodStartColumn
Table,TemporalType
Table,IsEdge
Table,IsNode
Table,Schema
Table,Name
ITableOptions,AnsiNullsStatus
ITableOptions,ChangeTrackingEnabled
ITableOptions,CreateDate
ITableOptions,FakeSystemTable
ITableOptions,ID
ITableOptions,IsSchemaOwned
ITableOptions,IsSystemObject
ITableOptions,LockEscalation
ITableOptions,Name
ITableOptions,Owner
ITableOptions,QuotedIdentifierStatus
ITableOptions,RemoteDataArchiveEnabled
ITableOptions,RemoteDataArchiveDataMigrationState
ITableOptions,RemoteTableName
ITableOptions,RemoteTableProvisioned
ITableOptions,Replicated
ITableOptions,Schema
ITableOptions,TrackColumnsUpdatedEnabled
Trigger,AnsiNullsStatus
Trigger,CreateDate
Trigger,Delete
Trigger,DeleteOrder
Trigger,ID
Trigger,ImplementationType
Trigger,Insert
Trigger,InsertOrder
Trigger,InsteadOf
Trigger,IsEnabled
Trigger,IsEncrypted
Trigger,IsSystemObject
Trigger,NotForReplication
Trigger,QuotedIdentifierStatus
Trigger,Update
Trigger,UpdateOrder
Trigger,AssemblyName
Trigger,ClassName
Trigger,DateLastModified
Trigger,ExecutionContext
Trigger,ExecutionContextPrincipal
Trigger,MethodName
Trigger,IsNativelyCompiled
Trigger,IsSchemaBound
Trigger,Name
User,CreateDate
User,DateLastModified
User,HasDBAccess
User,ID
User,IsSystemObject
User,Login
User,LoginType
User,Sid
User,UserType
User,AsymmetricKey
User,AuthenticationType
User,Certificate
User,DefaultSchema
User,Name
UserDefinedAggregate,AssemblyName
UserDefinedAggregate,ClassName
UserDefinedAggregate,CreateDate
UserDefinedAggregate,DateLastModified
UserDefinedAggregate,ID
UserDefinedAggregate,IsSchemaOwned
UserDefinedAggregate,Owner
UserDefinedAggregate,Schema
UserDefinedAggregate,Name
UserDefinedDataType,AllowIdentity
UserDefinedDataType,Default
UserDefinedDataType,DefaultSchema
UserDefinedDataType,ID
UserDefinedDataType,Length
UserDefinedDataType,MaxLength
UserDefinedDataType,Nullable
UserDefinedDataType,NumericPrecision
UserDefinedDataType,NumericScale
UserDefinedDataType,Owner
UserDefinedDataType,Rule
UserDefinedDataType,RuleSchema
UserDefinedDataType,SystemType
UserDefinedDataType,VariableLength
UserDefinedDataType,Collation
UserDefinedDataType,IsSchemaOwned
UserDefinedDataType,Schema
UserDefinedDataType,Name
UserDefinedFunction,AnsiNullsStatus
UserDefinedFunction,CreateDate
UserDefinedFunction,FunctionType
UserDefinedFunction,ID
UserDefinedFunction,ImplementationType
UserDefinedFunction,IsDeterministic
UserDefinedFunction,IsEncrypted
UserDefinedFunction,IsSchemaBound
UserDefinedFunction,IsSystemObject
UserDefinedFunction,Owner
UserDefinedFunction,QuotedIdentifierStatus
UserDefinedFunction,TableVariableName
UserDefinedFunction,AssemblyName
UserDefinedFunction,ClassName
UserDefinedFunction,ExecutionContext
UserDefinedFunction,ExecutionContextPrincipal
UserDefinedFunction,IsSchemaOwned
UserDefinedFunction,MethodName
UserDefinedFunction,ReturnsNullOnNullInput
UserDefinedFunction,IsNativelyCompiled
UserDefinedFunction,Schema
UserDefinedFunction,Name
UserDefinedType,AssemblyName
UserDefinedType,BinaryTypeIdentifier
UserDefinedType,ClassName
UserDefinedType,Collation
UserDefinedType,ID
UserDefinedType,IsBinaryOrdered
UserDefinedType,IsComVisible
UserDefinedType,IsFixedLength
UserDefinedType,IsNullable
UserDefinedType,IsSchemaOwned
UserDefinedType,MaxLength
UserDefinedType,NumericPrecision
UserDefinedType,NumericScale
UserDefinedType,Owner
UserDefinedType,UserDefinedTypeFormat
UserDefinedType,Schema
UserDefinedType,Name
IUserOptions,AsymmetricKey
IUserOptions,Certificate
IUserOptions,CreateDate
IUserOptions,DefaultSchema
IUserOptions,ID
IUserOptions,IsSystemObject
IUserOptions,Login
IUserOptions,LoginType
IUserOptions,Name
IUserOptions,Sid
IUserOptions,UserType
UserDefinedTableType,Collation
UserDefinedTableType,CreateDate
UserDefinedTableType,DateLastModified
UserDefinedTableType,ID
UserDefinedTableType,IsSchemaOwned
UserDefinedTableType,IsUserDefined
UserDefinedTableType,MaxLength
UserDefinedTableType,Nullable
UserDefinedTableType,Owner
UserDefinedTableType,IsMemoryOptimized
UserDefinedTableType,Schema
UserDefinedTableType,Name
Utility,Name
Utility,UtilityName
Utility,MdwDatabaseName
Utility,CreatedBy
Utility,Description
Utility,TotalStorageCapacity
Utility,TotalStorageUtilization
Utility,OverUtilizationTrailingWindow
Utility,OverUtilizationOccurenceFrequency
Utility,UnderUtilizationTrailingWindow
Utility,UnderUtilizationOccurenceFrequency
Utility,MdwRetentionLengthInDaysForMinutesHistory
Utility,MdwRetentionLengthInDaysForHoursHistory
Utility,MdwRetentionLengthInDaysForDaysHistory
View,AnsiNullsStatus
View,CreateDate
View,HasColumnSpecification
View,ID
View,IsEncrypted
View,IsSchemaBound
View,IsSystemObject
View,Owner
View,QuotedIdentifierStatus
View,HasAfterTrigger
View,HasDeleteTrigger
View,HasIndex
View,HasInsertTrigger
View,HasInsteadOfTrigger
View,HasUpdateTrigger
View,IsIndexable
View,DateLastModified
View,IsSchemaOwned
View,ReturnsViewMetadata
View,Schema
View,Name
IViewOptions,AnsiNullsStatus
IViewOptions,CreateDate
IViewOptions,ID
IViewOptions,IsEncrypted
IViewOptions,IsSchemaBound
IViewOptions,IsSchemaOwned
IViewOptions,IsSystemObject
IViewOptions,Name
IViewOptions,Owner
IViewOptions,Schema
IViewOptions,QuotedIdentifierStatus
IViewOptions,ReturnsViewMetadata
Volume,Name
Volume,ID
Volume,DeviceId
Volume,TotalSpace
Volume,TotalSpaceUsed
Volume,TotalSpaceUtilization
WorkloadGroup,GroupMaximumRequests
WorkloadGroup,ID
WorkloadGroup,Importance
WorkloadGroup,IsSystemObject
WorkloadGroup,MaximumDegreeOfParallelism
WorkloadGroup,RequestMaximumCpuTimeInSeconds
WorkloadGroup,RequestMaximumMemoryGrantPercentage
WorkloadGroup,RequestMemoryGrantTimeoutInSeconds
WorkloadGroup,ExternalResourcePoolName
WorkloadGroup,Name
XmlSchemaCollection,CreateDate
XmlSchemaCollection,DateLastModified
XmlSchemaCollection,ID
XmlSchemaCollection,Text
XmlSchemaCollection,Schema
XmlSchemaCollection,Name


Running out of memory? Never run out of memory with Redis Enterprise databaseStart your free trial today.

Topics:
database ,dbcc checkdb ,sql server 2016 ,sql server 2017 ,tutorial

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}