Solved

SBS 2003 - SQL Memory issue.

Posted on 2011-03-13
3
1,014 Views
Last Modified: 2012-05-11
Have an SBS 2003 R2 Server that was having resource issues in regard to Virtual Memory errors and very large page files usage and so I have put an additional 2 GB in the server on the weekend, the server now has a total of 4GB memory and humming along nicely ;).

I have noticed this morning that SQL is taking 1.7 GB of RAM which seems excessive.

This Server has both the default MSDE instances and 2 Instances of SQL Express 2005, one for BPS and one for a Application that they run inhouse.

How to I limit resolve this issue ? is this in-fact an issue ?, or going to become one over time.. back to square one.
--

I Have now Resolved issue with thanks to
http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx

--
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>tasklist /svc

Image Name                     PID Services
========================= ======== ============================================
System Idle Process              0 N/A
System                           4 N/A
smss.exe                       660 N/A
csrss.exe                      820 N/A
winlogon.exe                   872 N/A
services.exe                   924 Eventlog, PlugPlay
lsass.exe                      936 HTTPFilter, kdc, Netlogon, NtLmSsp,
                                   PolicyAgent, ProtectedStorage, SamSs
svchost.exe                   1160 DcomLaunch
svchost.exe                   1536 RpcSs
svchost.exe                   1592 Dhcp, Dnscache
svchost.exe                   1644 LmHosts, W32Time, WebClient
aswUpdSv.exe                  1676 aswUpdSv
aswServ.exe                   1692 avast! Antivirus
svchost.exe                   1728 AeLookupSvc, BITS, Browser, CryptSvc,
                                   dmserver, EventSystem, helpsvc, HidServ,
                                   lanmanserver, lanmanworkstation, Netman,
                                   Nla, RasMan, RemoteAccess, Schedule,
                                   seclogon, SENS, ShellHWDetection, winmgmt,
                                   wuauserv
spoolsv.exe                    568 Spooler
msdtc.exe                      612 MSDTC
BBAttachServer.exe             852 BBAttachServer
bmds.exe                      1200 BlackBerry MDS Connection Service
BESAlert.exe                  1280 BlackBerry Server Alert
srvany.exe                    2220 Console Licence Service
dsm_sa_eventmgr32.exe         2236 dcevt32
dsm_sa_datamgr32.exe          2252 dcstor32
dfssvc.exe                    2268 Dfs
dns.exe                       2332 DNS
svchost.exe                   2392 ERSvc
inetinfo.exe                  2504 IISADMIN, RESvc, SMTPSVC
slsServer.exe                 2556 N/A
llssrv.exe                    2572 LicenseService
mr2kserv.exe                  2616 mr2kserv
sqlservr.exe                  2864 MSSQL$CONSOLE
--
sqlservr.exe                  2884 MSSQL$SBSMONITORING
-- Problem Service
sqlservr.exe                  2900 MSSQL$SHAREPOINT
sqlservr.exe                  3660 MSSQL$SQLEXPRESS
sqlservr.exe                  3800 MSSQL$WSUS
ntfrs.exe                     3876 NtFrs
dsm_om_shrsvc32.exe           3956 omsad
svchost.exe                    724 RemoteRegistry
retrorun.exe                  2388 RetroLauncher
sbscrexe.exe                   524 SBCore
dsm_om_connsvc32.exe          2488 Server Administrator
ShadowProtectSvc.exe          3432 N/A
ShadowProtectSvc.exe          3452 ShadowProtectSvc
OWSTIMER.EXE                  4796 SPTimer
sqlagent.EXE                  4852 SQLAgent$SBSMONITORING
sqlbrowser.exe                5004 SQLBrowser
sqlwriter.exe                 5028 SQLWriter
wins.exe                      5340 WINS
winvnc4.exe                   5384 WinVNC4
wsusservice.exe               5400 WsusService
BlackBerryController.exe      5588 BlackBerry Controller
BlackberryRouter.exe          5680 BlackBerry Router
tcpsvcs.exe                   5888 DHCPServer
exmgmt.exe                    6136 MSExchangeMGMT
wmiprvse.exe                  4964 N/A
mad.exe                       3480 MSExchangeSA
mssearch.exe                  5520 MSSEARCH
vsnapvss.exe                  5724 VSNAPVSS
svchost.exe                   5780 W3SVC
store.exe                     6320 MSExchangeIS
wmiprvse.exe                  6700 N/A
BlackBerryDispatcher.exe      7440 BlackBerry Dispatcher
ITAdminServer.exe             7480 BlackBerry Policy Service
BlackBerrySyncServer.exe      7932 BlackBerry SyncServer
imbservice.exe                8108 MSPOP3Connector
BlackBerryAgent.exe           5904 N/A
svchost.exe                   8184 TermService
svchost.exe                   5080 TapiSrv
csrss.exe                     8124 N/A
winlogon.exe                  7320 N/A
rdpclip.exe                   9224 N/A
ctfmon.exe                    9440 N/A
explorer.exe                  9472 N/A
BacsTray.exe                  9152 N/A
aswDisp.exe                   9268 N/A
sqlmangr.exe                  9332 N/A
mmc.exe                       9380 N/A
w3wp.exe                      8400 N/A
ShadowProtect.exe            10024 N/A
logon.scr                     9280 N/A
w3wp.exe                     11328 N/A
w3wp.exe                     12216 N/A
taskmgr.exe                   4700 N/A
BBConvert.exe                 6132 N/A
BBConvert.exe                12160 N/A
BBConvert.exe                10416 N/A
BBConvert.exe                 6124 N/A
cmd.exe                      11732 N/A
tasklist.exe                 10616 N/A

C:\Documents and Settings\Administrator>
C:\Documents and Settings\Administrator>osql -E -S SERVER\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
1> sp_configure 'max server memory', 70
2> reconfigure with override
3> go
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option 'max server memory (MB)' changed from 2147483647 to 70.
Run the RECONFIGURE statement to install.
1>


I assume the 70 is = 70 MB , so why is the Service now taking 118,236 K = 118 MB when I set to 70 MB ?

Should it not be using 70 MB Max ?
SQL-Memory.gif
0
Comment
Question by:it-pro
  • 2
3 Comments
 
LVL 95

Expert Comment

by:Lee W, MVP
Comment Utility
Did you run the SQL commands on ALL SQL instances?
0
 
LVL 2

Author Comment

by:it-pro
Comment Utility
No just the MSSQL$SBSMONITORING at this point in time.
Does that command work against the SQL Express 2005 as well as MSDE ?
0
 
LVL 95

Accepted Solution

by:
Lee W, MVP earned 500 total points
Comment Utility
Should work on all.  The instance that's still using the high amounts of RAM is likely one you haven't applied the update to.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

This guide is intended for migrating Windows 2003 Standard with Exchange 2003 to Windows Small Business Server 2008. You will need the following: Exchange Best Practice Analyzer: http://www.microsoft.com/downloads/details.aspx?FamilyID=DBAB201F-…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now