Edit

Disable-OdbcPerfCounter

  • Reference
Module:
Wdac

Disables the ODBC connection pooling Performance Monitor counters for ODBC connection pooling feature.

Syntax

Disable-OdbcPerfCounter
       [-InputObject] <CimInstance>
       [-AsJob]
       [-CimSession <CimSession>]
       [-PassThru]
       [-ThrottleLimit <Int32>]
       [-Confirm]
       [-WhatIf]
Disable-OdbcPerfCounter
       [[-Platform] <String>]
       [-AsJob]
       [-CimSession <CimSession>]
       [-PassThru]
       [-ThrottleLimit <Int32>]
       [-Confirm]
       [-WhatIf]

Description

For more information about ODBC and performance counters, see Microsoft Open Database Connectivity (ODBC)http://msdn.microsoft.com/en-us/library/ms710252.aspx and ODBC Performance Countershttp://msdn.microsoft.com/en-us/library/windows/desktop/ms709288.aspx.

Examples

1:

PS C:\> Disable-OdbcPerfCounter -Platform 32-bit

Disable the ODBC Performance Counter setting on 32-bit platform:

2:

PS C:\> Disable-OdbcPerfCounter -Platform All

Disable the ODBC Performance Counter setting on both 32-bit and 64-bit platform:

3:

PS C:\> $perfCounter = Enable-OdbcPerfCounter -Platform 32-bit -PassThru
<Execute some ODBC applications that are using ODBC pooling>
Disable-OdbcPerfCounter $perfCounter

This command first enables the ODBC Performance Counter setting on 32-bit platform. It also saves the result into a PowerShell variable that can be reused in Disable-OdbcPerfCounter:

Parameters

-AsJob

ps_cimcommon_asjob

Type:SwitchParameter
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters: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-CimSessionhttp://go.microsoft.com/fwlink/p/?LinkId=227967 or Get-CimSessionhttp://go.microsoft.com/fwlink/p/?LinkId=227966 cmdlet. The default is the current session on the local computer.

Type:CimSession
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Position:Named
Default value:False
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-InputObject

Disables the ODBC Connection Pooling PerfMon counters represented by the specified ODBC PerfMon counters objects. Enter a variable that contains the objects, or type a command or expression that gets the objects.

Type:CimInstance
Position:1
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-PassThru

Passes the object created by this cmdlet through the pipeline. By default, this cmdlet does not pass any objects through the pipeline.

Type:SwitchParameter
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Platform

The platform architecture of the ODBC Connection Pooling PerfMon counters to disable. Possible values are '32-bit', '64-bit' or 'All'. The default is '32-bit' on a 32-bit process and '64-bit' on a 64-bit process. This is the platform architecture on the remote machine if this command is executed on a remote CIM session.

Type:String
Position:1
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters: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.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Position:Named
Default value:False
Required:False
Accept pipeline input:False
Accept wildcard characters:False

Outputs

CimInstance[]