SBS 2008 Sqlservr.exe High Memory Usage

Open an Administrative Command Prompt.

Type:
osql -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Now at the SQL prompt, type:

1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go

The screen displays:

Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

Type:

1> sp_configure 'max server memory', 512
2> go

(NB The RAM usage of 512Mb is a suggestion, use whatever is appropriate in your environment.)

The screen displays:

Configuration option 'max server memory (MB)' changed from 2147483647 to 512. Run the RECONFIGURE statement to install.

Type:

1> exit

Restart the service, or reboot the server. The database instance may be opened in the management applet using the above notation.

Comments

  1. AliciaSeptember 6, 2011 at 3:36 PM

    hats of for you Daniel B.
    such a good, short, and comprehensive description of using high memory..
    keep it up

    ReplyDelete
  2. Daniel BSeptember 12, 2011 at 5:55 PM

    Thank you, Alicia

    ReplyDelete
  3. AnonymousJanuary 25, 2012 at 5:54 PM

    Thanks! - Worked like a Charm

    - SPN

    ReplyDelete
  4. Daniel BJanuary 25, 2012 at 6:02 PM

    Glad to hear it!

    ReplyDelete
  5. AnonymousMarch 28, 2012 at 4:43 PM

    Great Man, good solution.

    ReplyDelete
  6. AnonymousMay 7, 2012 at 10:24 PM

    This worked for me too. Thanks Daniel

    ReplyDelete
  7. Marcin WyrembakNovember 22, 2012 at 10:46 PM

    If sqlservr.exe is using huge amount of memory there is a reason behind. Forcing it to use less memory doesn't solve the problem.
    You should check files in C:\WSUS\SUSDB\UpdateServicesDbFiles as they are probably huge.

    ReplyDelete
  8. AnonymousFebruary 28, 2013 at 12:25 PM

    Wow, so simple, yet so effective
    Kudos

    ReplyDelete
  9. AnonymousAugust 13, 2013 at 3:44 AM

    but i have 2 sql proccess. one of them is x32. it solved only in one proccess. how can i change the ather one?
    it's sbs server 2008

    ReplyDelete

Post a Comment

Popular posts from this blog

Repair Windows 7 after removing a Linux partition (Dual Boot)

Image
I have seen the appear alot in the forums of people are running a dual boot scenario on their computers, dual-booting Windows with Linux, and no longer want the Linux system. Simply removing the paritions causes Windows to longer boot. In this article I explain how you can fix this problem.

In this article, I will show you how to repair Windows 7 after removing Ubuntu 11.10. Although, this will work regardless of the distribution of Linux you are using.




When you remove the Linux partition(s) you essentially remove the boot loader and screw up the master boot record. This need to be repaired for Windows to work again.

Contents
Removing the Linux PartitionsRepairing Windows Boot LoaderRemoving the Linux Partitions

Boot to Windows 7 and open Computer Management. Do this by either right-clicking My Computer and selecting Manage, or simple search for Computer Management from the Start Menu. Once open, select Disk Management.



Here you will see the layout of the Hard Drive. Right-click and del…
Read more

Office 365 ScanPST to fix corrupted Outlook files

Image
In Office 365, which uses the Click-to-Run technology, Office program files are now in a new location.


When you experience issues with Outlook, often you would use the ScanPST.exe tool to repair PST and OST files with Outlook.

This tool can now be found in the following location:

C:\Program Files\Microsoft Office 15\root\office15\ScanPST.exe
This should apply for both 32-bit and 64-bit installations of Office 365.

Update:

 Microsoft has published a Knowledge Base article list the locations of the ScanPST utility depending on your installation of Office 365. Whether you're using 32 or 64 bit versions.

https://support.microsoft.com/en-us/kb/272227


Read more

Switching/Moving from Evernote to Microsoft OneNote

Image
Update 4 (25-Apr-2016): Microsoft now provide their own tool for migrating you data from Evernote to Microsoft OneNote. See here: https://www.onenote.com/import-evernote-to-onenote

Update 3 (13-Apr-2014): A lot of people in the comments noted a recent issue with the software prompting for both Evernote and LinkedIn passwords unnecessarily. I won't be updating this post any further due to it's age and no longer recommending the conversion software.

Update 2: Microsoft have released a native client for Mac OS X. Also OneNote for Windows is detached from the Office suite and available for free.

Update: A lot of people had issues with this post in that it either they had issues or it did work at all. Problem here is that newer versions of OneNote may have issues with this process. There may be other issues that I am unable to test for.

When doing this guide, keep in mind that it will attempt to export to a new OneNote file. Each notebook in Evernote will become a new OneNote file. So…
Read more