I've installed all three to try'em out and they all seem to be working
so far, more or less.
Log Explorer has given me a couple of errors but I started over and
continued OK.
ApexSQL Log squawked about "redo for delete cannot be generated for
tables lacking clustered index". Huh? What the...? We have lots of
tables without a clustered index.
I read some reports in Red-Gate's technical support forum about their
product actually bringing down SQL Server. That did not inspire
confidence.
All three install some server-side components like extended stored
proc's which I'm not crazy about and I think all three are server or
instance licensed (does anyone actually purchase more than one license
when it seems like you can easily move any tran log to be analyzed to
the server the product is installed on?). I don't think I'd want to
install any of them on a Production server, at least one that I'm
responsible for!
Thanks,
MartinMartin (mvirta@.olgc.ca) writes:
> ApexSQL Log squawked about "redo for delete cannot be generated for
> tables lacking clustered index". Huh? What the...? We have lots of
> tables without a clustered index.
Probably the people at ApexSQL are like me: they think that every table
should have a clustered index.
If nothing else, fragmentation is easier to keep in check, if you have
a clustered index.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
