PowerShell Logo Small

Enable-OdbcPerfCounter



This is the built-in help made by Microsoft for the command 'Enable-OdbcPerfCounter', in PowerShell version 5 - as retrieved from Windows version 'Microsoft Windows Server 2012 R2 Standard' PowerShell help files on 2016-06-23.

For PowerShell version 3 and up, where you have Update-Help, this command was run just before creating the web pages from the help files.

SYNOPSIS

Enables connection pooling Performance Monitor counters.

SYNTAX


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



Search powershellhelp.space

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



<

RELATED LINKS

Online Version: http://go.microsoft.com/fwlink/p/?linkid=287603
Disable-OdbcPerfCounter
Get-OdbcPerfCounter
N:Wdac



REMARKS

<

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



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.