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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2004-07-11 : 16:54:34
|
| As per my other post: http://sqlteam.com/forums/topic.asp?TOPIC_ID=37308 , I recently had a real whopper of a problem caused by a software bug that made the transaction log entirely too active, and big, and therefore slow to back up.That's gotten me to thinking: I would have seen that issue immediately if I had a way to check what's being logged (like, are there 3,000,000 changes to our main user table every 10 minutes?). Is there any way to examine the transaction log, either live or from a backup, to get statistics about what's in it? I'd love to see a chart of number of transactions grouped by transaction type and table; that kind of info would really help poinpoint otherwise hidden performance issues, due to bugs or bad design.Any way to do that?Cheers-b |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2004-07-11 : 17:05:34
|
| http://www.lumigent.com |
 |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2004-07-11 : 17:12:32
|
| Awesome, thanks for the link -- that looks like just what I want. However, I hate places that don't publish even ballpark pricing info; do you know if we're talking $1k, $10k, or $100k? No sense investing energy in it if it's way outside our organization's budget.Thanks-b |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-07-23 : 05:35:15
|
| www.apexsql.com |
|
|
|
|
|
|
|
|
Determining what's being logged?