September 9, 2002 at 9:57 pm
Hi all
I would like to get peoples thoughts on how they currently measure concurrent database users. Do you:
a) consider each SPID a concurrent user?
b) only "active" or running SPIDS (partaking in a user transaction)?
c) use the "transactions/sec" counter average?
d) avg logins per sec perf counter?
e) avg num of user connections perf counter?
f) active transactions perf counter?
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 10, 2002 at 4:26 am
When considering concurrent users of a database I go with number of SPIDS as this is the number of connections open to the database at the time. However if you are talking about concurrent transactions "transactions/sec" counter average is a good way to get the best average but this is server wide which may be what you were after anyway.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 10, 2002 at 4:26 pm
I go with spids too. Its not 100% of course, but for my purposes doesnt matter. Even that is a swag depending on how the apps are managing their connections.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply