SQL Server uses lot of CPU


  1. MikelMolto
    Posts : 8
    XP Pro and Windows 7
       New #1

    SQL Server uses lot of CPU


    Hello All,
    didn’t know where to put this.

    As I watch and log the temperatures from my system I was surprised, when I found out that the temperature of my CPU sometimes went up even no software is running.
    After checking it for a while, I found out that sqlservr.exe uses the most of the CPU time and sometimes (about every 3-4 Minutes) he is the reason for this increase of the CPU Temperature. The CPU go every 3 Min. for about 4 seconds up to 80%.
    I wonder what sqlservr.exe is doing (with no software running)!?
    Didn’t have this behaviour in XP Pro with the same Software installed then now in Windows 7.


    SQL Server was installed together with Microsoft Visual Web Developer 2008 Express Edition. The name is MSSQL$SQLEXPRESS

    See also attached Image.

    Regards Mikel
    Attached Thumbnails Attached Thumbnails SQL Server uses lot of CPU-sql1.jpg  
    Last edited by MikelMolto; 28 Jan 2009 at 00:43.
      My Computer
    Quote Quote

  3. MikelMolto
    Posts : 8
    XP Pro and Windows 7
    Thread Starter
       New #2

    After I changed from 2x1G RAM 800 to 2x2G RAM 1066 SQL Server stopped doing what he did. I believe Windows 7 64bit need at least 4G RAM to make sense.
    Problem solved.

    Regards Mikel
      My Computer
    Quote Quote

 

  Related Discussions
I've run into an issue several times when trying to copy an entire share from one server to another. In this case, it happens to be from a Mac to a Windows server (just in case that's relative to the problem). The command I was using is: robocopy \\MacDASD\Boards \\SRVRWIN78\Boards /S /FFT /XJ...
Read more: Windows Server 2016 leaks reveal Nano Server, protected VM role plans | ZDNet
Hi, I am having an issue with offline files created offline syncing back to the server. I have set up a network share to be available offline on a client computer. All files are available offline without issue. Here is the issue however. If I set the folder to work offline any file I create in...
As my final project for the year i am setting up a server that we will eventually move all our computers on to. I am using a poweredge 2900 as a server with windows server 2008 installed. As of now i have 2 computers connected to the domain which they can log on to. - what i need help with -...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 16:57.
Find Us