Some of my reports against my ERP system run for a long time and drain the system. Will CornerStar help this?
Absolutely. The key is managing demand on your system. An OLTP (on-line transaction processing) system creates spikes of demand on a CPU. Reporting often results in a larger demand for processing power for a longer amount of time. A CornerStar Data Warehouse removes the reporting database to a separate server, freeing your production system to do its primary job.