Page History
...
Cmdlet Name | Description | Examples |
---|---|---|
-FriendlyServerName | Sets friendly name to an instance. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -FriendlyServerName stringName |
-FriendlyServerNameBlank | Clears the friendly name previously assigned to an instance. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -FriendlyServerNameBlank |
-InputBufferLimiter | Defines an Input Buffer Limiter value. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -InputBufferLimiter 100 |
-InputBufferLimiterEnable | Enables the Input Buffer Limiter. | SetSQLdmMonitoredInstance Path (EscapeSQLdmName Set-SQLdmMonitoredInstancePath (Escape-SQLdmName -Name ServeA\Instance1) -InputBufferLimiterEnable |
-InputBufferLimiterDisable | Disables the Input Buffer Limiter. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -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. |
|
...
Cmdlet Name | Description | Examples |
---|---|---|
-QMEnableTraceMonitoring | Enables "Collect Query Data using SQL Trace". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -QMEnableTraceMonitoring |
-QMEnableExtendedEvents | Enables "Collect Query Data using Extended Events". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -QMEnableExtendedEvents |
-QMEnableCollectQueryPlan | Enables "Collect actual Query Plans". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -QMEnableCollectQueryPlan |
-QMDisableCollectQueryPlan | Disables "Collect actual Query Plans". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -QMDisableCollectQueryPlan |
-QMEnableCollectEstimatedQueryPlan | Enables “Collect Estimated Query Plans”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -QMEnableCollectEstimatedQueryPlan |
-QMDisableCollectEstimatedQueryPlan | Disables “Collect Estimated Query Plans”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name ServeA\Instance1) -QMDisableCollectEstimatedQueryPlan |
| Enables query monitoring. | Set-SQLdmMonitoredInstance -Path (Escape-SQLdmName -Name |
| Disables query monitoring. |
|
| Captures SQL batches. |
|
| Captures SQL statements. |
|
| Captures stored procedure and triggers. |
|
| Sets up threshold Duration (in milliseconds). |
|
| Sets up threshold Logical disk reads. |
|
| Sets up threshold CPU Usage (in milliseconds). |
|
| Sets up threshold Physical disk writes. |
|
...
Cmdlet Name | Description | Examples |
---|---|---|
-QWExtendedEnable | Enables "Use Extended Events (SQL Server 2012 +)". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name INSTANCE_NAME) -QWExtendedEnable |
-QWExtendedDisable | Disables "Use Extended Events (SQL Server 2012 +)". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name INSTANCE_NAME) -QWExtendedDisable |
-QWStatisticsDisable | Disables "Collect query wait statistics (SQL 2005+ only)". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name INSTANCE_NAME) -QWStatisticsDisable |
-QWStatisticsDuration | Enables "Collect query wait statistics at a specified time and duration". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name INSTANCE_NAME) -QWStatisticsStartDate"yyyy-mm-dd-hh:mm" -QWStatisticsDuration mm:ss |
-QWStatisticsCollectIndefinite | Enables "Collect query wait statistics with Collect indefinitely option". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name INSTANCE_NAME) -QWStatisticsCollectIndefinite |
AnchorEdit activity monitor settings Edit activity monitor settings
Edit activity monitor settings
Edit activity monitor settings | |
Edit activity monitor settings |
...
Cmdlet Name | Description | Examples |
---|---|---|
-NQAEnableSQLTrace | Enables “Use SQL trace”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableSQLTrace |
-NQAEnableExtendedEvent | Enables “Use extended event (SQL 2012+)”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableExtendedEvent |
-NQADisableAutoGrow | Disables “Capture Autogrow”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQADisableAutoGrow |
-NQAEnableAutoGrow | Enables “Capture Autogrow”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableAutoGrow |
-NQAEnableCaptureBlocking | Enables “Capture Blocking”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQAEnableCaptureBlocking |
-NQADisableCaptureBlocking | Disable “Capture Blocking”. | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQADisableCaptureBlocking |
-NQACaptureBlocking | Sets “blocking process threshold". | SetSQLdmMonitoredInstance Set-SQLdmMonitoredInstance-Path ( EscapeSQLdmName Escape-SQLdmName -Name SRISHTIPUROHIT\SQLEXPRESS) -NQACaptureBlocking 100 |
Anchor | ||||
---|---|---|---|---|
|
...
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 20 -QMCpuUsage 100 -QMPhysicalDiskWrites 10 -QMExcludedApps MyExcludedApp -QMExcludedDatabases DB1,DB2,DB3 |