data files contain data and objects (tables, indexes and so on) and log files contain transaction log.
filegroups are grouped datafiles for easier admin.
There are primary and secondary Data Files.
The primary has the extension mdf and contains data and all information regarding data (such as information on the secondary data files). For optimal performance do not store data there.
The secondary has the extension ndf. No administrative data is stored here. There is a maximum of 32,766 secondary data files.
Extension ldf. Each db needs at least one log file. You can create more than one
Logical structure of data files.
Also there are primary and secondary filegroups. The primary contains the primary data file and every secondary data file not stored in a specific filegroup. There can be up to 32,766 secondary file groups.
Filegroups can be configured as read only.
The filegroups are created with the SSMS or with the CREATE DATABASE command.
Five parameters have to be considered: Name, Filename, Size, Maxsize and Filegrowth
There are Raid Levels 0,1,5 and 10. It has to be considered to be used in high performance environments. Configuring Database Files with RAID Systems RAID systems are arrays of disk drives that provide fault tolerance, more storage capacity, and better performance for the disk subsystem, depending on the configuration. Although RAID hardware systems are not part of the SQL Server configuration, they directly affect SQL Server's performance. There are a variety of RAID levels, each of which uses a different algorithm for fault tolerance. The most common RAID levels used with SQL Server are 0, 1, 5, and 10.
Manage research, learning and skills at IT1me. Create an account using LinkedIn to manage and organize your IT knowledge. IT1me works like a shopping cart for information -- helping you to save, discuss and share.