ruby - Microsoft SQL Server Statistics via ODBC -
I have an example of a SQL Server that I am trying to benchmark. From the SQL Studio application I can type
SET statistic on time and see the subsequent output figures from the I ++ code, I can do something like
SQLExec Direct (hstmt, "SET Statistic Time On Time", SQL_NTS); And then get these data through SQLError .
Is there a way to get these data when accessing SQL Server on vanilla ODBC? In this case I am using Ruby's DBI: ODBC connector which works fine to connect and run the query, but I could not understand this meta stuff.
OK, this is not going through Odyssey, but if you have SQL Server Tools , So will the SQL Profiler work for you? You can use that time for execution of statements, transactions, sprocs and numerous other things in SQL Server.
Comments
Post a Comment