In slow economic times, it is often hard for customers to justify upgrading technology when they cannot easily identify specific benefits they will enjoy as a result of the upgrade. For those Microsoft Dynamics GP customers who haven’t yet upgraded to SQL Server 2008, I think you may find the results of our recent Performance Benchmark tests to be reason enough to make the jump!
In the latest test results utilizing a very large sample Microsoft Dynamics GP database, the application showed an 18% increase in performance through upgrading from SQL Server 2005 Enterprise Edition to SQL Server 2008 Enterprise edition when using Row Compression. Even without Compression enabled (which is a NEW feature to the 2008 release), SQL Server 2008 still showed a 9% gain in performance when compared with SQL Server 2005.
If that isn’t reason enough, an additional benefit demonstrated by the benchmark performance tests was how enabling Compression reduced the disk drive space requirements of the large sample Microsoft Dynamics GP company database used in the test, as outlined in the table below.
Test #1 SQL 2005 - Baseline
Test #2 SQL 2008 - No Compression
Test #3 SQL 2008 - Page Compression
Test #4 SQL 2008 - Row Compression
Sample Company database size
282 GB (0%)
134 GB (-52.5%)
163 GB (-42.2%)
These results clearly show that upgrading to SQL Server 2008 Enterprise edition can have a significant impact on system performance, especially when Page or Row compression is enabled on select tables in the company database. Also, considerable amounts of hard disk space can be conserved by the Compression functionality offered in SQL Server 2008, allowing customers to perhaps postpone hardware upgrades when facing low disk capacity.
Microsoft Dynamics GP Partners and Customers can check out the full results of the test by downloading the new White Paper available here: PartnerSource: https://mbs.microsoft.com/partnersource/newsevents/news/MDGPSQLWhitepaper
Enjoy your weekend everyone!
PS: I almost forgot to mention another HUGE reason to upgrade to SQL Server 2008. The upgraded Report Builder tool and the new features in SQL Reporting Services represent tremendous value to our customers as well. You can follow all the happenings of these tools over on the SQL Server Reporting team blog here http://blogs.msdn.com/sqlrsteamblog/.
This row compression sounds great. Will Microsoft be providing recommendations for using it with GP? If we are to promote row compression as a benefit of moving to SQL 2008, we need to know how to use it, or at least how not to use it.
If you haven't already, download the White Paper from the PartnerSource link on the post. In the White Paper details, you will find details on how Compression was enabled within the GP sample company as well as guidance on how to properly select the right tables that are candidates for Compression. If you don't get all of your answers there, let us know and we can find someone here to help out further. Thanks!
When I attempt to download the white paper I get a zipped file with a bunch of XML documents. How dow I read the content? The PDF link is also broken.
Mariano Gomez, MVP
Maximum Global Business, LLC
Thanks Mariano. There is actually a bug right now in PS for anyone using IE8. Any .docx file is downloading as a .zip file. The workaround in the interim is to rename it from .zip to .docx and you can open the file without issue. Let me know if you have any trouble,