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

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

Deleting Office 365 Tenant

Image
For a long time now, I have been using trials to test new technologies at home that I can use for my work like every good tech does. With the introduction of Office 365, more and more I need to be able to test the clouds services for different scenarios. However, I like to completely remove any services that I am finished with an no longer need as a end-of-the-day clean up task. So how do you do this with Office 365? By default, once the trial subscription expires the tenant will remain active allowing you a chance to purchase a new subscription and assign to your tenant. In this case I know I will never need the tenant again. So this is what I have found to decommission a Office 365 trial tenant using Azure Active Directory. WARNING! Please triple check that you are doing this on the correct tenant. This deletion is unrecoverable. You do this at your own risk. Prerequisites Before you can start this process you need to make sure: All subscriptions are d
Read more

HP LaserJet P3005 Cold Reset

Image
To perform a factory / hard / cold reset on a HP LaserJet P3000 Series printer wasn't that straight forward in my eyes. Although in the menus there was an option for Reset Factory Defaults, this did very little in erasing the configuration and returning the printer to a default state. After reading through a few manuals I found the following performed what HP call a Cold Reset. Cold reset A cold reset unlocks menus that have been previously locked and sets all control panel menu items(including EIO settings) back to the factory defaults. However, it does not clear the values in the SERVICE menu (such as the serial number and page counts). NOTE    Before performing a cold reset, print a menu map and a configuration page. Use the information on the configuration page to reset any customer-set device configuration values that the cold reset procedure changes. Turn the device off. Turn the device on. When the memory count begins, press and hold the green Check butto
Read more