When databases get large, it becomes important to begin to pay attention to the indexes on the larger tables in the SIF agent database, especially if you begin to see the performance of the agent decreasing.
Checking Index Performance
The SQL Server Management Studio (SSMS) has some built-in reports that can help you determine if you have the proper indexes created and if the ones that ahve been created are being used at all. When we (at Visual Software) release a new version of an agent, we make some guess as to how an agent will be used based on usage information we an gather from other installations. This doesn't mean, however, that it will be the best for the information that the agent manages from your organization — that will depend on the information that is maintained at your organization, how it is stored and how it is used. For example, we may make an assumption that an average student may have a home address, a single home phone number and a single email address. We create the tables that store this information to optimally store information this way. Your organization may typically store three phone numbers and two email addresses for each student and the subscribing applications in your zone may frequently make requests for this information. Because of these differences, you may want to add other indexes to the tables RE_PhoneNumber and RE_Email where the phone numbers and email addresses are stored. To check the performance