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

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -