April 14, 2008 at 12:54 pm
If I have more logical reads( say 1056193) for the event class Audit Logout, does this effect the bandwidth on the server?
Thanks.
April 16, 2008 at 10:21 am
logical reads [and writes, CPU, duration] will be aggregated during your user session
- when you logout you get these totals [they are not for the actual logout itself!]
in your example the db engine has done 1M reads (hopefully mostly from cached blocks in memory), which probably means little
- what you need is to look at each statement-end to see where the big numbers are
suggest you get the Ben-Gan TSQL Querying book (chapter3 if I remember as mine has gone walkies) which tells you how to boil down a huge Profiler capture into distinct statements
- you can discover which are the heavy hitters
or use the SSMS report "top queries by total IO" [context menu on the instance] to see this
HTH
Dick
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply