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

more ▼

asked Aug 09, 2017 at 08:05 AM in Default

avatar image


How much memory does your SQL Server have?

How much memory is SQL Server configured to use?

What else is running on that server?

Aug 09, 2017 at 10:46 AM ThomasRushton ♦♦

I'm going to add to @ThomasRuston's list.

Is the SQL Server a physical or virtual machine?

Aug 10, 2017 at 01:58 PM JohnM
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 09, 2017 at 08:05 AM

Seen: 42 times

Last Updated: Aug 10, 2017 at 01:58 PM

Copyright 2018 Redgate Software. Privacy Policy