Please include schema / database prefix in STATISTICS IO output
STATISTICS IO output only specifies table name - if you have identical tables from different schemas or in different databases, it is impossible to determine which is which. Can we please add both prefixes?
Here is an example. Set up this set of tables:
CREATE SCHEMA flack;
SELECT * INTO flack.t1 FROM sys.all_objects;
SELECT o.* INTO msdb.dbo.t1 FROM sys.all_columns AS c
CROSS JOIN (SELECT TOP (100) * FROM sys.all_objects) AS o;
Now run this query:
SET NOCOUNT ON;
SET STATISTICS IO ON;
SELECT * FROM tempdb.flack.t1
SELECT TOP (10000) * FROM msdb.dbo.t1;
SET STATISTICS IO OFF;
The output is:
Table 't1'. Scan count 1, logical reads 219, physical reads 145, read-ahead reads 431, ...
Table 't1'. Scan count 1, logical reads 38, physical reads 0, read-ahead reads 38, ...
This is adds database name to "SET STATISTICS IO should also show schema name for tables" at:
Votes for that item might be considered votes for this as well. (Any way to merge these?)