Bart's Weblog

Just a blog…

Allocated memory issue: sqlservr.exe

Posted by bartvdw on 2626/0101/2008

Recently I found on a SBS 2003 box a memory issue. After a quick look in my Task Manager I found that the process was called sqlservr.exe

Next step was finding the service linked to the process. “tlist.exe -s” (included in Debugging Tools for Windows) gave me the information needed: MSSQL$SBSMONITORING

What to do about that? Well after searching a little bit, I found this solution:

  • Open cmd
  • osql -E -S YOURSERVERNAME\sbsmonitoring [hit enter]
  • sp_configure ‘show advanced options’,1 [hit enter]
  • reconfigure with override [hit enter]
  • go [hit enter]
  • sp_configure ‘max server memory’, 70 [hit enter] (based on the information I found, this is OK)
  • reconfigure with override [hit enter]
  • go [hit enter]

Note: mind the quotes used! I have problems with publishing them correctly, so if you receive an error pointing into that direction, correct them manually in your syntax.

Cool link that helped me a lot:



Troubleshooting High Memory Usage by a MSDE Instance.

Adjusting SQL embedded instances

Thanks again Susan for the great post on this subject !!!


One Response to “Allocated memory issue: sqlservr.exe”

  1. […] Windows 2003 SBS? Might be worth checking our […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: