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.
Trending Web Development posts
Sort by Trending