SBS2008 Monitoring and Reporting SQL
|
Prev: SMTP Event Sink not firing
Next: SBS 08 Premium - Way to install exchange management console on another system?
From: MattK on 21 Apr 2010 12:11 I have an SBS2008 box is is consistently have high CPU usage and memory usage from the SQLSERVR.exe *32 process. It will grab 15 percent of the cpu for long periods of time and consitently run at about 600,000-800,000k of memory. The process is the SBS Monitoring and Reporting Instance for SBS. I have ran the SBS BPA against this server and the only warnings I now get are the Update services not set to default, a PTR record problem, IE Enhanced security disable and some user accounts that don't show in SBS Console. The server is configured as follows: Dell PE2900 with 2 - E5430 Processors 8GB Ram OS installed on Mirrored Set All other data on separate Raid 5 Set On our SBS 2008 box SBS Monitoring is only using about 60000k and i never see it spike the cpu. Its configured similarly except with 12GB of ram. Does the SBS 2003 trick of limiting the amount of memory for the sql instance still apply in SBS08 and if so what is a good setting? Thanks Matthew Konkol M/T Box Computers, Inc
From: Chris Puckett [MSFT] on 21 Apr 2010 14:33
I suggest doing this first. http://blogs.technet.com/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx -- Chris Puckett This posting is provided "AS IS" with no warranties, and confers no rights. "MattK" <matt(a)mtboxcomputers.com> wrote in message news:acfa3677-be16-4d39-9642-5d1f7d87e12d(a)i40g2000yqd.googlegroups.com... > I have an SBS2008 box is is consistently have high CPU usage and > memory usage from the SQLSERVR.exe *32 process. It will grab 15 > percent of the cpu for long periods of time and consitently run at > about 600,000-800,000k of memory. The process is the SBS Monitoring > and Reporting Instance for SBS. > > I have ran the SBS BPA against this server and the only warnings I now > get are the Update services not set to default, a PTR record problem, > IE Enhanced security disable and some user accounts that don't show in > SBS Console. > > The server is configured as follows: > > Dell PE2900 with 2 - E5430 Processors > 8GB Ram > OS installed on Mirrored Set > All other data on separate Raid 5 Set > > > On our SBS 2008 box SBS Monitoring is only using about 60000k and i > never see it spike the cpu. Its configured similarly except with 12GB > of ram. > > Does the SBS 2003 trick of limiting the amount of memory for the sql > instance still apply in SBS08 and if so what is a good setting? > > Thanks > Matthew Konkol > M/T Box Computers, Inc |