question

ramesh 1 avatar image
ramesh 1 asked

sql server 2008 memory consumption

hi team, we are using sql server 2008 , with windows 2008 server as our operating system .both are of 64 bit .these days i can find RAM memory is mostly consumed by the by sqlservr.exe. it generally grows up and never comes down.please help me
sql-server-2008memory
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Blackhawk-17 avatar image
Blackhawk-17 answered
Ramesh, Unless I am missing something the answers will be the same as your other question: [Ramesh's Memory Usage Question][1] [1]: http://ask.sqlservercentral.com/questions/15447/sqlservrexe-memory-goes-on-increasing-and-never-comes-down
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg avatar image Oleg commented ·
He might be looking for a possible source of a database server abuse which they probably have going (leading to non-stop increase of memory usage for some unknown reason), but without knowing about details, it would be impossible to figure out :(
0 Likes 0 ·
Blackhawk-17 avatar image Blackhawk-17 commented ·
You are correct. I guess we will have to wait for more details.
0 Likes 0 ·
David 1 avatar image
David 1 answered
This is normal behaviour. Like all DBMSs SQL Server works best with lots of RAM. It will use as much as it can if that memory isn't required for anything else.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
Hello Ramesh Set your Max Server Memory option to appropriate value using sp_configure stored procedure for reference See this post http://ask.sqlservercentral.com/questions/15447/sqlservrexe-memory-goes-on-increasing-and-never-comes-down?page=1#15456
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.