Hi  All,

an error was thrown while running a query which runs fine on daily basis

Exception of type 'System.OutOfMemoryException' was thrown.

Please Suggest

Regards

Rahul

Exception of type 'System.OutOfMemoryException' was thrown.

This is a .NET exception so it seems the query is using SQLCLR objects.  The error may be due to a temporary low memory condition or one that is caused by a data anomaly that resulted on excessive memory utilization.  Perhaps we can better help you if you provide more details on the SQLCLR objects used by the query.

Can you show the stack trace please?

Hi 

its a sql server query not any clr and was running fine earlier and no maintenance job was running at that time.Sorry for late response on this.

Regards

Rahul

its a sql server query not any clr and was running fine earlier and no maintenance job was running at that time.Sorry for late response on this.

Can you try running query in chunks.Is your system 32 bit or 64 bit?

How much RAM is there for SQL server (max server memory)

Can you see any OOM error in SQL server errorlog

System.OutOfMemoryException is a CLR exception. Please, could you show the entire error message?

And please, where do you get the error? In SQL Server Management Studio? Please give us some context information.

• Edited by Jesús López 2 hours 36 minutes ago x

System.OutOfMemoryException is a CLR exception. Please, could you show the entire error message?

And please, where do you get the error? In SQL Server Management Studio? Please give us some context information.

• Edited by Jesús López Thursday, October 10, 2013 7:52 AM x

Hi Jesus,

I got the message in SSMS only.Moreover whenever i am selecting the option 'Show Results to Text' the query is able to run properly but when i try to see it in grid this message is displayed and there are no CLR objects used or referred by it.Any idea?

Regards

Rahul