Indexes increase selection speeds but impede update and insertion performance. Identify those fields that really need to be indexed and eliminate those that don't. Times of heaviest workload. All business intelligence systems experience peaks and valleys of demand. Manage peak loads and justify infrastructure expenditures by identifying your heaviest resource consumption times by hour, day, week, or month.
Users often request more data than is necessary.
Identify these users so you can target them for education or provide an alternate data delivery method. Find your most resource-intensive applications, queries, and reports so you can create a list of items to be optimized. Frequency of use. Determine which applications, queries, and reports run most frequently to prioritize your optimization work. Monitor trends to justify server upgrades, measure consumer buy-in, or forecast and manage scalability.