{"id":58008,"date":"2017-07-10T15:18:37","date_gmt":"2017-07-10T09:48:37","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?p=58008"},"modified":"2024-04-12T14:20:36","modified_gmt":"2024-04-12T08:50:36","slug":"jmeter-tutorial-building-database-test-plan","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/","title":{"rendered":"BUILDING A DATABASE TEST PLAN"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/12\/Certified-Protection-Professional-CPP\u24c7-8-1-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/12\/Certified-Protection-Professional-CPP\u24c7-8-1-1.png\" alt=\"BUILDING A DATABASE TEST PLAN\" class=\"wp-image-96162\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/12\/Certified-Protection-Professional-CPP\u24c7-8-1-1.png 750w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/12\/Certified-Protection-Professional-CPP\u24c7-8-1-1-300x160.png 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/figure><\/div>\n\n\n<p><strong>BUILDING A DATABASE TEST PLAN-<\/strong> In this section, you will learn how to create a basic Test Plan to test a database server. You will create fifty users that send 2 SQL requests to the database server. Also, you will tell the users to run their tests 100 times. So, the total number of requests is (50 users) x (2 requests) x (repeat 100 times) = 10&#8217;000 JDBC requests. To construct the Test Plan, you will use the following elements: Thread Group, JDBC Request, Summary Report.<\/p>\n<p>This example uses the MySQL database driver. To use this driver, its containing .jar file (ex. MySQL-connector-java-X.X.X-bin.jar) must be copied to the JMeter .\/lib directory (see JMeter&#8217;s Classpath for more details).<\/p>\n<h5><strong>Adding Users<\/strong><\/h5>\n<ul>\n<li>The first step you want to do with every JMeter Test Plan is to add a Thread Group element. The Thread Group tells JMeter the number of users you want to simulate, how often the users should send requests, and how many requests they should send.<\/li>\n<li>Go ahead and add the ThreadGroup element by first selecting the Test Plan, clicking your right mouse button to get the Add menu, and then select Add &#8211;&gt; <strong>ThreadGroup.<\/strong><\/li>\n<li>You should now see the Thread Group element under Test Plan. If you do not see the element, then &#8220;expand&#8221; the Test Plan tree by clicking on the Test Plan element.<\/li>\n<li>Next, you need to modify the default properties. Select the Thread Group element in the tree, if you have not already selected it. You should now see the Thread Group Control Panel in the right section of the JMeter window<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-58011 aligncenter\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png\" alt=\"\" width=\"667\" height=\"223\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png 667w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3-300x100.png 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<ul>\n<li class=\"VSKILLbodytext\"><span lang=\"EN-US\">Start by providing a more descriptive name for our Thread Group. In the name field, enter JDBC Users.<\/span><\/li>\n<\/ul>\n<p class=\"VSKILLbodytext\" style=\"margin-left: 36.0pt;\"><span lang=\"EN-US\">You will need a valid database, database table, and user-level access to that table. In the example shown here, the database is &#8216;cloud&#8217; and the table name is &#8216;vm_instance&#8217;.<\/span><\/p>\n<ul>\n<li class=\"VSKILLbodytext\"><span lang=\"EN-US\">Next, increase the number of users to 50.<\/span><\/li>\n<li class=\"VSKILLbodytext\"><span lang=\"EN-US\">In the next field, the Ramp-Up Period, leave the value of 10 seconds. This property tells JMeter how long to delay between starting each user. For example, if you enter a Ramp-Up Period of 10 seconds, JMeter will finish starting all of your users by the end of the 10 seconds. So, if we have 50 users and a 10 second Ramp-Up Period, then the delay between starting users would be 200 milliseconds (10 seconds \/ 50 users = 0.2 user per second). If you set the value to 0, then JMeter will immediately start all of your users.<\/span><\/li>\n<li class=\"VSKILLbodytext\"><span lang=\"EN-US\">Finally, enter a value of 100 in the Loop Count field. This property tells JMeter how many times to repeat your test. To have JMeter repeatedly run your Test Plan, select the Forever checkbox.<\/span><\/li>\n<\/ul>\n<p class=\"VSKILLbodytext\" style=\"margin-left: 36.0pt;\"><span lang=\"EN-US\">In most applications, you have to manually accept changes you make in a Control Panel. However, in JMeter, the Control Panel automatically accepts your changes as you make them. If you change the name of an element, the tree will be updated with the new text after you leave the Control Panel (for example, when selecting another tree element).<\/span><\/p>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/2-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-58012 aligncenter\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/2-3.png\" alt=\"\" width=\"659\" height=\"223\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/2-3.png 659w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/2-3-300x102.png 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p><strong>Test Your Software Testing Skills By Taking Our JMeter Practice Tests On This <a href=\"https:\/\/www.vskills.in\/practice\/quiz\/Jmeter\">Link<\/a><\/strong><\/p>\n<p><em><strong>Become Vskills Certified JMeter Tester. Gain some knowledge on the module &#8220;Building A Test Plan&#8221;. Try the free practice test! <\/strong><\/em><\/p>\n<p><strong>Apply For <a href=\"https:\/\/www.vskills.in\/certification\/testing\/jmeter-tester-certification\">JMeter Certification<\/a><\/strong><\/p>\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.vskills.in\/practice\/jmeter\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/12\/Exam-4A0-102_-Nokia-Border-Gateway-Protocol-14-1.png\" alt=\"\" class=\"wp-image-95995\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/12\/Exam-4A0-102_-Nokia-Border-Gateway-Protocol-14-1.png 961w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/12\/Exam-4A0-102_-Nokia-Border-Gateway-Protocol-14-1-300x47.png 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tester-certification\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to Tutorial<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>BUILDING A DATABASE TEST PLAN- In this section, you will learn how to create a basic Test Plan to test a database server. You will create fifty users that send 2 SQL requests to the database server. Also, you will tell the users to run their tests 100 times. So, the total number of requests&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[126],"tags":[5670,9757,9759,9758,7163,5671],"class_list":["post-58008","page","type-page","status-publish","hentry","category-software-testing","tag-certified-jmeter-tester","tag-certified-jmeter-tester-exam-details","tag-certified-jmeter-tester-free-practice-test","tag-certified-jmeter-tester-online-tutorial","tag-jmeter","tag-jmeter-tester"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>JMeter Tutorial | BUILDING A DATABASE TEST PLAN<\/title>\n<meta name=\"description\" content=\"Become Vskills Certified JMeter Tester. Gain some knowledge on the module &quot;Building A Database Test Plan&quot;. Try the free practice test! Click Here!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JMeter Tutorial | BUILDING A DATABASE TEST PLAN\" \/>\n<meta property=\"og:description\" content=\"Become Vskills Certified JMeter Tester. Gain some knowledge on the module &quot;Building A Database Test Plan&quot;. Try the free practice test! Click Here!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:50:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/\",\"name\":\"JMeter Tutorial | BUILDING A DATABASE TEST PLAN\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png\",\"datePublished\":\"2017-07-10T09:48:37+00:00\",\"dateModified\":\"2024-04-12T08:50:36+00:00\",\"description\":\"Become Vskills Certified JMeter Tester. Gain some knowledge on the module \\\"Building A Database Test Plan\\\". Try the free practice test! Click Here!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#primaryimage\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png\",\"width\":667,\"height\":223},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BUILDING A DATABASE TEST PLAN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"JMeter Tutorial | BUILDING A DATABASE TEST PLAN","description":"Become Vskills Certified JMeter Tester. Gain some knowledge on the module \"Building A Database Test Plan\". Try the free practice test! Click Here!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/","og_locale":"en_US","og_type":"article","og_title":"JMeter Tutorial | BUILDING A DATABASE TEST PLAN","og_description":"Become Vskills Certified JMeter Tester. Gain some knowledge on the module \"Building A Database Test Plan\". Try the free practice test! Click Here!","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:50:36+00:00","og_image":[{"url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/","name":"JMeter Tutorial | BUILDING A DATABASE TEST PLAN","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png","datePublished":"2017-07-10T09:48:37+00:00","dateModified":"2024-04-12T08:50:36+00:00","description":"Become Vskills Certified JMeter Tester. Gain some knowledge on the module \"Building A Database Test Plan\". Try the free practice test! Click Here!","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#primaryimage","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/1-3.png","width":667,"height":223},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/jmeter-tutorial-building-database-test-plan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"BUILDING A DATABASE TEST PLAN"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/58008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=58008"}],"version-history":[{"count":10,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/58008\/revisions"}],"predecessor-version":[{"id":96289,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/58008\/revisions\/96289"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=58008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=58008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=58008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}