December 17, 2003 at 8:54 am
Hi,
How can I find the number of transactions done per day on a server running MSSQL 7.0
Thanks
December 17, 2003 at 9:59 am
I don't think there is an easy way to do this that I know of. One option would be to set up some trace that would capture the events that you consider to be a transaction. Look at all the xp_trace.... extended showed procedures to figure out how to do this.
Gregory A. Larsen, DBA
Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp
Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 17, 2003 at 10:36 am
You might also look into using the "Batch Requests/sec" in smaster..sysperfinfo table
Gregory A. Larsen, DBA
Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp
Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 17, 2003 at 10:46 am
Lumigent also has a product called Log Explorer. I believe you can download a free trial.
http://www.lumigent.com/products/le_sql/le_sql.htm
The nice thing about Log Explorer is that you can examine log dumps, so you don't have to take a performance hit on your live database. Of course this won't help you if you're mostly interested in selects.
December 17, 2003 at 1:41 pm
Lumigent costs a lot of money. Use a trace unless you have deep pockets.
December 18, 2003 at 10:23 am
you can explore the transaction log as Lumigent does by checking the following:
--#1 in SQL 7.x & above
DBCC LOG (database)
--#2 in SQL 2000
SELECT * FROM ::fn_dblog(1,NULL)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply