New Installation on SBS2003 Help!

[Jerry]

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.

 

[Sat]

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

 

[Jerry]

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.

 

[Lon Orenstein]

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
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com