Discussion Locked

Migrating .dbf files to MS SQL

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am needing to upload 70 MB of .dbf files from our in-house database to a SQL server on our web site. Is there a formula for how much SQL space I need to reserve for optimum performance?

1 reply

by shelleydoll

Obviously, you need to be sure you have enough disk space to account for growth and caching, etc., but to get the best performance you need to look at the access capacity of your drives (IOPS) - this is different than ops/sec - you can find this information from the hard drive vendor under 'capacity specifications'. Usually, smaller data capacity drives have higher IOPS, so your best bet is to use multiple, small drives.

After that, your SQL Server documentation will tell you how much space they recommend for database functions, etc. Surprisingly enough, this is also going to be based on how your database is structured - ie. what fields you have indexed, and how frequently you access non-indexed data.

Good luck!

This discussion is closed to new replies.