question

Bhanupratap avatar image
Bhanupratap asked

SQL Server usages high memory and become non responsive

Hi, we are using SQL Server on AWS EC2 (4 core 16 GB). over the period of time its memory usages increases and when it reaches 90 % then it stops working . We have to manually restart server then its fine and this cycle continues after every 7-8 days.
sql2016
5 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.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Have you configured SQL Server's maximum memory setting? If so, what have you set it to?
0 Likes 0 ·
Bhanupratap avatar image Bhanupratap commented ·
memory is in its default setting to (2147483.647) GB
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Set it to a lower value - say, 12GB (12288MB) - and see if that helps.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
When it reaches 90% and stops working, what do you see? Any error messages?
0 Likes 0 ·
Bhanupratap avatar image Bhanupratap commented ·
I don't see any error messages but my application cannot connect to SQL and throws timeout
0 Likes 0 ·

0 Answers

·

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.