Use SQL Storage Compress to Compress SQL Server database files

Source: Internet
Author: User

Rea Hat provides a similar tool, SQL Storage Compress, and claims to be able to achieve a compression ratio of 90%. SQL Storage Compress provides a 14-day version. After being downloaded, The HyperBac Control Service is started. This service is used with Windows I/O Manager to compress or decompress SQL Server read/write requests, without affecting SQL Server users. For how it works, see:

SQLStorage Compress can Compress MDF, LDF, and NDF files, but only for files, not for single tables or individual indexes. Backup and restoration are the same as normal SQL Server operations. Compression and backup are not provided.

SQLStorage Compress provides a GUI that allows you to convert a database to a compressed database by restoring or restoring a database backup using a T-SQL. The following is a test I conducted, which is compressed by about 50%.

The operation interface is as follows:

After a data test, it took six minutes to insert 1000000 of the data and enable the compressed database. The database that didn't enable the compression did not even run for six minutes. It may be because my IO is not good enough, using SQL Server's built-in compression on the Server is slower than inserting data into tables that do not enable compression.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.