03-14-2012 06:06 AM
Hi all,
Am I correct in that the check for the above event only take into account allocated space for the transaction log file in SQL Server and size of the file on disk ?
So it doesn't check for white space in the transaction log or what the auto growth setting is set to?
Have a customer that get the above event but the from a dbcc sqlperf (logspace) run, the log space used is roughly 4%.
The T-log is backed up daily.
Cheers
Fredrik
Solved! Go to Solution.
03-14-2012 08:09 AM
Hi, FreKac, it uses DBCC SQLPERF(LOGSPACE) in VSDB.usps_GetTransactionLogSize and EVDir.GetTransactionLogSize stored procedures, Dtrace EVmonitoring for more info.
03-14-2012 06:14 AM
Shrink the logfiles:
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO
03-14-2012 06:42 AM
Yes I know how you can do it, my question was in regard to if that is what EV checks.
Since that event only check the sizeon a very basic level (if I'm correct).
Also TRUNCATE_ONLY is gone in SQL 2008, you have to alter the database to simple then shrink the file then back to full.
Yes, it's solveable but I would like to know what EV checks to generate the event.
03-14-2012 08:09 AM
Hi, FreKac, it uses DBCC SQLPERF(LOGSPACE) in VSDB.usps_GetTransactionLogSize and EVDir.GetTransactionLogSize stored procedures, Dtrace EVmonitoring for more info.
03-14-2012 08:54 AM
Thanks Nathan, will check those stored procedures.
Cheers,
Fredrik
03-21-2012 07:50 AM
Hey FreKac.
If Nathan provided you the information you needed... please flag his post as haivng provided teh solution. This helps people who are trying to help find those that need help and gives nathan props for being awesome.
If you have outstanding questions or concerns, please let us know so that we may continue to help.