I have a table which uses and identity seed for its unique identity column. We have noticed some massive jumps in the identity value which we are not able to explain. The table has 20,000 odd rows, the maximin identity value is over 560,000,000 and the identity increment is at a value of 1!
I wanted to use SQL Server profiler to monitor activity on just that table so i could see what was causing the identity to jump in large incerments but when i came to look at the monitor i was instantly confused. I admit that i am in a rush and don't have time to really learn how this work (as much as i would like to) so could use a rough guide as to the steps you should take to monitoring activity on a table.
Any help would really be appreciated.