Any SQL/BCM Performance Tips?

  • Thread starter Thread starter Jorge
  • Start date Start date
J

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!
 
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!
Click to expand...

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.
 
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!
Click to expand...

?What about the polling interval?
 
janK said:
Jorge schreef:

?What about the polling interval?
Click to expand...

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
 
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
Click to expand...
Thanks !
 
Back
Top