Hi,

we are running a Microsoft SQL server and our overall database size is around 290GB. We currently have a total of 16 data files for that database. I have a couple of questions I need to ask.

In terms of performance, when the data files reach close to the size they were allocated, which is better: expanding the size of the existing data files, or creating a new data file? Currently our data files are 17GB each except one which is 33GB

Also we currently have around 5GB space available. Can limited free space on the hard-disk affect the overall performance of database server? And if yes then approximatetly how much free space would you recommend so that the database is not affected?

Thank you in advance for any help,

pnkp