January 14, 2015 at 9:12 am
Hi,
SQL Server 2008R2.
Are the "Trial #" columns in this tab database independent, i.e. are they instance statistics?
I'm running the same query against two databases, the first is a UAT and the other is production. The first
column ("Trial 1") seems to be from the first execution, and "Trial 2" the second execution.
Some tables in the UAT have been tuned so I would expect the "Trial 1" column to be better
(accepting that there are less rows in UAT)
What do people make of these results? The time Statistics look better against the
tuned database which is what I expected but the packets etc are not so different.
Anyone know why the top row (Client Execution Time) has remained the same?
January 14, 2015 at 10:13 am
Those are based on the queries run from the query window. You can change connections and it will still maintain the count of executions from that query window.
It's not the best way to get good measures though. Statistics I/O and Statistics Time are better. But, I think they also suffer from observer impact. To get the best stats for execution times, I use extended events (or on old systems, trace events).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply