One of the most common questions I receive is if there any tool available to generate load on SQL Server. Absolutely there is a fabulous free tool available to generate load on SQL Server This tool was released in 2008 but it is still extremely relevant to generate the load on SQL Server as well works fabulously.
FREE fully-featured visual database schema designer. Design database model online and generate SQL script with no coding or experience. SQL, MySQL, PostgreSQL, Oracle & SQLite modeling by DbDesigner.net.
The best part of this SQL Server Load Generator is that users can run multiple simultaneous queries again SQL Server using different login account and different application name. The interface of the tool is extremely easy to use and very intuitive as well.
One of the things which I felt needed improvement was a default configuration. As every single time when I was adding a query the default settings were showing up and I had to manually change that. However, when I went to Menu >> Tools >>Options I was really happy as it has options to change every single default which is available. Here one can give default username, password, database name as well various settings related to configuration. Additionally application logging is also possible through the options.
A couple of other important points I noticed was the button to reset counters as well status bar containing useful information of Total Threads, Completed Queries and Failed Queries. I use this frequently for my load testing. What tool do you use for SQL Server Load Generator?
Update: The original product link is moved so you will have to search on google now.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Objectives of the project:
- Registration
- Login
- Authenticating
- Updating Profile
- Posting a job and removing or modifying job
- Searching for a job
- Taking online exam
- Feedback
LITERATURE SURVEY
There are many applications developed related to this Online Job Portal, but, however, these systems are very complex for their own purpose. Most of them do not have the centralized database and easy access to users. So in this project, we are implementing this application through a centralized database and easy-to-use access for job seekers and job providers. The administrator is the primary actor to maintain the database, and also accepts comments from job providers and job seekers to improve and develop the application’s graphical user interface. Registered job seekers can also take the company online exam. In addition, qualified applicants can be classified according to this system based on their qualifications and company requirements.
Limitations
• The current Online Job Portal system is not a fully computerized and manual system for entering job candidates and job provider data and managing it.
• There is no centralized database maintenance
• There is no easy access to records of people seeking work in particular
• Job seekers can not easily navigate through the database
• There is no centralized database maintenance
• There is no easy access to records of people seeking work in particular
• Job seekers can not easily navigate through the database
![Db Generator Salar Codeplex Db Generator Salar Codeplex](/uploads/1/2/4/7/124726247/795024850.png)
Benefits
• It is a fully automated system for managing the Online Job Portal database
• This system provides centralized database maintenance
• This system provides easy access to certain job seekers or their complete details
This system gives job seekers easy to navigate through the application to get more information in the most secure way.
• This system provides centralized database maintenance
• This system provides easy access to certain job seekers or their complete details
This system gives job seekers easy to navigate through the application to get more information in the most secure way.
IMPLEMENTATION
5.1. MODULES
The system is divided into three major parts depending upon the requirement they are.
![Codeplex Codeplex](https://softwebtechnology.co.in/images/pay-online-payments-credit-cards.jpg)
- 1) Administrator
- 2) Job Provider
- 3) Job Seeker
Administrator
All the users are controlled by admin. Administrator services are
- view job providers
- view job seekers
- view feedback
Examination
The job providers prepared questions and update the providers and conduct examinations to the job seekers and also send the particular examination results.
And the job seeker searches the particular job then attends the exam and also views his results after completion of the exam.
Software Requirements:
Operating System: Windows XP/2003 or Linux/Solaris
User Interface: HTML, CSS
Client-side Scripting: JavaScript
Programming Language: Java
Web Applications: JDBC, JSP
IDE/ Workbench: Eclipse with My Eclipse Plug-in
Database: Oracle
Server Deployment: Apache Tomcat 6.0
Screen Shots:
- HOME PAGE
- LOG-IN PAGE
- ADMIN PAGE
- JOB PROVIDERS IN DB
- JOB SEEKERS IN DB
- FEEDBACK PAGE
- JOB PROVIDER PAGE
- UPDATE PROFILE PAGE
- ADD NEW VACANCY PAGE
- SEARCH JOB SEEKER PAGE
- RESULT PAGE FOR SEARCH JOB SEEKERS
- EXAM MANAGEMENT PAGE
- PREPARE EXAM PAPER PAGE
- PREPARING QUESTIONS PAGE
- ADDING QUESTIONS PAGE
- RESULT PAGE FOR SEARCH JOBS
- EXAM MANAGEMENT PAGE
- TAKING EXAM PAGE
TEST CASE REPORTS
Name of the page: Admin Login
Sno | TEST CASE | Expected Result | Actual Output | Remarks |
1 | New Admin logged on without sign in. | Should return a message sign in before log in. | Sign in First | Success |
2. | Invalid password | Enter correct password | Wrong password | Success |
3. | Invalid username | Invalid User | Enter valid name | Success |
4. | Special character entered in password field. | Verify your password | You Entered Invalid password | Success |
Name of the page: Job provider Login
Sno | TEST CASE | Expected Result | Actual Output | Remarks |
1 | New provider tried to log on without sign up. | Should return a message sign up before log in. | Failure | |
2. | Invalid password | Enter correct password | Wrong password | Success |
3. | Invalid username | Invalid User | Enter valid name | Success |
4. | Special character entered in password field. | Verify your password | You Entered Invalid password | Failure |
Job Seeker Login
Sno | TEST CASE | Expected Result | Actual Output | Remarks |
1 | New seeker tried to log on without sign up. | Should return a message sign up before log in. | Failure | |
2. | Invalid password | Enter correct password | Wrong password | Success |
3. | Invalid username | Invalid User | Enter valid name | Success |
4. | Special character entered in password field. | Verify your password | You Entered Invalid password | Failure |
Name of the page: Exam Management
Sno | TEST CASE | Expected Result | Actual Output | Remarks |
1 | Provider tried to add exam paper without scheduling | Schedule first | NULL | Failure |
2. | Seeker tried to write same exam again | exam already taken | Can Write | Failure |
3. | Displaying a message after time up in exam | Time up | Time up | Success |
4. | Selecting exam before scheduling date | Invalid test | NULL | Failure |