Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2010-12-06 : 20:21:15
|
| We have come across with the new quest for knowing the number of transactions needed per database, as this becomes evident due to part of this process will be to distribute the databases according to transaction load.Can anyone help me how to get the transaction load per database / Table-wise OR Per-session-wise.Many thanks for this help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-12-07 : 23:05:35
|
| Thanks Tkizer once again.Sorry for making twists.We have several database s were having hectic transactions irrespective of the session and day-wise etc.I want to grab the number of Transaction - recorded on database(s) on session-wise, day-wise etc.I know using the Perfmon Counters will show the batches of transactions but we have around 400 databases on each instance and every database has got 200 columns on it.Now if I have to setup the Perfmon counters on these transactions then how many such counters I need to setup?If I setup that many number of counters per database there will be any Additional system resources might be consumed and I / O Problem would topple them.So I just want to get the Number of transactions per database at particular session OR per day using other method than perfmon counters.Can you help me. Many thanks for responding.This might be helpful for all Database administrators / Developers to know it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-12-08 : 15:28:09
|
| Thanks Tkizer. Is there any other method apart from Perfmon Counters to Count the number of transactions?Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Transactions per database