Database Reference
In-Depth Information
8. Always keep additional LUNs to cater to the future growth, where data will
undoubtedly grow; in this case, it is essential to perform capacity testing on the
database for the next two years to cater for the growth.
9. Separate the LUN and physical disk that is used for the backup of SQL Server
databases. By default, the SQL Server backup operation uses one reader thread per
volume and one writer thread per volume.
10. It is i deal to have a larger number of small drives by creating each LUN (Logical Unit
Number) using drives from each bus to improve internal bandwidth.
11. Now, we are at the point using the freely available tools from the Windows
Sysinternals site: http://technet.microsoft.com/en-us/sysinternals/
bb545046 .
12. On the Windows Sysinternals site, navigate to the File and Disk Utilities page. Here,
let us download two tools: Contig from http://technet.microsoft.com/
en-us/sysinternals/bb897428 and PageDefrag from http://technet.
microsoft.com/en-us/sysinternals/bb897426 .
13. The Contig tool uses the internal defragmentation methods such as Winternals Defrag
Manager. This tool is useful for performing a general defragmentation of disks.
14. On the Server, open a Command Prompt utility by choosing the Run-As
Administrator option from Start | Programs. The general syntax for this tool is:
Usage: contig [-v] [-a] [-q] [-s] [filename]
-v
Use the -v switch to have Contig print out information
about the file defrag operations that are performed.
-a
If you want to simply see how fragmented a file or files
have become, use the -a switch to have Contig analyze
fragmentation.
-q
The -q switch, which over-rides the -v switch, makes Contig
run in "quiet" mode, where the only thing it prints during
a defrag run is summary information.
-s
Use the -s switch to perform a recursive processing of
subdirectories when you specify a filename with wildcards.
15. To use the tool on a specific directory, directly run: " Contig -s D:\
SQLDatabaseFiles\*.* ".
16. The PageDefrag tool provides the facility to defragment the paging files and
registry hives.
17. The tool can be installed using Administrator privileges on the server that will present
a list box confirming how many clusters make up the paging files on that server.
18. In addition to paging files, there is information about Registry hives ( SAM , SYSTEM ,
SYSTEM.ALT , SECURITY , SOFTWARE , .DEFAULT ), as well as how many fragments
those files are in.
Search WWH ::




Custom Search