In my installation of SQL Server 2012 on my development machine (Win8.1), the process "SQL Server Windows NT – 64 Bit" is running continuously, using up disk resources and filling up my memory over time, even though I'm doing nothing. If I reboot the computer or restart the service called
SQL Server (MSSQLSERVER), then the memory allocation is reset and immediately begins to accumulate again.
How can I identify the operation that SQL Server is running to cause this usage? I don't recall changing any operations or configuration.
The problem is not just that memory is filled, but also that it continually uses half my disk operation speed (the "Disk" column in Task Manager Processes is at 50-75%). There appears to be an ongoing operation that perhaps has a memory leak. In other words, I am doing no activity and sitting watching the Task Manager and the memory is going up steadily.