I have a medical office facility that has a Dell Windows SBS 2011 server with SQL 2008. They are using an SQL based patient scheduling app. At times, they complain that when they are in certain functions in that app on the client PC's that the app freezes up. An look at the Task Manager shows a process called "DataCollectorSvc.exe" labeled as "Windows SBS 2011 Standard Monitoring Data Collection Service" is taking about 15GB's of the total 32 GB memory installed.
I'm going to start doing regular scheduled restarts on this server to try and alleviate this issues, but does it sound right that the Data Collection Service should be taking that much memory? Could this process be not properly releasing memory?
They don't use the Exchange portion of the SBS so I have stopped all the Exchange processes. They are not hosting any local web sites or FTP usage or RDP via the server, but all the IIS stuff is still running.