title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|
Profiling ODBC Driver Performance |
Profiling ODBC Driver Performance (ODBC) |
markingmyname |
maghan |
03/14/2017 |
sql |
native-client |
reference |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
The [!INCLUDEssNoVersion] ODBC driver has two driver-specific options for profiling the performance of the driver.
The [!INCLUDEssNoVersion] ODBC driver can log performance statistics in file. The log file is a tab-delimited file that can be analyzed in any spreadsheet supporting tab-delimited files, such as Microsoft Excel.
The driver can also log long-running queries (queries that do not get a response from the server in a specified length of time). These queries can later be analyzed by programmers and database administrators.