Skip to content

Instantly share code, notes, and snippets.

@jaganadhg

jaganadhg/TDstat.sql

Last active June 2, 2023 19:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jaganadhg/f3412f105059b6b2ce6fdea3c8eb5961 to your computer and use it in GitHub Desktop.
Save jaganadhg/f3412f105059b6b2ce6fdea3c8eb5961 to your computer and use it in GitHub Desktop.
Download ZIP
TDstat.sql
Raw
TDstat.sql
SELECT DatabaseName, TableName, SUM(ReadCount) AS TotalReadCount
FROM IDW_STATS_V.IDW_TABLE_USAGE_DETAILS
GROUP BY DatabaseName, TableName
ORDER BY TotalReadCount DESC;
HELP COLUMN IDW_STATS_V.IDW_TABLE_USAGE_DETAILS.*;
SELECT DatabaseName, TableName, SUM(AccessCount) AS TotalAccessCount
FROM IDW_STATS_V.IDW_TABLE_USAGE_DETAILS
GROUP BY DatabaseName, TableName
ORDER BY TotalAccessCount DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment