December 12, 2010 at 10:56 pm
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply