leonardrogan
asked on
SQL Server 100% CPU and High Memory Usage
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
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
ASKER
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.
Are you actually using the SQL server for your data, or is it just handling SBS / Sharepoint data?
ASKER
It will be handling a SQL database soon but at the moment it's just general SBS + Trend Micro ScanMail Database.
>> 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..
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..
>>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.
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.
ASKER
Doesn't answer the question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I answered this myself.
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..
>> Also make sure that OS, SQL Server are applied latest Service packs..
Is this what I have mentioned in the very first comment itself..
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...
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...
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..