Solved

LazyWriter Memory Issues; Missing Tables

Posted on 2008-06-24
1
484 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
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

919 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now