SET STATISTICS IO ON is an option that shows, at the page level, the physical and logical IO that goes on for each statement in a batch. Its not the most detailed inspection of a the query performance but it gives a nice insight into whats going in when the query is executing. I’m going [...]
Tag Archives: statistics
Simple performance timing
Thursday, February 7, 2008
There are a myriad of statistics SET options in sql 2005 but it looks like the first one I looked at is the simplest and the possibly the oldest: STATISTICS TIME.
It does little more than show the cpu and total time required to both parse and compile the batch and to execute it. When performance [...]