none
How to use typeperf with with 'ODBC driver 13 for SQL Server'.

    Question

  • Operating System: Windows Server 12 Standard Edition.
    SQL Server: 2016 standard edition.

    Folks, I was able to collect the counter value using typeperf using "SQL Server Driver".
    Lets assume we dont have option to use the "SQL Server Driver" and we want to go with "ODBC driver 13 for SQL Server.
    I am able to create the DSN using "ODBC driver 13 for SQL Server".

    "Microsoft ODBC Driver for SQL Server Version 13.00.4001

    Running connectivity tests...

    Attempting connection
    Connection established
    Verifying option settings
    Disconnecting from server

    TESTS COMPLETED SUCCESSFULLY!"

    However, when I use the ODBC 13 driver with typepef, it gives me the following error.

    C:\Windows\system32>Typeperf -S XXXX -f SQL -o SQL:DSN_ODBC13!Log1  -si 15 -sc 500000 -cf "D:\DBA\PERFMON\Counters.txt"


    Error:
    Call to SQLExecDirect failed with ???.

    Has somebody ever been able to use the typeperf with "ODBC driver 13 for SQL Server" with sucess.
    Please share the steps involved in using it.


    • Edited by Regular_User_1 Tuesday, June 12, 2018 11:38 AM subject has double qutoes which looks not correct .Corrected that.
    Tuesday, June 12, 2018 11:36 AM

All replies

  • Has somebody ever been able to use the typeperf with "ODBC driver 13 for SQL Server" with success.

    It's been some time since I last used typeperf but I do recall I could not get it to work with any of the newer SQL Server ODBC drivers. It only worked with the legacy "SQL Server" ODBC driver provided with Windows.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Tuesday, June 12, 2018 11:43 AM
    Moderator