Memory problem

  • Just discard this post. Thanks!

  • I can't read memory dumps, so my question is what is running at the time you get these errors?

  • For example, dbcc checkdb (20-30G) or exec a stored proce, it gives out insufficent memory.

    Thanks for looking at this!

  • Too general, doesn't tell me anything. You need to figure out what was running on the system when it experienced the memory problem. How you do thin, I'm not sure off the top of my head. if it is occurring on a regular basis, you may want to setup a trace to see what is running when the next error occurs.

    I would need to do more research to tell you what to look for as this is not a problem that I have run into very often. I have seen it when we had poorly written queries (stored procedures) or SSIS packages.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply