Many industries require keeping records that go back for several years. However, in reality, only records going back one or two years are often accessed. These non-accessed records are referred to as “cold data.” Cold data, while rarely accessed, still takes storage space and processing speed. For instance, say a company has seven years of records, yet only needs to query the last sixty days. Every query will have to go through all seven years worth of data each time, resulting in wasted processing time. So how can these companies solve this problem? Stretch Database (Stretch DB) featured in SQL Server 2016 is an excellent solution for businesses that are storing long-term records.
Stretch DB is scalable. There are many tiers available for an hourly or monthly rate. These can be adjusted as business needs change. Stretch DB also makes backups easier, as there is less on site data to worry about. Though there are a few limitations to what can be sent to the cloud, overall Stretch DB is a seamless integration of cloud and in-house service that frees up internal storage and makes queries faster. SQL Server 2016 and Microsoft Azure have a winning combination with this feature.
Want to see if SQL Server 2016 is the right fit for your organization? See if you qualify for Solvaria’s free database assessment here!
Comments or questions? Drop us a line below!
Share on
