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
2 comments
-
Michael Søndergaard
commented
As DW comments on in the other feedback item, the database name should also be part of the output. This is particular helpful, when you are doing cross database sql code
-
DW
commented
Note that there is also a topic "Please include schema / database prefix in STATISTICS IO output" at:
https://feedback.azure.com/forums/908035-sql-server/suggestions/32899231
Votes for that item should be considered votes for this as well, as fulfilling that request would also fulfill this.