Transactions Hitting a Database

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  July 27, 2009 at 3:41 am

  #132324

  Hi All

  I am using SQL Server2005 (64Bit), is there any way to find out how many transactions that hit each database per sec

  Thanks in advance for all your help

• Grant Fritchey

  SSC Guru

  Points: 399011

  More actions

  July 27, 2009 at 6:47 am

  #1030466

  Performance Monitor is traditionally the place to get this kind of information. You can look at the counter Database:Transactions/Sec:DBName to get the transactions/sec for any given database or use the _Total to get the server transactions.

  You can also query the sys.dm_tran_* dynamic management views to get up to the moment information about transactions occurring within the database.

  You can also query sys.dm_os_performance_counters to get the performance monitor counter data within a query.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  July 27, 2009 at 8:42 am

  #1030569

  Thanks Grant