SQLTeam.com | Weblogs | Forums

How many transactions are processed on a database and how is the server configured according to this number?

sql2012
sql-server-2014

#1

Hello folks,
i need to know how many transactions are processed on a database and how is the server configured according to this number?


#2

You can see how many at any moment. Is that what you mean?

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/transaction-related-dynamic-management-views-and-functions-transact-sql

also:

https://docs.microsoft.com/en-us/sql/connect/jdbc/managing-transaction-size