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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-10-13 : 02:05:39
|
| Hi All,How can we found the maximum number of delete/insertion is happening on a particular table ?Thanks,Gangadhar |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-10-13 : 02:37:49
|
| I think you have to rephrase your question...it doesn't really make any sense. What do you mean by "maximum number"?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-10-19 : 00:54:13
|
| Hi Lumbago,I have database with 100 tables, from the front end application the rows are getting inserted/updated/deleted. I want to know the maximum number of transactions on which table is happening ?I mean max number of inserts/or delete ? ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2010-10-19 : 04:25:54
|
| what you can do is to create a trigger which store the value in a table which stores the maximum of each insert and delete operations made |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
maximum no. of delete/insert on a table