< Back

Get-OdbcPerfCounter

Wed Jan 30, 2019 6:06 pm

NAME Get-OdbcPerfCounter



SYNOPSIS

Gets connection pooling Performance Monitor counters.





SYNTAX

Get-OdbcPerfCounter [[-Platform] {32-bit | 64-bit | All}] [-CimSession <CimSession[]>] [-ThrottleLimit <Int32>] [<CommonParameters>]





DESCRIPTION

The Get-OdbcPerfCounter cmdlet gets the Open Database Connectivity (ODBC) connection pooling performance monitor counters.



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 gets the ODBC connection pooling Performance Monitor counters that belong to the architecture that

this parameter specifies. The acceptable values for this parameter are:



-- 32-bit

-- 64-bit

-- All



The default value is 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



-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



<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: Get ODBC Performance Counter setting on a 32-bit platform



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



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





Example 2: Get ODBC Performance Counter setting on both platforms



PS C:\\> Get-OdbcPerfCounter



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





Example 3: Store ODBC Performance Counter setting for a 32-bit platform



PS C:\\> $PerfCounter = Get-OdbcPerfCounter -Platform "32-bit"



This command gets the ODBC Performance Counter setting on a 32-bit platform, and then stores the result in the $PerfCounter variable.







RELATED LINKS

Online Version:

Disable-OdbcPerfCounter

Enable-OdbcPerfCounter