Hi All,
I want see the traffic of one database in sql server. I would like to know how many hits are coming to a specific database in one day to verify the database load. Is this possible??
Regards
Babu
--FOR ALL DATABASES SELECT * FROM master..sysperfinfo WHERE counter_name LIKE '%Transactions/sec%' --FOR ONE DATABASE SELECT * FROM master..sysperfinfo WHERE counter_name LIKE '%Transactions/sec%' AND instance_name LIKE '%<Database Name>%'
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.