Thursday, July 2, 2009

Display of Client Statistics - to find the execution time for select statements.

This could be used as an option to find the execution time for select statements:
When you execute a script or query in the Transact-SQL editor, you can choose to collect client statistics for each execution of the script or query. You use the client statistics to gather information about execution times, the amount of data sent between client and server, and so on
To turn on or off the gathering of client statistics
Open a Transact-SQL editor session.
On the Data menu, point to T-SQL Editor, and click Include Client Statistics.
The menu item is a toggle. The first click turns on the gathering of client statistics, and the second click turns it back off. You can also toggle client statistics by clicking Include Client Statistics on the T-SQL Editor toolbar or by right-clicking in the T-SQL editor and then clicking Include Client Statistics.
Execute a query in the T-SQL editor.

If you turned on client statistics, the Client Statistics tab appears in the Results pane. If you turned off client statistics, the Client Statistics tab does not appear.


You could find details on this from : http://msdn.microsoft.com/en-us/library/aa833228.aspx

No comments: