[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

LazyWriter Memory Issues; Missing Tables

Posted on 2008-06-24
1
Medium Priority
?
496 Views
Last Modified: 2012-06-27
Our organization is using SQL Server 2005 Standard Edition.  We have recently been experiencing issues with the system, as it appears to run out of memory.  We have a maximum of 2147483647 MB of memory allocated (I  believe this is the default); AWE is not used to allocate memory.

We have found documentation which references the problems we have been experiencing, and most recommend to upgrade to Enterprise Edition, or state an upper memory limit which is approximately 75% lower than the systems memory (8 GB physical RAM, so we'd allocate 6 GB to SQL).

During the last incident when our system became unresponsive, we appeared to have lost several tables when the system was restarted.  This is what I am really interested in.  I believe several of the tables may have been in use when we began to experience errors.  It does appear that it took several hours for our system to become completely unresponsive.  

Any comments on the missing tables would be greatly appreciated.  I have already done a bit of research, but haven't found much insight as to why these tables are no longer in the database.

Thanks In Advance,

- Michael
0
Comment
Question by:mjs082969
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
mjs082969 earned 0 total points
ID: 21856446
We no longer believe that the memory problems were causing the loss of tables.  This appears to have been the result of another process.

Thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question