How to find most used tables in SQL Server?
How to find out which tables are most accessed or frequently ...
SQL Server query for the most used Tables and Index
Tables most and least used in SQL Server
query to get index details in sql server
how to find most used tables in sql server
sql query to list all tables in a database sql server
how to check index on table in sql
how to get most used tables in sql server
sql server list all tables in all databases
how to check table usage in sql server
how to check index column on table in sql server
Script:
SELECT
DB_name(dm.database_id) AS DatabaseName,
St.NAME AS TableName,
SUM(dm.user_seeks) AS user_seeks,
sum (dm.user_scans) AS user_scans,
SUM(dm.user_lookups) AS user_lookups,
SUM(DM.user_updates) AS user_updates
FROM sys.dm_db_index_usage_stats dm
INNER JOIN sys.tables st ON St.OBJECT_ID = dm.object_id
GROUP BY database_id, St.name
FOR PAID SQL TRAINING AND SUPPORT Pleases contact - [email protected]
