SQL Monitor 11.1 is now available. Learn more.

"No SQL files on this disk" message on drive that contains transaction log files?

I'm still learning my way around SQL Monitor so maybe I'm missing something obvious, but I thought I'd go ahead and ask anyway. While reviewing the Disk Usage page under the Estate tab for one of my SQL 2014 servers, I clicked on one of the drives listed and got the message "No SQL files on this disk". Which is weird because the drive hosts the transaction log files for the user databases on this server. If I log onto the server and navigate to this drive I can see the '.ldf' files, so I know they are in fact there. If I click on the other drive listed, I can see the '.mdf' and '.ndf' files (as well as the '.ldf' files for the SQL system databases). I've checked several of the other monitored servers and so far this appears to only be happening on this one particular server. Thoughts or suggestions please? Thanks in advance. 

Answers

  • Good Afternoon!
    Can you confirm what version of SQL Monitor that you're using?
    We have a fix for disk usage in 9.2.12 so it'll be very helpful if you could upgrade and check again.
    Should problem persists in the latest version, we'll need to take a look of the logs so we'll reach out by email.
    Thanks!

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





  • kwbellkwbell Posts: 2 New member
    squigley, Thanks so much for responding. That is our problem, we are on 9.1.0.22802, but I'm planning on upgrading to v10 in the next week or so; hopefully that'll fix the issue.
  • Sounds Good!
    Let me know if the upgrade helps to fix your issue.

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





  • jfeldmanjfeldman Posts: 4 Bronze 2
    hello. i get the same behavior with 10.0
Sign In or Register to comment.