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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Data files size question

Author  Topic  pnkp Starting Member 1 Post Posted - 2005-06-27 : 02:43:28 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 server. 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 the size of each data file is 17GB, 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