If you haven't looked into SQL Server 2008, and you have a large database, we suggest that you get an evaluation copy. You'll want to explore one of the best features Microsoft has added to SQL Server in a long time: data compression. Data compression can help you keep the hardware costs for RAID and hard drives under control when you run Teamcenter.SQL Server 2008 actually has two types of compression in it, data compression and backup compression. Although backup compression can be a good thing, most of us who maintain very large databases mostly use third-party backup tools or take our backups using a SAN snapshot, which provides backup compression.
What is Data Compression?Data compression provides a solution to the challenges of managing very large databases. Using this feature, a DBA can selectively compress any table, table partition, or index, resulting in a smaller on-disk footprint, smaller memory working-set size, and reduced I/O. SQL Server 2008 supports two types of compressions:· Row compression, which compresses the individual columns of a table· Page compression, which compresses data pages using row, prefix, and dictionary compression Although the amount of compression that is achieved is highly dependent on the data types and data contained in the database, row compression generally results in lower overhead on the application throughput with marginal space savings. Page compression has a higher impact on application throughput and processor utilization but results in much larger space savings. Read more: Siemens Teamcenter on SQL Server
What is Data Compression?Data compression provides a solution to the challenges of managing very large databases. Using this feature, a DBA can selectively compress any table, table partition, or index, resulting in a smaller on-disk footprint, smaller memory working-set size, and reduced I/O. SQL Server 2008 supports two types of compressions:· Row compression, which compresses the individual columns of a table· Page compression, which compresses data pages using row, prefix, and dictionary compression Although the amount of compression that is achieved is highly dependent on the data types and data contained in the database, row compression generally results in lower overhead on the application throughput with marginal space savings. Page compression has a higher impact on application throughput and processor utilization but results in much larger space savings. Read more: Siemens Teamcenter on SQL Server
Posts
0 comments:
Post a Comment