|
|
|
|
|
Log Explorer 2.0 1 2 3 4 5 6 7 8 9 10 11 12 13 When you select the Load Analysis, you will get a warning message like the one below simply because you can be processing a significant amount of data which can put a large load on your database server since all data operations are processed through the extended stored procedure on the server.
Once it returns, you get more detailed information on the logs that were selected along with some basic performance data. The first tab shown below will give you high level stats on the transactional throughput as well as a summary of the numbers of transactions processed.
The User Load tab shown below will break down the transaction based on duration and the LSN.
The Table Load tab shown below breaks down the transaction volume more granularly into the number of each type of transaction that was processed against each table. This can also give you a very quick diagnostic on the system. If you are looking for transactions against a particular table, this tab can at least tell you if a transaction was processed against that table within the set of logs you selected before beginning to scan for those transactions.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
