The installation of Microsoft SQL Server is very straight forward with usually little changes to be made as most of the default options are what most users will need. Some applications require these default options to be changed in order to perform at optimal levels. Kronos and Microsoft recommend the following configuration changes be made to your SQL Server instance to ensure optimal performance of the Workforce Central Suite:
* If you are using Microsoft SQL Server 2008 (or 2008 R2) Enterprise Edition or greater
Using the "non-default" best practices discussed in this post for SQL Server can help optimize performance of Workforce Central and can help you avoid and minimize problems.
Check out the Kronos and SQL Server Best Practices white paper for more information
For Kronos and Microsoft news, events, and further information, see the Kronos and Microsoft Alliance page.
Follow Tier1OnSQL on Twitter