Hi,

I meant that number of transactions in a database,

I got the answer by some R & D:

select * FROM sys.dm_os_performance_counters

where Ltrim(rtrim(object_name)) = 'SQLServer:Databases'

and instance_name = 'DBNAME' -- Give the Database Name

and counter_name = 'Transactions/sec'

It will give me the number hits per second for a database named 'DBNAME'.

Thanks,

Sumit:-)