Any SQL/BCM Performance Tips?

[Jorge]

My organization will be using a server to share the database for BCM using
the admin tool.

Is there any SQL/BCM suggestions that will help increase performance and/or
keep BCM stable on the server and client end?

I know the polling interval is one of them.

Thanks!

 

[Luther]

My organization will be using a server to share the database for BCM using
the admin tool.

Is there any SQL/BCM suggestions that will help increase performance and/or
keep BCM stable on the server and client end?

I know the polling interval is one of them.

Thanks!

There should be enough memory on the server so that sql doesn't need
to page memory to disk. The next bottle-neck with sql will be disk IO,
a faster faster harddisk will help there.

On thing you can do without new hardware terms, is ensure that you
empty the deleted items folder. Everything in that folder consumes the
same number of resources. So, if you don't need those records, delete
them, and the table indexes, etc., will be faster.

 

[janK]

Jorge schreef:

My organization will be using a server to share the database for BCM using
the admin tool.

Is there any SQL/BCM suggestions that will help increase performance and/or
keep BCM stable on the server and client end?

I know the polling interval is one of them.

Thanks!

?What about the polling interval?

 

[Jorge]

Jorge schreef:

?What about the polling interval?

Basically every computer with BCM is setup to check any changes made on the
SQL server (the computer hosting the database) to synchronize. If I'm not
mistaken, by default BCM checks every second which could be unnecessary
depending on your needs.

Here is a couple of links that explain and how to change this:

http://blogs.msdn.com/bcm/archive/2008/01/23/how-to-change-bcm-polling-interval.aspx

http://officepoint.blogspot.com/2008/09/improve-outlook-bcm-business-contact.html

 

[janK]

Jorge schreef:

Basically every computer with BCM is setup to check any changes made on the
SQL server (the computer hosting the database) to synchronize. If I'm not
mistaken, by default BCM checks every second which could be unnecessary
depending on your needs.

Here is a couple of links that explain and how to change this:

http://blogs.msdn.com/bcm/archive/2008/01/23/how-to-change-bcm-polling-interval.aspx

http://officepoint.blogspot.com/2008/09/improve-outlook-bcm-business-contact.html

Thanks !