locked
SQL Server Memory Problem RRS feed

  • Question

  • Hi,

    I had come across an issue recently where the SQL server 2008 instance stopped accepting any connections and became unresponsive. I had to restart the SQL server to bring it back.

    The bellow error is logged in SQL log. 

    Error:

    --------------------------------------------------------------------------------------------------------------------------------------

    AppDomain 2 (database.dbo[runtime].1) created.

    Unsafe assembly 'tldbwin32clientmanagedinterface, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 2 (database.dbo[runtime].1).

    Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576

    -------------------------------------------------------------------------------------------------------------------------------------

    What does this error mean and how this can be addressed? 

    Any help on this appreciated. 

    Thanks,

    Vipin

    Tuesday, December 4, 2012 10:17 AM

Answers

All replies

  • See if this helps you

    http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/101aa6f8-4ed1-4a4a-84e4-abbc79a8b371


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    Tuesday, December 4, 2012 10:45 AM
    Answerer
  • what is the bit -is that 32 and 64 bit?

    http://blogs.msdn.com/b/sqlsakthi/archive/2011/11/10/large-network-packet-size-and-memory-pressure-in-sql-server.aspx


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, December 4, 2012 11:37 AM
  • Hi Rama,

    Its 32 bit.

    Thanks

    Tuesday, December 4, 2012 11:41 AM
  • And how is memory configured ?

    Thanks

    Santhu

    Tuesday, December 4, 2012 11:45 AM
  • Vipin, please share the start-up parameter. Do you have hyperthreading enabled?

    Tuesday, December 4, 2012 11:53 AM
  • the above your issue is for non-bpool memory, might be you may need to allocate more memory for your non bpool , but more ever you need to analyze properly before enabling it.. yes Uri link provides more information how to analyze..


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, December 4, 2012 11:57 AM
  • I would think that you have a badly written unsafe (!!!) assembly, and you need to go back to the author of that assembly and see why it tries to allocate so much memory and if there is a memory leak in that assembly. Note that since it is unsafe, it can do just about anything - all safety nets are gone!

    Tibor Karaszi, SQL Server MVP | web | blog

    Tuesday, December 4, 2012 1:07 PM
  • FAIL_VIRTUAL_RESERVE 1048576 is MTL error and common in 32-Bit SQLServers. You have to look at the memory status output printed immediately after this error in SQL Server errorlog and identify who is consuming majority of MTL. Refer   "Section 1 (MTL error)" in below link for detalied troubleshooting steps.

    http://mssqlwiki.com/sqlwiki/sql-performance/troubleshooting-sql-server-memory/


    Thank you,

    Karthick P.K |My Site|My Scribbles |Blog Space |Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Proposed as answer by Manishu Upadhyay Friday, December 7, 2012 9:46 AM
    • Marked as answer by Maggie Luo Sunday, December 23, 2012 9:51 PM
    Wednesday, December 5, 2012 4:45 AM
  • Thanks Karthik for the suggestions.The link you shared was really useful.

    Thanks,
    Vipin 
    Friday, December 7, 2012 8:46 AM
  • Vipin,

    Please let us know if link by Karthick helped or do you have any other questions.

    Regards,

    Manish

    Friday, December 7, 2012 9:49 AM
  • Manish,

    Yes, the link from Karthik helped to fix this issue.

    Thanks a lot.

    Vipin

    Tuesday, January 8, 2013 10:46 AM