Jun 05
Update to “Using dbcc dbtable() to determine if a database is in LOG SUSPEND”
ASE, DBI, Databases, Perl, Sybase No Comments »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.
Recent Comments