Multiple choice technology architecture

A batch program in SQL Server 6.5 takes 3 days to complete, even though management would like it to finish in 3 hours. What is a very likely cause of poor performance?

  1. Bad index management

  2. Network delay

  3. Use of SQL Server 6.5 instead of 7.0

  4. Limitations of Microsoft technology
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

For long-running batch operations, missing, fragmented, or poorly configured indexes are the most common cause of drastic performance degradation. Network delays or vendor limitations rarely account for a run-time disparity of 3 days versus 3 hours.

Keep practicing — related questions