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 |
|
dhartz
Starting Member
2 Posts |
 Posted - 2008-08-14 : 09:15:33
|
| I had a database consisting of 3 data files, each 46GB.I added another datafile of the same size, but it has only grown to 16GB.The original 3 datafiles still seem to maintain a proportional size, but the 4th file does not. Now most of the read/write activity is performed on the 4th file.How can I reorganize the data to restore proportional fill?Thanks |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-08-14 : 10:15:34
|
| Are all of these files on separate physical disks? And is the new data file suffering from disk I/O problems? |
 |
|
|
dhartz
Starting Member
2 Posts |
Posted - 2008-08-14 : 10:57:01
|
| The data files are located on the same disk.The disk is located on a SAN connected over 4GB fiber HBA.Data file performance stats:File______IOStalls/ms________Reads_________WritesData1_____13.4_____________100,688,165___9,913,910Data2_____15.5_____________100,523,007___9,726,029Data3_____17.7_____________100,144,182___9,558,922Data4_____24.4______________80,111,074___29,316,297 |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-08-14 : 11:05:43
|
| Since these are all on the same physical disk, it does not matter if all of the I/O is on one file, or distributed across all four. It all goes back to the same (set of) spindles. |
|
|
|
|
|
|
|
|
Data files and proportional fill