Since the release of Microsoft SQL Server 2016, table and index partitioning capability is available in the Standard Edition. Therefore, the cost to deploy Prognosis Advance Reporting has potentially been reduced.
Prognosis Advance Reporting offers the flexibility to create, modify or customized reports based on the data being monitored and collected by Prognosis. These reports can cover wide audiences; from a high-level summary reports for executive, to detailed reports for the operations team. Therefore, Prognosis Advance Reporting by design collects a large amount of data at a granular level.
Due to the sheer size of data being collected, it is very important for users to partition the SQL tables. A well-designed partition allows users to scale out the data that optimizes performance and simplifies data management. Partitioning large tables allow users to transfer or access subsets of data quickly whilst maintaining the integrity of data collections. Maintenance operations are more efficient, since it targets subsets of data rather than the entire table.
Since the release of Microsoft SQL Server 2016, table and index partitioning capability is available in the Standard Edition. Therefore, the cost to deploy Prognosis Advance Reporting has potentially been reduced. We’ve noticed that there is an increase in interest in Prognosis Advance Reporting from potential reporting customers. While there are potential savings to be found for existing customers who have previously deployed Microsoft SQL Server Enterprise Edition for table and index partition capability.
If you have any experiences or thoughts regarding Prognosis Advance Reporting or reporting in general, leave a comment, we’d love to hear from you.