| title | Profiling ODBC Driver Performance |
|---|---|
| ms.custom | |
| ms.date | 03/14/2017 |
| ms.prod | sql |
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw |
| ms.reviewer | |
| ms.technology | native-client |
| ms.topic | reference |
| ms.assetid | 0e6d7aed-28d2-419e-be6a-f60d3729bfd0 |
| author | markingmyname |
| ms.author | maghan |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
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.