How can we help you today? How can we help you today?

Recommendations False Positives

I think that the Recommendations tab is giving me a false positive on something.

I set it up to monitor the (local) SQL server. One of the databases is ProofOfConcept.

Per the Recommendations tab, there is excessive free space in the log file, and the details say, "The log file for database ProofOfConcept is 2808.93MB and has 2776.78MB of free space (98.86%). It is recommended to shrink the file to avoid excess wasted space".

The log file for that database is 504 KB per Windows and per SSMS.

Most of the other recommendations are spot-on. It correctly detected that I haven't ever done any backups of the databases and log files on my test server. (I don't.) And so on. But the log file thing seems to be in error.
GSquared
0

Comments

2 comments

Sort by
  • Nigel Morse
    Thanks for reporting it - we'll take a look into it.
    Nigel Morse
    0
  • Jason Cook
    Hi GSquared,
    Could you run the following SQL Query please, and forward the output to my email address ( jason.cook@red-gate.com ). The following code returns the size of the log files for all databases on your server.
    DBCC SQLPERF(LOGSPACE);

    Thanks,
    Jason
    Jason Cook
    0

Add comment

Please sign in to leave a comment.