Statistics Time and Statistics IO

57 views
Skip to first unread message

woj123

unread,
Oct 30, 2016, 9:22:43 AM10/30/16
to SQLTest
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

unread,
Nov 21, 2016, 7:49:55 AM11/21/16
to SQLTest
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

unread,
Dec 20, 2019, 6:01:17 AM12/20/19
to SQLTest
Getting Exception in Update Statistics
Capture.JPG

Jai Khurana

unread,
Dec 25, 2019, 3:29:26 AM12/25/19
to SQLTest
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
Reply all
Reply to author
Forward
0 new messages