question

anu.elza avatar image
anu.elza asked

SQL server 2014 is slow before restart it

Hi all, Thanks in advance. Sorry for my language because I am not a native English speaker.I got a problem with my SQL server 2014. my SQL Server is down randomly until restart it. No blocking queries and background processes are there. I don't know what is the problem with that server. The PLE value at that time is decreased to 0. The server will remain under this condition until restart it. After restart it everything is back to normal. But this problem will occur again after a couple of weeks
performancesql-server-2014
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.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
How much memory does your SQL Server have? How much memory is SQL Server configured to use? What else is running on that server?
3 Likes 3 ·
JohnM avatar image JohnM commented ·
I'm going to add to @ThomasRuston's list. Is the SQL Server a physical or virtual machine?
2 Likes 2 ·

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.