SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Database-based Transaction Counting Find Script

By Yusuf Kahveci,

Within the last minute you can learn about our transaction volume on our database with our script below.

NOTE: You can monitor the number of transactions that occur within the range of 10 minutes, 2 minutes, etc., by entering the desired time interval into the WAITFOR DELAY statement.
This script can also be graphically monitored in charts via SSRS by being converted into Jobs in certain periods.
Yusuf KAHVECI
yusufkahveci@sqlturkiye.com
www.sqlturkiye.com
Thanks.

Total article views: 2363 | Views in the last 30 days: 149
 
Related Articles
BLOG

One More Minute

Ever say “one more minute” while working on something and then realize 30 minutes have gone by? My d...

FORUM

Converting Time value stored in minutes

minutes since 1-1-0001

BLOG

SQLRally Meeting Minutes

The starting point for a good meeting is an agenda and minutes. It took us a bit to catch up,...

ARTICLE

Five Minute Refactoring

The debate over how to change code or solve a problem can create arguments that last for years. Stev...

FORUM

Converting minutes to days and hours

Converting minutes to days and hours

Tags
 
Contribute