Page History
...
| Note |
|---|
To use SQL Diagnostic Manager snap-in, you have to enable the provider and register the SQLdm SQLDM drive. |
| Anchor | ||||
|---|---|---|---|---|
|
...
| Cmdlet Name | Description | Examples |
|---|---|---|
| Sets maintenance mode to Never. Note that SQL Diagnostic Manager will collect data according to its normal scheduled collection interval. |
|
| Sets maintenance mode to Until further notice. Schedule collection will not occur. |
|
| Sets maintenance mode to Recurring every week at the specified time. |
|
-MModeDays | Specifies the days of the week recurring maintenance mode will be effective. | |
-MModeStartTime | Specifies the start time for recurring maintenance mode. | |
-MModeDuration | Specifies the length of time for recurring maintenance mode. | |
| Sets maintenance mode to Occurring once at the specified time. |
|
-MModeStartDate | Specifies the start date and time for one-time maintenance mode. | |
-MModeEndDate | Specifies the end date and time for one-time maintenance mode. |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
PowerShell allows you to set up several properties in one command-line. On the PowerShell window, use Set-SQLdmMonitoredInstance followed by the corresponding cmdlets of the properties you want to edit. For example, consider the properties listed below:
You can customize these settings with the following PowerShell command-line: Set-SQLdmMonitoredInstance -Path (Escape-SQLdmName -Name QA- Name Server\Instance) -QMEnabled -QMCaptureBatches 1 –QMCaptureProc 0 -QMQueryDuration 200 |
...