New Installation on SBS2003 Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry - 19 Dec 2007 22:50 GMT

I just implemented BCM with SBS2003. I used the BusinessContactManager
2007DatabaseTool to share the Accounting Pro 2007 Database. Everything
installed correctly and the clients were able to link up to the Server
database using Outlook 2007 with BCM. The network became so slow that I had
to uninstalled everything. If I upgrade SQL 2005 Express will this fix the
problem? I have an HP ML350 with 4GB RAM, 10 users and an all gigabyte
network. Any sugguestion would be greatly appreciated.

Reply to this Message

Sat - 20 Dec 2007 01:27 GMT

Hi Jerry,

Do you already have SQL Server 2005? Database Tool will not slow down the
network. There can be some other reason which is doing the slow down.

Can you just see the performance of sharing with one or two users versus ten
users? Is that the problem?

-Sat

> I just implemented BCM with SBS2003. I used the BusinessContactManager
> 2007DatabaseTool to share the Accounting Pro 2007 Database. Everything
[quoted text clipped - 3 lines]
> problem? I have an HP ML350 with 4GB RAM, 10 users and an all gigabyte
> network. Any sugguestion would be greatly appreciated.

Reply to this Message

Jerry - 20 Dec 2007 03:03 GMT

Hi Sat,

I don't have SQL Server just Express version. I only used the tool to share
the existing accounting database and I only had one user using BCM but the
entire network was at a crawl. The BCM in Outlook 2007 was just fine but the
other accounting users were complaining about how slow it was posting entries
in the accounting system. Here is the alert I was receiving Alert on SERVER
at 12/18/2007 1:24:46 PM

The processor is experiencing a low level of idle time. Consistently low
levels of idle time can cause performance problems.

> Hi Jerry,
>
[quoted text clipped - 13 lines]
> > problem? I have an HP ML350 with 4GB RAM, 10 users and an all gigabyte
> > network. Any sugguestion would be greatly appreciated.

Reply to this Message

Lon Orenstein - 20 Dec 2007 14:26 GMT

Jerry:

With that many users on BCM, I would vote for BCM hitting the SQL on the
server as the problem. It does it once per second. The new SP1 has a way
to increase that frequency but they haven't told us how yet -- maybe Sat can
enlighten us. Using SQL Standard on your SBS box would help a lot also, I
would expect.

Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
Lon@pinpointtools.com
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com

> Hi Sat,
>
[quoted text clipped - 33 lines]
>> > problem? I have an HP ML350 with 4GB RAM, 10 users and an all gigabyte
>> > network. Any sugguestion would be greatly appreciated.

Reply to this Message