SQL Server Disk Usage Statistics?
Posted on 2009-04-17
We have an issue with our BizTalk server currently. It runs very slowly. So we ran some diagnostics tools (BizTalk Message Box viewer) and discovered some potential issues with The sql server backend. My question relates to disk usage versus space allocated in sql 2005. When I click on the properties for the BizTalkMgmtDb it says the size of the DB is 1755.19 MB and there is on .42 MB space available. The amount listed inspace available would be bad I would think. But my question I guess is essentially what does this number really represent ?
I ask this because when I run a disk usage report it says 99% of the transaction log space is unused. Would this would be 99% of the space allocated for the transaction log I would think ? Statistics for the data files state( 62% used, 8.5 % unused,25% index, and 3.7% unallocated) I guess part of the problem is I really don't completely understand these numbers. Can somebody explain these numbers to me and tell me if I have a potential disk space problem.
Any help would be greatly appreciated.