2

I have a Windows Server 2012 R2 configured for ASP.net applications that connect to SQL Server 2016 Express installed on the server. This server is a VPS with 3 cores and 1.5 GB RAM. The load on the server is not high at all.

I am having problems with the servers CPU Usage. Some seconds or minutes, as soon as I log in to the windows account through RDP, the SQL Server process starts consuming between 15% and 33% of CPU constantly, which is equivalent to using 1 CPU almost completely.

I first checked for running queries with SP_WHOISACTIVE and there are no running queries. (http://whoisactive.com/)

I then followed the instructions at: http://logicalread.solarwinds.com/troubleshoot-high-cpu-sql-server-pd01/#.V2xtwLvhCUk and have found that the culprit is “% User Time” when diagnosed by the performance monitor.

I have not been able to identify what the problem is after this point. All I know is that as soon as I log into the windows account, the CPU starts being consumed. As soon as I log off, the cpu usage of the process drop down to below 3%. Sometimes, while I am logged into windows, the cpu usage drops for some minutes, but it goes up again. I don't have to open any specific Windows application for this behavior to start.

Does anyone know what could be happening?

  • 2
    It might be ambitious to expect a virtual machine with only 3 cores and 1.5 GB of memory to happily run SQL Server and an RDP session. Probably especially true if the virtual host is overallocated itself. – Aaron Bertrand Jun 25 '16 at 14:42
  • Hi Aaron, I had been running the same apps with the the database (although with SQL Server Express 2005) in a Windows 2003 Server, and they worked fine for several years. It could be due to upgrading the server version and SQL Server Express version, but I'm not sure that's the problem. – David Ruiz Jun 27 '16 at 13:50
  • Same problem. I don't think it's ambitious to expect a machine like this to run SQL and an RDP. It worked fine with older versions of SQL. – Cheeso Jul 17 '16 at 16:08
  • Hi, I actually tried increasing RAM to 2GB two days ago. As soon as additional RAM was added the problem was solved. We are going to keep this server with the new RAM configuration. Thank you! – David Ruiz Jul 18 '16 at 16:57
0

as Aaron pointed above, the problem actually was related to having only 1.5 GB of RAM memory. The server was upgraded to 2 GB or RAM and the problem was solved.

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.