TRITECH SOFTWARE SYSTEMS -2015 - Laserfiche WebLink

Home Browse Search

Chapter 3 - System Components 9.1.3 DATABASE RE -INDEXING Re -indexing is of particular importance to your site. Database growth and the data archiving process can cause indexes to be progressively less effective. This affects the speed at which data is retrieved and ultimately slows down your system. TriTech recommends that customers re -index their system frequently. Large customers, especially those that aggressively archive data, should closely monitor data fragmentation and may need to re -index daily or weekly depending on the index fragmentation level and their performance requirements. When using SQL Server Standard Edition, the re -indexing process currently requires the system to be taken offline. This is especially important for sites that utilize the archiving feature of the Archive and Reporting Server and for high call volume sites. Depending on the level of fragmentation their might be a need to regularly take the system offline to perform a database reindexing maintenance to maintain an acceptable database performance level. SQL Server 2008 Enterprise Edition introduces the ability to re -index you databases without taking the system offline and running a manual re -index— however, this important feature is only available in the Enterprise version. Please note that even with the Enterprise Edition there are certain tables that cannot be re -indexed online due to limitations of SQL Server data types. Even though re -indexing online is an option with Enterprise Editions, some performance degradation may be experienced and as such, even online re -indexing operations should be scheduled around non -peak usage times. Each customer will need to determine the relative value of this feature compared to the additional cost of the enterprise version of SQL Server. TriTech recommends that sites with a large number of workstations and/or high call volume implement the enterprise version of SQL Server in order to take advantage of this important capability. TriTech has implemented a reindexing job that will run daily/weekly for each CAD database depending on the client's performance requirements. The job will defragment the indexes based on fragmentation threshold daily and rebuild the indexes weekly (Enterprise version will attempt to do Online indexing; Standard version will only defragment the indexes). It is recommended that job be implemented in low user activity window to limit the performance impact that the process may induce. 9.1.4 DATABASE SERVER AND DOMAIN CONTROLLER FUNCTIONS TriTech does not support utilizing the Database Server as a Domain Controller. Doing so raises security and performance issues. Domain Controllers are typically nm with a privileged account, which could conceivably allow an attacker access to the Active Directory. Running a Database Server on a Domain Controller can increase resource demands and degrade performance of the SQL Server. Finally, SQL Server is not supported on a read-only domain controller. Inform CAD Business/Interface Servers (for most installations) operate a mixture of Microsoft and TriTeeh applications. With the availability of more powerful servers (with and without virtualization), there is now an opportunity to consolidate server based applications and servers used for your Inform CAD -Inform System. For customers desiring to minimize the number of physical servers, TriTech recommends the use of more powerful servers for Inform CAD Business/Interface Servers —we refer to these as Multi -Application Servers (specifications below). Standard servers can be utilized (specifications below), but more resources may be needed to operate the system. The contents of this material are confidential and proprietary to TriTech Software Systems, Inc. and may not be reproduced, published or disclosed to others without the prior written consent of TriTech Software Systems, Inc. ©2015 TriTech Software Systems