The Disk Usage report is showing lots of unused transaction log space (seems normal, there are hourly log backups). However the data file is mostly indexes and there is very little unused space. Is this normal?

enter image description here


Unless you have manually expanded the database to a size which is larger than that of the database's data size there won't be any free space within the data file. As the file files the file will be expanded based on the auto growth setting of the data file.

  • Autogrowth is currently set to 1MB, unrestricted. Good or bad?
    – Marcus
    Dec 6 '12 at 11:56
  • 2
    That would be bad. I typically recommend getting the autogrowth to 1 Gig unrestricted. That way it'll grow quickly enough without growing very often.
    – mrdenny
    Dec 6 '12 at 11:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.