Update to “Using dbcc dbtable() to determine if a database is in LOG SUSPEND”

Way back in January, I posted a method using dbcc dbtable() to determine if a database was in log suspend.  After a comedy of miscommunication with Sybase, the feature request 470339 was created to handle this issue:

When an 1105 is hit on some segment, the used/free page counters for the fragements the segment is on  should be set to 100% used.  So we can have more accurate output of log spaces usages, Or a better way for monitoring “tempdb” / “user tempdb” log space.

Kudos to Sybase for recognizing this issue as a real problem.

Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *