DBIF_RSQL_SQL_ERROR in SAPunder MSQ server 2000

61 Views

Hi Gurus

I am getting Error as DBIF_RSQL_SQL_ERROR in st22 and the users are kicking out from the sap production System this morning

we are on 6GB RAM in SQL Server and between <=8 to <=16 GB in Application server

I can notice in my network packet size', 8192 instead of '4096' So do you think if i run the below script which is recommended in SAP Note 392892 and restart the R/3 System will that be ok, or is there any solution

EXEC sp_configure 'show advanced options', 1

EXEC sp_configure 'allow updates', 1

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'set working set size', 0

EXEC sp_configure 'priority boost', 0

EXEC sp_configure 'network packet size', 4096

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'allow updates', 0

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure

GO

regards