Solved

SQL Server 100% CPU and High Memory Usage

Posted on 2010-09-09
11
755 Views
Last Modified: 2012-05-10
Hello Folks,

Just installed a SBS 2008 premium box (64bit).  Basically run up fine.  Did a few updates, whammo, cpu and memory through the roof for SQLservr.exe .

Now I've come across this before and found an article that suggested a command line command that fixed this up. Essentially telling the box to process what it needed to do and be done with it and that worked, fixed it completely.  Now I can't find this article.  Was a simple command from the command prompt.  

Does anyone know what this is?

Cheers In advance
0
Comment
Question by:leonardrogan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33643692
not sure what you are actually referring to..
But you can set the Max Server memory for SQL Server so that it won't utilize high memory usage and 100% CPU usage.
Is that you are referring to..

Also make sure that OS, SQL Server are applied latest Service packs..
0
 

Author Comment

by:leonardrogan
ID: 33643764
No, there is a command that you can tell SQL to process items just after it was installed following some windows updates when the symptoms occur.

0
 
LVL 7

Expert Comment

by:rsimsee
ID: 33643793
Are you actually using the SQL server for your data, or is it just handling SBS / Sharepoint data?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:leonardrogan
ID: 33643862
It will be handling a SQL database soon but at the moment it's just general SBS + Trend Micro ScanMail Database.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33644679
>> SBS + Trend Micro ScanMail Database.

Both SBS and Exchange server are resource intensive applications and hence its recommended not to install SQL Server on this server as SQL Server again needs more memory to function properly..
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33653561
>>Did a few updates, whammo, cpu and memory through the roof for SQLservr.exe .<<
This is by design and should not present a problem in standard SQL Server installations.  If you are not going to follow recommended practices and share the server with other applications than you can cripple SQL Server by setting the max memory used.
0
 

Author Comment

by:leonardrogan
ID: 33654717
Doesn't answer the question.
0
 

Accepted Solution

by:
leonardrogan earned 0 total points
ID: 33654775
Some more Windows Updates fixed the CPU Utilisation.

I then used the SQL Management Tools to limit the amount of memory that the SQL SBSMonitoring Database.

Hope this helps someone else.
Ta.
0
 

Author Closing Comment

by:leonardrogan
ID: 33654781
I answered this myself.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33658540
leonardrogan,

>> Also make sure that OS, SQL Server are applied latest Service packs..

Is this what I have mentioned in the very first comment itself..
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33658782
rrjegan17,

Of course you did and we also told him/her that they could limit the memory used by MS SQL Server, so the fact they did not wish to even reward our efforts let alone acknowledge them, speaks volumes about them.  But I strongly suspect they will be back and when they don't get any valuable answers they will be the first to complain to CS "I subscribe here and pay money to have experts help me", forgetting that what goes around come around...
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question