Getting a lot of these errors all of a sudden

  • By default SQL server chew up to 1.7GB of ram from the physical memory. So even if your database is small; what it is doing is building up the buffer cache so it doesn't have to go to disk to get the information. Normal operations; unless you have the max memory set it will keep doing that.

    Doesn't mean that it needs the memory it just thinks that aa no one is using it so I'll take it until someone complains.

    That is why i suggest montering the counters; most likely this was just an issue of miss configuration on memory settings :).

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • Thanks Mohit.

    Our set-up is a complete mess - an essay in bad practice!

    At any rate, it seems to be running fine again now.

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

Viewing 2 posts - 16 through 17 (of 17 total)

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