Software Performance Testing and Optimization
Questions about performance testing, troubleshooting, optimization, capacity planning, and performance metrics for software systems
Questions
A DBMS has a data cache hit ratio of 10%. What will you do to improve performance?
- Change the application code
- Do nothing
- Run every query twice
- Increase cache size significantly
A database of personal contacts is best implemented on
- A mainframe
- A Unix workstation
- A personal computer
- A massively parallel supercomputer
A claims processing system has had 5,000 requests made in the first hour and 4,900 requests have completed in the first hour. What is the number of requests pending in the claims processing system at the end of the first hour?
- 5000
- 100
- 4900
- 5
Approximately how much time does it take to transfer a 1 GB file over a 10 Mbps Ethernet LAN? Assume 20% degradation in bandwidth because of Ethernet overheads ?
- 1 hour
- 30 minutes
- 15 minutes
- 5 minutes
A customer's test server has 50% resources (Memory, CPU) compared to production server. What is your recommendation to carry out a performance test on a test server
- No need to do a performance test as test and production servers are not similar
- Recommend the customer to upgrade the test server equivalent to production server proir to the performance test
- Carry out the performance test with 50% anticipated production load
- Carry out the performance test with 100% anticipated production load
An application discovered performance issues though it was performance tested proir going live. Pick probable reason(s) why the performance issues were not discovered during testing
- Concurrent users defination unclear
- Test data not suffeciently populated
- Test & prod environments differ significantly
- Network bandwidth not simulated
- All of the above
Which of the below cannot remediate a performance problem associated with system memory (RAM)
- Cache frequently accessed data in system memory
- Dedicate system memory to specific tasks
- Add additional memory
- Create additional instances for parallel processing and load balancing
All of the below are potential to remediate oerformance problems associated with Network interface except
- Increase bandwidth
- Reduce packet size
- Add accelerator hardware when transporting secure data
- Improve performance on nodes within the network so the data is more readily available
1000 records of New India Insurance need to be transferred over a remote link from Jamnagar to Mumbai. Which of the following will deliver best performance?
- Transfer all records in one batch send
- Send one record at a time
- Compress all 1000 records into one message and send
- Compress one record at a time and send
An internet trading system with 64 Kbps lines to end users has been web enabled. The average web page size is 40 KB. Users are complaining about response times exceeding 2 seconds. What would you recommend as an immediate possibility to improve performance?
- Tuning of DBMS
- Tuning of web server
- Ask users to work at nights
- Use of a web booster such as Citrix or NetScaler
Rise in page reads per sec indicates
- Disk bottleneck
- Memory bottleneck
- Processor bottleneck
- Network bottleneck
Rise in percentage of disk time indicates
- I/O bottleneck
- Memory bottleneck
- Disk bottleneck
- Network bottleneck
A sustained increase in memory utilization of a process after start up signals
- Insufficient memory
- Hardware issue
- Leak
- Improper configuration
If an application is running slowly, which of the following is true?
- You can always improve performance by using more CPUs
- You can always improve performance by using more RAM
- You can always improve performance by using more disks
- None of the above
Once a system has been tested and tuned for performance
- It will never face a performance problem again
- It will have a performance problem if system grows
- It can have a performance problem if system grows
- It will have a performance problem only if application changes
You are approached to review an application code having performance issues. It is estimated that the code review will take 1 person year to go through all the code line by line. What is your recommendation in this scenario
- Take up the work and complete the review in estimated time
- Ask the customer to find exactly which part of the code has performance issue
- Take customers help to identify the portion(s) of the code that potentially have performance issues
- Recommned to use an automated tool to review the code to complete in quick amount of time
Performance problems are more likely in
- OS & HW
- Database
- Program
- Design
An end user of an online car dealer is facing poor response. The car dealer checks with the system administrator and is told that there is no problem in the web or DBMS servers. Which of the following is likely to be true?
- The system administrator is telling a lie
- There is a delay either at network or client PC or both
- The problem will get solved upon reboot
- Network capacity will need to be upgraded
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?
- Bad index management
- Network delay
- Use of SQL Server 6.5 instead of 7.0
- Limitations of Microsoft technology
A load testing tool consumes 2MB per virtual user. In a benchmark with 1000 virtual users how many machines would you require. Assume 50MB for OS and other utilities (per machine).
- 10 machines of 256 MB
- 5 machines of 256 MB
- 10 machines of 128 MB
- 15 machines of 128 MB