Skip to Content
0
Former Member
Nov 23, 2009 at 07:08 AM

Regd. adding new datafile

37 Views

Hi All,

We have mapped a drive of 400 GB from SAN to our Production system and all our database data files are residing on it.

Now this drive space is about to fill completely and our IT team added a new additional drive to the system .

Hardware details: (DB server)

32 GB Memory

2 - Quad core processors ( 8 Cores)

Current Datafile number: 4 (One .mdf file and 3 .ndf file - all are in primary group)

For a better performance,

Query 1:

Do I need to add some more datafiles (.ndf) and place it in the new drive ? If yes maximum how many more files I can add for the above hardware configuration to get better performance ?

or

Do I need to move 2 data files from the existing drive to the new drive and keep the total number of data files as 4 itself using detach/attach method of DB?

Query 2:

If I choose the first option of adding new datafiles to the new drive and if my .mdf file can't grow but new .ndf files can grow, is that okay?

or

Is it mandatory that there should be always space available for .mdf file to grow?

Note: Taking downtime for the production system is not a problem. I need a best option to have good performance also if possible to minimize downtime for this activity.

Regards,

Nalla.