cancel
Showing results for 
Search instead for 
Did you mean: 

SQL error 701 when accessing table "T021D"

Former Member
0 Kudos

Dear Experts,

We're facing the error "There is insufficient system memory in resource pool 'default' to run this query." and short text from ST22 says "SQL error 701 when accessing table "T021D"". (see attached screenshot)

As we lack in resources, could you please let us know, if there are any options in getting rid of these issues like changing the memory parameters?

Thanks & best regards,

Sreenu

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

If you can check memory allocation with DBCC MEMORYSTATUS

It is advised on your query reduce the batch size.

Please refer below link

  https://support.microsoft.com/en-us/kb/2001221

Br, Vaibhav

Former Member
0 Kudos

Hi Vaibhav,

Thank you for your Response.

Could you please let me know, what has to be done exactly inorder to reduce the Batch sizes?

What does it mean "replace SQL variants with other types"?

BR,

Sreenu

Former Member
0 Kudos

Hi,

Based on your current memory setup try to slice the data , like put filter on dates and execute the program.

SQL Varaints are data types like VARCHAR(), INTEGER , which you can replace based on your input data .

To tune query and perform optimization require excessive analysis.

Br, Vaibhav

luisdarui
Active Contributor
0 Kudos

Hi Sreenu,

1) What is the full version of your SQL Server database? You can run the following query to get this:


SELECT @@VERSION

2) What is the value for the instance parameters 'min server memory (MB)' and 'max server memory (MB)' ? You can run the following query to get this:


select value_in_use from sys.configurations

where name in ('min server memory (MB)','max server memory (MB)')

3) How much memory do you have in your database server? Provide the results of the following command:


systeminfo.exe | findstr Memory

4) Do you have any backup or DBCC CHECKDB job running in the database during the times you observe this error?

Best regards,

Luis Darui

Former Member
0 Kudos

Hi Luis,

Thank you for your Response.

  • SQL Server Version: MS SQL Server 2008 R2 (SP2)

  • Both parameters "Min Server Memory" and "Max Server Memory" value is 3276

  • Database Memory Information:

        - Total Physical Memory: 32.768 MB

        - Available Physical Memory: 24.229 MB

        - Virtual Memory: Max Size: 70.766 MB

        - Virtual Memory: Available: 27.129 MB

        - Virtual Memory: In use: 43.637 MB

For further questions, please let me know!

Thank you,

Sreenu

luisdarui
Active Contributor
0 Kudos

Hi Sreenu,

The memory for your SQL Server is too small in my opinion. Are you running SAP instance also in this server? If yes it is recommended to use roughly 1/3 of the total physical memory with SQL Server. If this is a dedicated box, try to reserve 4 GB for the OS and the rest for SQL Server (28GB SQL Server/4GB OS). See SAP Note 1237682 for more information.

I would try to increase the SQL Server memory up to 10GB since you have 24GB free memory. Both min and max memory.

Best Regards,

Luis Darui

Matt_Fraser
Active Contributor
0 Kudos

Sreenu,

You aren't giving your database nearly enough memory to operate. According to these figures, you have 32 GB of physical RAM on this box, and yet you have only apportioned a little over 3 GB for the database. You should consider adjusting "Min Server Memory" and "Max Server Memory" to something closer to perhaps 30% or 35% of the total physical RAM. Be aware, though, you'll also need to adjust PHYS_MEMSIZE in your instance profile downwards to make that memory available for SQL Server. You might want to set PHYS_MEMSIZE to something like 60% or 65% of physical RAM. That will require a restart of your application to take effect, so if this is a production system, plan accordingly.

Cheers,

Matt

Sriram2009
Active Contributor
0 Kudos

Hi Reddy

1. Just do the full system restart and then check the same.

2 . Could you share the full dump as text format attachment?

3. Have you define the memory parameters based on SAP Note ?

88416

Zero administration memory management for the ABAP server

Regards

SS

Former Member
0 Kudos

Hi Sriram,

Thank you for your Response.

Please find the dump file in attachment and also I added the Memory Parameters according to the note 88416. But, what does [US] mean mentioned in this note? So, I am not able to assign values to these Parameters "rdisp/ROLL_MAXFS", "rdisp/ROLL_SHM", "rdisp/PG_SHM" in RZ10.

Any ideas, please?

Thank you,

Sreenu

Sriram2009
Active Contributor
0 Kudos

Hi Reddy

To address this issue, you have define the memory for MS Sql DB from over all physical memory 30% in your case total physical memory 32 GB, In MS Sql MMC define 9.6 GB. and then check,

Regards

SS