SQL Server running out of memory after some time

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Server running out of memory after some time

Viewing 4 reply threads
  • Author
    Posts
    • May 5, 2009 at 6:10 AM #22297
      community-content

        hi 

        We have a biztalk server having 2 applications hosted via WCF on it. it has moderate or can say low trafic.It was working fine initially, but suddenly SQL Server causing big bunch of memory utilization around 1.7 GB working set.

        Its a dedicated 64 bit widows 2003 machine for a biztalk with SQL standard edition. 

        It will be gr8 if you can help us in rectifying the problem.

        Thanks,

        Rashmi

      • May 5, 2009 at 6:21 AM #22298
        community-content

          For reference:

          we have Biztalk server 2006 R2 

           

          Thanks

          Rashmi

        • May 6, 2009 at 8:57 AM #22317
          community-content

            Add Extra RAM on the Box..How much memory the server had ?

          • May 12, 2009 at 11:33 PM #22363
            community-content

              Please clean up messagebox & see .

              If still this is happening , better to reduce persitance points from the code.

              If you can’t do any code changes the go with throttling.  example : # of db session by default infinite. You can fine tune this for the best. 

            • May 14, 2009 at 2:04 AM #22369
              community-content

                SQL Server is a memory hog and doesn’t play nice with others. It will continue to use memory if it is available and never gives it back.

                You can put limits on the amount memory the SQL Server will use. This is good idea if you share your server with other applications which may also like to use memory.
                http://msdn.microsoft.com/en-us/library/ms178067.aspx

            • Author
              Posts
            Viewing 4 reply threads
            • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.