Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BGCDBA
Starting Member
6 Posts |
 Posted - 2007-11-16 : 12:14:34
|
| I'm new to the DBA world, and have no one else in the company to look up to. Does anyone know what I might need to check out or do when the Data File Size is 204% full? Or is this not necessarily a bad thing?I'm getting this from a Diagnostic tool I have.The number of tables is 148 Data file size 35,941 MBData Size 26,549.92 MBIndex Size 177,130.02 MBLog File Size 5.05 MBThanks, |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-11-16 : 12:34:40
|
| check whether u have sufficient disk space or not.If u have enough disk space then nothing to worry...RKNAIR |
 |
|
|
BGCDBA
Starting Member
6 Posts |
Posted - 2007-11-16 : 12:49:20
|
| Yes I have 65 GB free on the server. So that's about twice as much space free of the size of the database. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 00:44:47
|
| Where did you get those numbers? Data size will not be large than data file size unless there are multiple files in the filegroup. |
|
|
|
BGCDBA
Starting Member
6 Posts |
Posted - 2007-11-20 : 16:45:41
|
| These numbers came out of the Idera diagnostic manager. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-11-21 : 04:24:19
|
| If you are using SQL Servr 2005 , it's worth checking the Reports - which essentially access DMVs and give you some relevant informationJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Data File Size Full