what is benchmark testing?
When a system does not have data problems or user interface bugs, system performance will get much attention. The bad system performance can be found in benchmark testing.
Four issues must be included:
how are Integration tests done in SQL server?
Integration tests should be performed after the above component testing is done. It should call stored procedures intensively to select, update, insert and delete records in different tables and different sequences.
The main purpose is to see any conflicts and incompatibility.
what are backend testing phases?
There are several phases in back end testing. The first step is to acquire design specifications for an SQL server. The second step is test specification design. The next step is to implement the tests in this design with SQL code. The test specification design should contain information concerning component testing (individual pieces of the system), regression testing (previously known bugs), integration testing (several pieces of the system put together), and then the entire system (which will include both front and back ends).
Component testing will be done early in the development cycle. Integration and system tests (including interfaces to front ends and nightly processes) are performed after the component tests pass. Regression testing will be performed continuously throughout the project until it is finished. The back end usually does not have an independent beta test, as it only exercised by the front end during the beta test period. The last step is to deliver users a quality product.
Differences between back end testing and front end
testing?
It is not easier to understand and verify a back end than a front end because a front end usually has friendly and intuitive user interfaces.A back end has its own objects, such as, tables, stored procedures and triggers. Data integrity and protection is critical. Performance and multi-user support are big issues. Slowness in operation can be vital to the project’s future.
There are no sufficient tools for back end testing. SQL language is mainly a testing tool. MS Access and MS Excel can be used to verify data but they are not perfect for testing. However, there are a large number of test tools available for front end testing.To be able to do back end testing, a tester must have strong background in SQL server and SQL language. It is relatively difficult to find testers who understand both SQL server and SQL testing. This causes a shortage of back end testers.
How to do stress testing in backend?
Testing database under heavy loads.
eg: testing the table which has large number of records
used by number of users at the sam etime.
How to do boundary testing in backend?
To check the boundary conditions of columns.
How to do functional testing in backend?
A back end structure is divided into number of tests
based on application functionality.The tests focus input and output conditons but not structure or implementation.
what are pros of back end testing?
PROS:
1.The back end is no longer a “black box”
to testers. Many bugs can be effectively found and fixed in the early development stage. Take Forecast LRS as an example; the number of bugs in a back
end was more than 30% of total number of bugs in the project.
2.When back end bugs are fixed, the system quality is dramatically increased.
what is the importance of back end testing?
A back end is the engine of any client/server system. If the back end malfunctions, it may cause system deadlock, data corruption, data loss and bad performance. Many front ends log on to a single SQL server. A bug in a back end may put serious impact on the whole system. Too many bugs in a back end will cost tremendous resources to find and fix bugs and delay the system developments.
It is very likely that many tests in a front end only hit a
small portion of a back end. Many bugs in a back end cannot be easily discovered
without direct testing.
How to do testing for performance related issues?
Testing can be done whether indexes have been created on particular table or not,as indexes are used to increase
the performance.
Written by