Page History
...
- Edit general settings
- Edit query monitor settings
- Edit query waits settings
- Edit activity monitor settings
- Add alternate Windows users
- Exclude applications, databases, and SQL statements within PowerShell
- Disable replication collection settings
...
Cmdlet Name | Description | Examples |
---|---|---|
-FriendlyServerName | Sets friendly name to an instance. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name ServeA\Instance1) -FriendlyServerName stringName |
-FriendlyServerNameBlank | Clears the friendly name previously assigned to an instance. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name ServeA\Instance1) -FriendlyServerNameBlank |
-InputBufferLimiter | Defines an Input Buffer Limiter value. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name ServeA\Instance1) -InputBufferLimiter 100 |
-InputBufferLimiterEnable | Enables the Input Buffer Limiter. | SetSQLdmMonitoredInstance Path (EscapeSQLdmName -Name ServeA\Instance1) -InputBufferLimiterEnable |
-InputBufferLimiterDisable | Disables the Input Buffer Limiter. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name ServeA\Instance1) -InputBufferLimiterDisable |
-addtag | Associates tags to a server. Note that any tags that are specified have to already exist. |
|
| Disassociates tags from a server. Note that any tags that are specified have to already exist. |
|
| Specifies how often (in minutes) scheduled data collection takes place. |
|
-DatabaseStatisticsIntervalMinutes | Specifies how often (in minutes) database statistics collection takes place. | Set-SQLdmMonitoredInstance -Path (Escape-SQLdmName -Name |
| Enables or disables extended data collection. |
|
| Sets SQL Authentication credentials. |
|
| Enables or disables encrypt connection. |
|
| Enables or disables trust server certificates. |
|
AnchorEdit query monitor settings Edit query monitor settings
Edit query monitor settings
Edit query monitor settings | |
Edit query monitor settings |
...
Cmdlet Name | Description | Examples |
---|---|---|
-NQAEnableSQLTrace | Enables “Use SQL trace”. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableSQLTrace |
-NQAEnableExtendedEvent | Enables “Use extended event (SQL 2012+)”. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableExtendedEvent |
-NQADisableAutoGrow | Disables “Capture Autogrow”. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQADisableAutoGrow |
-NQAEnableAutoGrow | Enables “Capture Autogrow”. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableAutoGrow |
-NQAEnableCaptureBlocking | Enables “Capture Blocking”. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableCaptureBlocking |
-NQADisableCaptureBlocking | Disable “Capture Blocking”. | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQADisableCaptureBlocking |
-NQACaptureBlocking | Sets “blocking process threshold". | SetSQLdmMonitoredInstance -Path (EscapeSQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQACaptureBlocking 100 |
Anchor | ||||
---|---|---|---|---|
|
Add alternate Windows users with the following cmdlet in different environments.
Cmdlet Name | Description | Examples |
---|---|---|
| Add alternate Windows users. |
|
Anchor Excludeapp Excludeapp
Exclude applications, databases, and SQL statements within PowerShell
Excludeapp | |
Excludeapp |
Exclude applications, databases, and SQL statements with the following PowerShell commands:
...
Cmdlet Name | Description | Example |
---|---|---|
| Disables replication statistics collection. |
|
AnchorCustomizetable Customizetable
Customize table statistics collection
Customizetable | |
Customizetable |
...