Maintenance and Monitoring - Microsoft SQL Server 2008 R2 Administration - page 349

The next set of steps are essential to benefit the
scalability by using the placement of data files.
6. Place the tempdb database data files on RAID-1 or RAID-1+0, depending on their
capacity requirement.
7. Select the appropriate RAID type for database files based on scalability. RAID 1+0 or
RAID 6 will provide the best performance, but at a higher cost.
8. Place transaction logs on RAID5 rather than RAID1+0 for sequential workloads.
9. Create one tempdb file per CPU core and make all files equal in size.
10. Place tempdb files on a separate RAID1+0 group from the database and logfiles with
the fastest hard disk drives.
11. For SharePoint server data storage on the SQL Server database, do enable auto-
create statistics as the SharePoint Server configures the required settings upon the
provisioning and upgrade.
12. Create multiple data files equal in size for the content database. The number of data
files must be less than the number of core CPUs.
13. To estimate the storage needs, the quicker way is to multiply the average row length
by the number of records per month.
14. Multiply that result by the number of days', weeks', or months' worth of data that will
be kept in the database to obtain the approximate amount of storage required. Add
about 15 percent to this for database overhead.
How it works...
The scalability is addressed on a better scale when all the corresponding hardware
configuration and tweaking is followed. Several SharePoint Server 2010 architectural factors
influence storage design. The amount of content, features, and service applications used,
number of farms, and availability needs are key factors.
Configuring SQL server storage architecture
for quick recovery
In continuation of the previous recipe, the storage server configuration helps the data
platform to keep up the scalability. Similarly, the storage architecture can also help to attain
the quick recovery of data in case of failure.
Business-critical applications depend on SQL Server and its features maintain the data
integrity as well as ensure data availability and performance, which requires the storage
architecture to store data on high-performance and highly available storage resources.