Solved

SBS 2003 - SQL Memory issue.

Posted on 2011-03-13
3
1,034 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 96

Expert Comment

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

Author Comment

by:it-pro
ID: 35125358
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 96

Accepted Solution

by:
Lee W, MVP earned 500 total points
ID: 35125382
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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