May 9, 2008 at 3:46 am
I'm running SQL 2005 and SQL 2000 with a number of databases and I need to find out how many transaction are being made within one day on the server or database.
Its is possible to find out previous transaction made on a database on a give day and find out the total amount of transactions made on the server.
Is there a T-SQL I could run to find out these results.
May 9, 2008 at 4:17 am
you need to run / collect perfmon data to manage this - or buy a tool sauch as Idera SQL Diagnostic Manager - This is all part of trending and statistics and you'll have to do this yourself.
I've some information on this on my web site http://www.grumpyolddba.co.uk and there's code and such on my blog.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 15, 2008 at 6:05 am
Hi there,
Thanks for the advise, I've been able to run profmon to capiture tranaction per sec
Cheers Rich
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply