||SQL Server Tips by Robin Schumacher
Data Lifecycle Management
DLM is the process of cost-effectively managing and optimizing
critical data and database infrastructures. The bottom line is that
DLM manages data from its logical conception down to its eventual
archival or removal. The three primary components, or layers, of DLM
- Data Management Service Layer.
- Database Management Service Layer.
- Performance Management Service Layer.
There is a lot of industry buzz around the concept of DLM.
Storage vendors have put their own spin on DLM and coined the
phrase, Information Lifecycle Management (ILM). However, upon closer
inspection, ILM is very storage-centric in its definition and
management. The ILM vendors do not believe data can be defined until
it hits the disk, which naturally upsets many data modelers and data
DLM is similar to ILM in some ways, but it is much more
encompassing. Figure 1.1 graphically depicts DLM. Non-relational
data sources must be included under the umbrella of DLM, as there is
much data managed outside of relational engines like SQL Server.
The above book excerpt is from:
High-Performance SQL Server DBA
Tuning & Optimization Secrets