SalesLogix 7.5.2 Speed Issues – How To Find the Slowdown

At times I have been asked how can I increase the performance of SalesLogix. For systems using SQL2005 or SQL2008 the slowdown may be corrected by adding an index to the table that the SalesLogix script queries. The trick is finding where the bottleneck resides. My suggestion is to use the SLXProfiler when a significant slowdown occurs and record the sql logs. Then examine those logs for queries that take significantly longer. For example, one query on the history table was taking 871.3167 milliseconds to execute while the average time for other queries on history table were under 5.0 ms. How do we improve this performance lag? One way is to minimize the amount of history distributed to remote users and another way is a custom index. Next week’s topic will discuss the steps to create that index.