Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

How can I identify SQL Server 2012 running background task that fills memory?

Asked by Brian Kennedy Jul 12, 2021 586 views 1 answer
Share

About this question

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 configurations. Edit: 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. What is  sql server windows nt?

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.