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

The DBCC CHECKDB command will verify the checking of the integrity of the physical structure
of the page and record hearers along with allocation consistency of the database. A complete
run of the CHECKDB process will take longer depending upon the size of the database and
data files. The default behavior will be comprehensive logical checks, where page structures
are checked and new checks such as EXTEND_LOGICAL_CHECKS can be specified on
indexed views, XML indexes, and SPATIAL indexes. The logical consistency checks will
cross-check the internal index table of an object.
DBCC CHECKDB statement with EXTEND_LOGICAL_CHECKS option
is a resource intensive operation that must be performed only if there
is a doubt of suspect index issues that are unrelated to physical
corruption, or a page-level checksum is turned off on the database.
Configuring a server storage system for
scalability
The scalability and performance is guaranteed when the reliable storage is configured at
the hardware level. In general, the storage configuration and management is handled by the
Storage Administrators and it is a compulsory exercise for an organization to involve DBAs at
configuration level that will shape up a well-built database server on hardware perspectives.
The reliability characteristics and performance implications depend on the RAID configuration,
and in this chapter we will go through the best practice layout in configuring a server storage
system for scalability. When deploying a new SQL Server instance or performing a scale-out
exercise of an existing SQL Server platform, it is important to have an overall understanding
of the key file types that are essential for a database. The file type's workload along with the
database type and size enables both storage administrators and DBAs to establish necessary
storage requirements for the SQL Server environment. In this recipe, we will plan for and
configure the SQL Server database storage in a SharePoint Server 2010 environment.
Getting ready…
Before we jump into how to accomplish the task, it is essential to touch up on essential
database file considerations and configuration of a server storage system. These points will
stand as a starting point too.
With the new features of SQL Server 2008, any type of data storage is possible:
F The OLTP database might include only a single database file, while those designed
to support heavy transactional workloads or large schemas might use a variety of
filegroup architectures to improve scalability, performance, operational convenience,
or availability.