Using performance monitor our number for transactions/sec for tempdb is almost equal to the number for transactions/sec for _Total. Is there a good way to determine what is the bulk of this? Should I be using Profiler and if so what events, data columns, filters should I select? Or is Profiler not the way to go and I should be using something else like a T-SQL Script? I have been working with Profiler but I must be selecting the wrong things because I don't see it.