SET STATISTICS IO should also show schema name for tables
When you use schemas in your database, and you have the same table names in multiple schemas, it is not clear, which schema the table belongs too in the output of the SET STATISTICS IO. E.g. a table called Profile, or configuration in different schema is very common at our databases
Today the output is just
Table 'Profile'. Scan count 1, logical reads 123, physical reads 1, read-ahead reads 121, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Profile'. Scan count 3, logical reads 13, physical reads 1, read-ahead reads 342, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Profile'. Scan count 10, logical reads 53, physical reads 1, read-ahead reads 1241, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Making it just much more difficult to figure out the underlying issues
Please include the schema name of the table in the output
Michael Søndergaard
shared this idea