Use SQL storage compress to compress SQL Server database files

In the past few days, the SQL server data compression function has been tested. By enabling compression for Data Warehouse tables, the disk space is greatly reduced, and query performance and backup speed are improved. However, the data compression function of SQL Server is available only for the Enterprise Edition. The Standard Edition cannot be used.

 

After checking through the Internet, 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 downloading and installing it, hyperbac Control Service is started. This Service works with Windows
I/O manager compresses 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 follow general SQL
Server operations are the same, and 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.

 

The price is very low. on the official website, there is $995 USD for a server and there is a discount. If you are interested, you can download and play:

Http://www.red-gate.com/products/dba/sql-storage-compress? Utm_source = simpletalk & utm_medium = weblink & utm_content = sscsureguide_bmcgehee & utm_campaign = sqlstoragecompress

 

Technical Reference: http://www.simple-talk.com/ SQL /sql-tools/brads-sure-guide-to-sql-storage-compress/