Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: SQL Server uses lot of CPU

27 Jan 2009   #1
MikelMolto

XP Pro and Windows 7
 
 
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
-sql1.jpg  
My System SpecsSystem Spec
28 Jan 2009   #2
MikelMolto

XP Pro and Windows 7
 
 

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 System SpecsSystem Spec
Reply

 SQL Server uses lot of CPU




Thread Tools



Similar help and support threads for2: SQL Server uses lot of CPU
Thread Forum
Offline Folder sync issue, Win 7 Client Server 2003 Flie Server. Network & Sharing
Server 2008 for home server... Opinions please. Network & Sharing
LAN network for server/client only, USB hotspot for server internet. Network & Sharing
Windows 2008 Server or Linux for server Network & Sharing

Our Sites

Site Links

About Us

Find 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 03:01 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App