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
SQL Server uses lot of CPU-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
Thread Forum
Robocopying an entire share from server to server gets error 2
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...
Backup and Restore
Offline Folder sync issue, Win 7 Client Server 2003 Flie Server.
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...
Network & Sharing
ďWe still donít encrypt server-to-server data,Ē admits Microsoft
Source A Guy
Security News
setting up a server for school help (windows server 2008)
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 -...
Network & Sharing
LAN network for server/client only, USB hotspot for server internet.
A friend is moving his business, and the new business park that he's setting up shop in does not have anyway to get any wired internet to his building, excluding a T1 line, which he can't justify the cost of. One windows 7 machine acts as the server, primarily for Quickbooks database, and there...
Network & Sharing
Windows 7 Computer can't see Server 2003 Server
We have a Windows 7 Pro laptop that can't see any of the 300 or so Windows XP and Windows Server 2003 Machines. It can, however, see all (around 13) Windows Server 2008 and Windows 7 Machines that are on the network. Using \\ServerName\Share doesn't connect, and they don't show up on the network...
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 00:24.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App