Statistics Time and Statistics IO

[woj123]

I can't figure out what checkbox I need to set to get the tabs "Statistics Time" and "Statistics IO" to fill after I've executed a workload.  All the other tabs such as "Provider Statistics", "Executions Completed", "Execution Time", etc. are filled.  Can you help?

[Ramesh Meyyappan]

Hello Bill Johnson

As documented in http://www.sqltest.org/Help/StatisticsTime and http://www.sqltest.org/Help/StatisticsIO, you need to execute “set statistics time on" and “set statistics io on" as part of your workload.

Best Regards

[Jai Khurana]

Getting Exception in Update Statistics

[Jai Khurana]

I am executing like this :-

Set Statistics IO,Time ON;

go

Declare @PlayerID int

Exec usp_Players_ins 'A',@PlayerID OUTPUT

with 10 iterations i am facing exeption