Tuesday, September 3, 2013

[MS SQL Server] Memory settings in SQL SERVER

[MS SQL Server] Memory settings in SQL SERVER

Memory settings in SQL SERVER

Posted: 02 Sep 2013 04:45 PM PDT

I have 4GB Ram on OS and What will happen to my SQL server if i configure Min memory settings more than OS RAM that is 5GB and Max memory settings 6GB on SQL Server Memory settings.

sql server using more memory issue

Posted: 02 Sep 2013 07:12 AM PDT

sql server is 2008 r2 on 64 bit systems and os is windows 2008.Hi friends at one of our client side, it show sql server is using 12gb of ram out of 32 .my client is asking why sql is using this much.also there is not much hits on itcan any body tell queries which can tell me how much memory is sql server and its components are using with details description.They want to decrease its memory consumption i said its not possible once sql gets memory it doesnt release.but they are adamant.plz tell me solutioncan max memory server fix this problem , buy what if i set it and then sql server requires more memory .since its 64 bit setting awe wont help but does "lock pages in memory" and min max setting would be usefull.plz tell queries through which i can know what memory is begin used by sql server and its components like Bpool,others etc and all that.what other options/things i should check since database is of 2 gb so fragmentation is not an issue i think.plz helpregardsAnoop
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog