About SQL

What is Sql?

Sql is the Core Language used to perform the operations on the data.Sql pronounced as "Sequel",is a
Language that is used to manage data in an RDMS.


The SQL Statements can be categorized as

Data Definition Language(DDL):is Used by to define the database,data types,structures,and contraints on the data,Some of DDL commands are

Create:Used to create a new data base object such as a table.

ALTER:Used to Modify the database objects.

Drop:Used to delete the objects

Data Manipulation Language:is used to Manipulate the data in the database objects.Some of the DML
                                                   Commands are:

INSERT:Used to insert a new data record in a table

UPDATE:Used to insert a new data record in a table

DELETE:Used to delete a record from a table

Data Control Lanaguage:is used to control the data access in the database

GRANT:Used to assign permissions to users to access a database object

REVOKE:Used to deny permissions to users to access a database object

Data Query language:is used to query data from the data base objects

SELECT is a DQL command that is used to select data from the
database in different ways and formats.

About JMeter

Introduction to JMeter


Apache JMeter is a powerful desktop performance tool from the Apache Jakarta
project, written in Java, for load-testing web pages, web applications, and other
static and dynamic resources including databases, files, Servlets, Perl scripts,
 Java Objects, FTP Servers, and more.


The main component in JMeter is the ‘Java Swing-based Graphical User Interface’
which can be used both for Scripting and Execution.


1)Excellent cost saving solution for small projects as it is an open source tool.

2)Robust in handling complex test scenarios that demand ‘n’ number of
virtual users


3)Complete portability and supports 100% all the Java based applications.


4)Less scripting efforts as compared to other tools because of its user
effective GUI.


5)Is used to conduct Load, Stress, Volume & Endurance tests on the
Web & Web-service based applications


6)HTTP & HTTPS load testing can be done without any adding
additional pluggable samplers.Since it is Java based, the tool was highly
 compatible with most of the Java based requests


Apache JMeter Limitations

1)Does not provide enough statistics: Most of the open source tools
(JMeter as well) does not provide the client side statistics summary reports
 in a presentable format as available with the other popular commercial
 tools such  as HP Load Runner and Borland Silk Performer.


2)Huge Log Files: Added to that JMeter provides the log details for every
 user and every iteration thus in turn causing the log files generated to be
very huge.

Time Consuming: Above all, creating the final customer presentable
summary report consumes huge amount of time.



3) Cannot collate the Running Vusers data correcly in a Distributed
Load Testing conducted using multiple Load Generators.

4)Cannot monitor the Server related components.

5)There is no feature which allows to pass all the requests concurrently
at the same time unlike in other commercial tools.



6) Ajax components cannot be interpreted bu jmeter

Features

1)The tool can spawn any number of records, transcending Excel’s 65K
or 1048K limitation.

2)Capable of collating the log files from multiple load generators
within fraction of mouse clicks.

3)The tool has a rich palette of features which allows the users to zoom,
print, merge and save the graphs.

4)The observations can be included in the same screen as the report
window, thus easing the task for the end user.

Benefits

1)The major benefit is one can drastically reduce the time consumed
in generation of elegant final summary reports.

2)Automated generation of both PDF and MS-Word which includes
elegant and sophisticated reports with all possible client side statistics
as any other popular performance testing tool.

3)No external database is required.

4)No more installations - simply unzip the file and start using it.
 Above all one can save one’s productive time.

Parameterization in Jmeter

Scenerio:-

When you want to execute one test plan for more than one user at the same time you go for parameterization
When user wants option to set multiple user with different values to the request

Follow the steps for the above scenerio
1)Give Http request





2)Thread group : Add : pre processors : use parameters



3)Add different variables like username,password

4)Add listeners to view request,username and password

Disadvantage with this parmeterization method

Time cosuming to set  credentials for  more than 100 users .To achieve this Follow

 Csv method which i posted in previous post.