earth_america
user_standard Log on
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
How to

How to


Products: WebReports
Functionalities: Reports
Product version: 1.8, 1.9, 2.0, 2.1, 3.0, 3.1, 3.2, 3.3, 2023, 2024
9/7/2015

Configuring SQL Server Memory

You configure the SQL server memory to ensure that the reports do not take more time to get generated.

To configure SQL server memory

  1. Stop the SQL server service.

  2. Open SQL Server Management Studio (type SQL in the Start menu Search box).

  3. Right-click the server and then click Properties .

  4. In Maximum server memory (in MB) box, enter 70% of the system memory (RAM).

     
    action_zoom_plus_stroke

  5. Click OK .

  6. Start the SQL server service. For more information, see Starting a Windows Service .

See Also

  • SQL Server
  • Starting a Windows Service
  • Reports Take Time to Generate