You configure the SQL server memory to ensure that the reports do not take more time to get generated.
Stop the SQL server service.
Open SQL Server Management Studio (type SQL in the Start menu Search box).
Right-click the server and then click Properties .
In Maximum server memory (in MB) box, enter 70% of the system memory (RAM).
Click OK .
Start the SQL server service.