Export (0) Print
Expand All

Disable-OdbcPerfCounter

Updated: June 5, 2014

Applies To: Windows 8.1, Windows PowerShell 4.0, Windows Server 2012 R2

Disable-OdbcPerfCounter

Disables connection pooling Performance Monitor counters.

Syntax

Parameter Set: InputObject
Disable-OdbcPerfCounter [-InputObject] <CimInstance[]> [-AsJob] [-CimSession <CimSession[]> ] [-PassThru] [-ThrottleLimit <Int32> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameter Set: Platform
Disable-OdbcPerfCounter [[-Platform] <String> ] [-AsJob] [-CimSession <CimSession[]> ] [-PassThru] [-ThrottleLimit <Int32> ] [-Confirm] [-WhatIf] [ <CommonParameters>]




Detailed 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) (http://msdn.microsoft.com/en-us/library/ms710252.aspx) and ODBC Performance Counters (http://msdn.microsoft.com/en-us/library/windows/desktop/ms709288.aspx) on the Microsoft Developer Network.

Parameters

-InputObject<CimInstance[]>

Specifies an array of input objects. This cmdlet disables the ODBC connection pooling Performance Monitor counters that the specified objects represent. Specify a variable that contains the objects, or type a command or expression that gets the objects.


Aliases

PerfCounter

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

True (ByValue)

Accept Wildcard Characters?

false

-Platform<String>

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.


Aliases

none

Required?

false

Position?

1

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

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.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-AsJob

Runs the cmdlet as a background job. Use this parameter to run commands that take a long time to complete. The cmdlet immediately returns an object that represents the job and then displays the command prompt. You can continue to work in the session while the job completes. To manage the job, use the *-Job cmdlets. To get the job results, use the Receive-Job cmdlet. For more information about Windows PowerShell® background jobs, see about_Jobs.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-CimSession<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.


Aliases

Session

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ThrottleLimit<Int32>

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.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Confirm

Prompts you for confirmation before running the cmdlet.


Required?

false

Position?

named

Default Value

false

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WhatIf

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


Required?

false

Position?

named

Default Value

false

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see    about_CommonParameters.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

  • Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcPerfCounter[]

Examples

Example 1: Disable Performance Counter on a 32-bit platform

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


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

Example 2: Disable Performance Counter both platforms

This command disables the ODBC Performance Counter setting on both 32-bit and 64-bit platforms


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

Example 3: Enable and disable Performance Counter on a 32-bit platform

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


PS C:\> $perfCounter = Enable-OdbcPerfCounter -Platform "32-bit" -PassThru
PS C:\> Disable-OdbcPerfCounter -InputObject $perfCounter 

Related topics

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft