| title | Profiling ODBC Driver Performance How-to Topics (ODBC) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | reference | |
| ms.assetid | 0e6d7aed-28d2-419e-be6a-f60d3729bfd0 | |
| caps.latest.revision | 9 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
[!INCLUDESNAC_Deprecated]
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.