1

I know SQL Server will take up all memory on a server by design, but this is my desktop not a network server. What should I be looking at in terms of what they installed that needs to be changed so that I can work again?

I am running both SQL Server 2014 and SQl server 2008 SSMS as well as SSIS packages for both. I have no SSMS open and no are there programs besides this and task Manager Lync and my system is up to 94% of my memory being used just after a reboot. I never had this issue before they loaded 2014. But it has been continual since they did. I am sure there is some setting I need to change, but can't find anything on it as all the things I find seem to refer to how memory is handled on a server. It currently is running SQLServer.exe even though I have not opened SSMS since the reboot.

I have 6 GB of memory on an Intel Xeon CPU and Windows 7. It is an HP Z600 workstation.

Improve this question

1 Answer 1

Reset to default
3

SQL Server is set to start by default on system start. SSMS is just your management studio and not the SQL Server engine itself. You can set SQL Server service (services.msc) to manual, and set the maximum memory it can allocate lower if that is a concern to you.

Important: SSMS <> SQLServer.exe

Improve this answer
9
  • I pointed out that I had not opened SSMS because I had done nothing that should have made sqlserver.exe start which is the service running on my computer. Why would my desktop be starting sqlserver.exe? And how do I set the service to manual?
    – HLGEM
    May 9, 2017 at 18:13
  • To add, all the databases I use are on a server. I do not run any personal databases on my desktop;
    – HLGEM
    May 9, 2017 at 18:14
  • As I said, sqlserver.exe will start automatically, it is not "triggered" by opening SSMS. If a SQL Server Instance is installed, you'll see the sqlserver.exe service running, which, starts automatically. Check your services.msc under SQLServer, and you'll see the instance is running. SQL will run regardless of where the databases are, the service is installed and running on your desktop.
    – Henrico Bekker
    May 9, 2017 at 18:17
  • So what do I do to keep it from eating up all my memory so that I can't work?
    – HLGEM
    May 9, 2017 at 18:22
  • 1
    Start->Run->services.msc. Alternatively open SQL Server Configuration Manager.
    – Henrico Bekker
    May 9, 2017 at 18:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.