jump to navigation

SQL [sqlservr.exe] Memory Consumption on Small Business Server July 7, 2009

Posted by Gomez in IT, Microsoft, Performance & Alerts.
Tags: , , , ,

I started receiving alarms that pages/sec on my client’s SBS Server was 6952.92 pages/sec. Please note that Microsoft Best Practices recommends no more than 20 pages/sec.
I found that sqlservr.exe was consuming in excess of 1.5GB of memory. This is been a known issues for Servers running Small Business Server, I will walk you through the process of reducing usage for this memory thirsty process.

1. Open Task Manager > Processes Tab, View Menu > Columns, select PID check box.
2. In the list of processes locate the sqlservr.exe process that is consuming the most memory (there might be multiple instances of sqlservr.exe) take note of the PID number next to the memory thirsty process.
3. Open a command prompt and issue the following command without the quotes,
    “tasklist /svc” (this is used to display running processes (PIDs) and applications)
     next to the PID number previously identified in taskmanager take note of the service name.
   The service would be MSSQL$SBSMONITORING.

4. At the command prompt issue the following commands, after each command press enter;
 Command 1: osql -E -S SERVERNAME\sbsmonitoring  
(replace SERVERNAME with the hostname of your server, sbsmonitoring is the service name )
 Command 2: sp_configure ‘show advanced options’,1
 Command 3: reconfigure with override
 Command 4: go

Command 1: sp_configure ‘max server memory’, 200
(200 represent memory size in MB, replace 200 with any memory size you wish, default is 2147483648)
 Command 2: reconfigure with override
 Command 3: go

 After the last command “Go” you should see a confirmation that DBCC execution has completed. You can just type exit at the command prompt to exit.Open Task Manager > Process Tab and review the sqlservr.exe and confirm that memory usage has decreased.
Best of luck..

Small Business Server 2003 POP3 Connector April 19, 2009

Posted by Gomez in E-Mail, IT, Microsoft.
Tags: , , , , ,
1 comment so far

Small Business Server 2003 users that use the POP3  Connector Manager and are affected by that annoying 15 minutes download interval, finally there is hope, here is a registry tweak to drop the interval from 15 minutes to 5 minutes;

FIRST. Take a backup of your registry

1. Open Regedit
2. Navigate to HKEY_LOCAL_MACHINE/SOFTWARE/Micro­ soft/SmallBusinessServer/Network/P­OP3 Connector
3. Create a new “DWORD value” and type “ScheduleAccelerator” as the entry name
4. Select the DWORD and on the edit menu click modify, in the value box, type 3 and ensure the Decimal Radio button is clicked on the right.

(To determine the polling interval, the value that is configured on the “Scheduling” tab in the GUI is divided by the value that you type for the ScheduleAccelerator entry, example, if a 15 minute interval is specified in the GUI and you set the value of the ScheduleAccelerator entry to 3, the connector will poll ever five minutes, If you make it too short there can be problems with the POP3 connector starting a download before the previous download has started, it seems to work well with 5minutes)

5. Exit Regedit