< Back

Disable-OdbcPerfCounter

Wed Jan 30, 2019 6:05 pm

NAME Disable-OdbcPerfCounter



SYNOPSIS

Disables connection pooling Performance Monitor counters.





SYNTAX

Disable-OdbcPerfCounter [-CimSession <CimSession[]>] [-PassThru] [-ThrottleLimit <Int32>] [-Confirm] [-WhatIf] [<CommonParameters>]



Disable-OdbcPerfCounter [[-Platform] {32-bit | 64-bit | All}] [-CimSession <CimSession[]>] [-PassThru] [-ThrottleLimit <Int32>] [-Confirm] [-WhatIf]

[<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)

(http://msdn.microsoft.com/en-us/library/ms710252.aspx) and ODBC Performance Counters

(http://msdn.microsoft.com/en-us/library ... 09288.aspx) on the Microsoft Developer Network.





PARAMETERS

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



Required? false

Position? 1

Default value none

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-PassThru [<SwitchParameter>]

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



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.



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.



Required? false

Position? named

Default value none

Accept pipeline input? false

Accept wildcard characters? false



-Confirm [<SwitchParameter>]

Prompts you for confirmation before running the cmdlet.Prompts you for confirmation before running the cmdlet.



Required? false

Position? named

Default value false

Accept pipeline input? false

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]

Shows what would happen if the cmdlet runs. The cmdlet is not run.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, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS









OUTPUTS

Microsoft.Management.Infrastructure.CimInstance#MSFT_OdbcPerfCounter[]







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.







RELATED LINKS

Enable-OdbcPerfCounter

Get-OdbcPerfCounter