Post reply

SQL Server 2008 R2 eating 500 MB on server.

  • December 12, 2010 at 10:56 pm

    #242392

    I am newbie admin need help in stopping resource being eaten up by SQL Server 2008 R2 ,

    I am an experienced SQL designer/developer but a newbie at server administration and my current server is eating about 500mb's on my prod server where as on my dev it is only eating about 100MB space , I have no idea why this is happening. If someone could provide some pointer in basic sql admin specifically for such scenario's it would really help me thanks.

  • December 13, 2010 at 12:42 am

    #1261546

    SQL is a memory hog, the more memory it can get, the better. That said, 500MB memory is nothing for a production server. If I had to guess, I'd say you're using task manager to check, and that usually shows wrong for SQL Server.

    How much memory is on the server and what other apps are on the production server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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