Disable-OdbcPerfCounter
Disables connection pooling Performance Monitor counters.
Syntax
InputObject (Default)
Disable-OdbcPerfCounter
[-InputObject] <CimInstance[]>
[-PassThru]
[-CimSession <CimSession[]>]
[-ThrottleLimit <Int32>]
[-AsJob]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Platform
Disable-OdbcPerfCounter
[[-Platform] <String>]
[-PassThru]
[-CimSession <CimSession[]>]
[-ThrottleLimit <Int32>]
[-AsJob]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
The Disable-OdbcPerfCounter cmdlet disables the Open Database Connectivity (ODBC) connection pooling Performance Monitor counters for ODBC connection pooling.
For more information about ODBC and performance counters, see Microsoft Open Database Connectivity (ODBC) and ODBC Performance Counters on the Microsoft Developer Network.
Examples
Example 1: Disable Performance Counter on a 32-bit platform
PS C:\> Disable-OdbcPerfCounter -Platform "32-bit"
This command disables the ODBC Performance Counter setting on a 32-bit platform.
Example 2: Disable Performance Counter both platforms
PS C:\> Disable-OdbcPerfCounter -Platform "All"
This command disables the ODBC Performance Counter setting on both 32-bit and 64-bit platforms.
Example 3: Enable and disable Performance Counter on a 32-bit platform
PS C:\> $PerfCounter = Enable-OdbcPerfCounter -Platform "32-bit" -PassThru
PS C:\> Disable-OdbcPerfCounter -InputObject $PerfCounter
The first command enables the ODBC Performance Counter setting on 32-bit platform, and then stores the result in the $PerfCounter variable. After you run the first command, you can run ODBC applications that use pooling.
The second command disables the ODBC Performance Counter setting specified by $PerfCounter.
Parameters
-AsJob
Runs the cmdlet as a background job. Use this parameter to run commands that take a long time to complete.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-CimSession
Runs the cmdlet in a remote session or on a remote computer. Enter a computer name or a session object, such as the output of a New-CimSession or Get-CimSession cmdlet. The default is the current session on the local computer.
Parameter properties
| Type: | CimSession[] |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | Session |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-Confirm
Prompts you for confirmation before running the cmdlet.
Parameter properties
| Type: | SwitchParameter |
| Default value: | False |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | cf |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-InputObject
Specifies the input object that is used in a pipeline command.
Parameter properties
| Type: | CimInstance[] |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | PerfCounter |
Parameter sets
InputObject
| Position: | 0 |
| Mandatory: | True |
| Value from pipeline: | True |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-PassThru
Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-Platform
Specifies the platform architecture. This cmdlet disables the ODBC connection pooling Performance Monitor counters that belong to the architecture that the parameter specifies. The acceptable values for this parameter are:
- 32-bit
- 64-bit
- All
If you run this cmdlet in a remote CIM session, this parameter refers to the platform architecture on the remote computer.
Parameter properties
| Type: | String |
| Default value: | None |
| Accepted values: | 32-bit, 64-bit, All |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
Platform
| Position: | 0 |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-ThrottleLimit
Specifies the maximum number of concurrent operations that can be established to run the cmdlet.
If this parameter is omitted or a value of 0 is entered, then Windows PowerShell® calculates an optimum throttle limit for the cmdlet based on the number of CIM cmdlets that are running on the computer.
The throttle limit applies only to the current cmdlet, not to the session or to the computer.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Parameter properties
| Type: | SwitchParameter |
| Default value: | False |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | wi |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.