Partager via

SqlAssessmentExtensions Class

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Assessment
Assembly:
Microsoft.SqlServer.Management.Assessment.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Provides a set of static (Shared in Visual Basic) methods for checking SMO objects for best practice compliance.

public static class SqlAssessmentExtensions
type SqlAssessmentExtensions = class
Public Module SqlAssessmentExtensions
Inheritance
Object
SqlAssessmentExtensions

Fields

Engine

An assessment engine used by all extension methods. Use Configuration property of this object to customize configuration.

Methods

GetAssessmentItems(AvailabilityGroup, String[])

Finds all available checks for given availabilityGroup.
GetAssessmentItems(Database, String[])

Finds all available checks for given database.
GetAssessmentItems(FileGroup, String[])

Finds all available checks for given fileGroup.
GetAssessmentItems(Server, String[])

Finds all available checks for given server.
GetAssessmentItems(SqlSmoObject, String[])

Finds all available checks for given smoObject.
GetAssessmentResults(AvailabilityGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given availabilityGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(AvailabilityGroup, String[])

Synchronously runs assessment for given availabilityGroup and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(Database, IEnumerable<ICheck>)

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(Database, String[])

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(FileGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given fileGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(FileGroup, String[])

Synchronously runs assessment for given fileGroup and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(Server, IEnumerable<ICheck>)

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(Server, String[])

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(SqlSmoObject, IEnumerable<ICheck>)

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(SqlSmoObject, String[])

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResultsList(AvailabilityGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given availabilityGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResultsList(AvailabilityGroup, String[])

Asynchronously runs assessment for given availabilityGroup and gives a List<T> describing discovered issues.
GetAssessmentResultsList(Database, IEnumerable<ICheck>)

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResultsList(Database, String[])

Asynchronously runs assessment for given database and gives a List<T> describing discovered issues.
GetAssessmentResultsList(FileGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given fileGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResultsList(FileGroup, String[])

Asynchronously runs assessment for given fileGroup and gives a List<T> describing discovered issues.
GetAssessmentResultsList(Server, IEnumerable<ICheck>)

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResultsList(Server, String[])

Asynchronously runs assessment for given server and gives a List<T> describing discovered issues.
GetAssessmentResultsList(SqlSmoObject, IEnumerable<ICheck>)

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResultsList(SqlSmoObject, String[])

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues.

Applies to