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:
http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx

 

Update

Troubleshooting High Memory Usage by a MSDE Instance.
http://blogs.technet.com/asksbs/archive/2008/07/05/troubleshooting-high-memory-usage-by-a-msde-instance.aspx

Adjusting SQL embedded instances
http://msmvps.com/blogs/bradley/archive/2007/12/25/adjusting-sql-embedded-instances.aspx

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

Advertisements

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

  1. […] Windows 2003 SBS? Might be worth checking our https://bartvdw.wordpress.com/2008/01/26/allocated-memory-issue-sqlservrexe/ […]

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: