Enable-Odbc Perf Counter

Enables connection pooling Performance Monitor counters.

Syntax

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

Description

The Enable-OdbcPerfCounter cmdlet enables the Open Database Connectivity (ODBC) connection pooling Performance Monitor counters for troubleshooting 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: Enable Performance Counter on a 32-bit platform

PS C:\> Enable-OdbcPerfCounter -Platform "32-bit"

This command enables the ODBC Performance Counter setting on a 32-bit platform.

Example 2: Enable Performance Counter on both platforms

PS C:\> Enable-OdbcPerfCounter -Platform "All"

This command enables 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 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.

Required Parameters

-InputObject

Specifies the input object that is used in a pipeline command.

Type: CimInstance[]
Aliases: PerfCounter
Position: 0
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False

Optional Parameters

-AsJob

Runs the cmdlet as a background job. Use this parameter to run commands that take a long time to complete.

Type: SwitchParameter
Position: Named
Default value: None
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-CimSession or Get-CimSession cmdlet. The default is the current session on the local computer.

Type: CimSession[]
Aliases: Session
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Confirm

Prompts you for confirmation before running the cmdlet.

Type: SwitchParameter
Aliases: cf
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
-PassThru

Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.

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

Specifies the platform architecture. This cmdlet enables 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

The default value is 32-bit on a 32-bit process. The default value is 64-bit on a 64-bit process. If you run this cmdlet in a remote CIM session, this parameter refers to the platform architecture on the remote computer.

Type: String
Parameter Sets: 32-bit, 64-bit, All
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName)
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
Accept pipeline input: False
Accept wildcard characters: False
-WhatIf

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

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

Outputs

Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcPerfCounter[]