• GilaMonster - Monday, May 29, 2017 7:48 AM

    Something tells me that this is going to take a while...
    https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slow

    I threw in a few more things for them to check... not sure if my advice will be helpful or not, but that available MB being 800 MB (if I am reading that right... his number format is not what I am used to but I am pretty sure it is 813.957 MB... I have an odd feeling it isn't 813,957 MB but I could easily be wrong).
    They also did not provide any information on how much memory/CPU the system has, if the "very slow" was a gradual or sudden or always...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.