Does Spotlight capture the value of log_growth_wait_desc?
For troubleshooting log growth/truncation issues, particularly after the fact, Spotlight should capture the value of log_growth_wait_desc from sys.databases as one of the columns displayed in the Databases grid on a SQL Server connection. Having that value can tell why a transaction log file exploded in growth overnight.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.