Multiple database files.
-
Some previous DBA created a database with two files + log.
The allocated file sizes are 400MB for the first file(*.mdf, 145MB used), and 30000MB for the second file (*.ndf, 24400MB used). The logfile is 12000MB, of which 250MB is used currently - this varies of course.
My question is, since these files reside on a RAID 1+0 SAN storage, is there any pupose in having two/multiple data files?
And is it possible to merge the *.mdf and *.ndf files?
-
More files allows windows to spawn additonal threads to do I/O on them. Are they needed in your situation? I can't answer that. Second, yes you can merge the .ndf into the .mdf by using dbcc shrinkfile or using enterprise manager right clicking on the database and choosing srink in the second tab you can choose to empty one file into another and then delete the file that is now empty.
Cheers,
Wes
-
No, not needed since the database itself is on a SAN.
Thank for your answer.
-
>> My question is, since these files reside on a RAID 1+0 SAN storage, is there any pupose in having two/multiple data files?
Perhaps the previous DBA wanted to be able to perform file/filegroup backups, which may explain why the database files are split as such, although a 400MB and 30Gig split is strange.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply