{"id":2111,"date":"2018-08-23T08:37:26","date_gmt":"2018-08-23T08:37:26","guid":{"rendered":"http:\/\/dbtut.com\/?p=2111"},"modified":"2018-11-18T20:36:41","modified_gmt":"2018-11-18T20:36:41","slug":"pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/","title":{"rendered":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>The PAGELATCH_EX and PAGELATCH_SH wait types are errors that occur when writing to the same page in memory at the same time.<\/p>\n<p>These errors usually occur when too many inserts occur at the same time.<\/p>\n<p>To overcome this problem, the table being inserted must be partitioned with hash partition.<\/p>\n<p>Depending on my experience, you may see up to 30 times performance improvement as a result of switching the table to a hash partition structure.<\/p>\n<p>To perform a hash partitioning on the table, you must perform the following operations, respectively.<\/p>\n<p>&nbsp;<\/p>\n<h3>1)The Partition Function is created.<\/h3>\n<pre class=\"lang:default decode:true\">CREATE PARTITION FUNCTION [pf_hash](tinyint) AS RANGE LEFT FOR VALUES (0,1,2,3,4,5,6,7,8,9,10,11)\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<h3>2)The partition scheme is created.<\/h3>\n<p>Here we use the filegroup named TABLESGROUP of all partitions.<\/p>\n<p>If you want you can use different filegroups.<\/p>\n<pre class=\"lang:default decode:true\">CREATE PARTITION SCHEME [ps_hash] AS PARTITION [pf_hash] TO \r\n([TABLESGROUP], [TABLESGROUP], [TABLESGROUP], [TABLESGROUP], [TABLESGROUP], \r\n[TABLESGROUP], [TABLESGROUP], [TABLESGROUP], [TABLESGROUP], [TABLESGROUP], \r\n[TABLESGROUP], [TABLESGROUP], \r\n[TABLESGROUP], [TABLESGROUP])\r\n\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<h3>3)An empty table with the HashID value is created in the structure of the table to be partitioned.<\/h3>\n<p>Let&#8217;s create a sample table. You should use the script of your own table.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE dbo.Tmp_TableName\r\n(\r\npkXX bigint NOT NULL IDENTITY (1, 1),\r\nTime datetime NOT NULL,\r\nHashID\u00a0 AS (CONVERT([tinyint],abs([pkXX]%(12)))) PERSISTED\r\n)\u00a0 ON ps_hash(HashID)\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<p>With the expression &#8220;ON ps_hash (HashID)&#8221;, the table is created on the partition.<\/p>\n<p>The column we will use for the partition is written in parentheses.<\/p>\n<p>&nbsp;<\/p>\n<h3>4)The data in the old table is transferred to the empty table.<\/h3>\n<p>The name of the temp table must be changed after the old table is dropped.<\/p>\n<pre class=\"lang:default decode:true\">BEGIN TRANSACTION\r\nGO\r\nALTER TABLE dbo.Tmp_TableName SET (LOCK_ESCALATION = TABLE)\r\nGO\r\nSET IDENTITY_INSERT dbo.Tmp_TableName ON\r\nGO\r\nIF EXISTS(SELECT * FROM dbo.TableName)\r\n\u00a0EXEC('INSERT INTO dbo.Tmp_TableName(pkXX, Time)\r\nSELECT pkXX,Time FROM dbo.TableName WITH (HOLDLOCK TABLOCKX)')\r\nGO\r\nSET IDENTITY_INSERT dbo.Tmp_TableName OFF\r\nGO\r\nDROP TABLE dbo.TableName\r\nGO\r\nEXECUTE sp_rename N'dbo.Tmp_TableName', TableName', 'OBJECT'\r\nGO\r\nCOMMIT<\/pre>\n<p>&nbsp;<\/p>\n<p>NonClustered Indexes and other objects are also created on the partition in the new table.<\/p>\n<p>&nbsp;<\/p>\n<h3>Example:<\/h3>\n<pre class=\"lang:default decode:true\">CREATE NONCLUSTERED INDEX IX_Example ON dbo.TableName\r\n(\r\nTime\r\n)\r\nWITH( PAD_INDEX = ON, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, \r\nALLOW_PAGE_LOCKS = ON) ON ps_hash(HashID)\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<p>You should absolutely test it before applying it in production environment.<\/p>\n<p>Also remember that you must close the application until the transfer is complete.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2111\" class=\"pvc_stats all  \" data-element-id=\"2111\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; The PAGELATCH_EX and PAGELATCH_SH wait types are errors that occur when writing to the same page in memory at the same time. These errors usually occur when too many inserts occur at the same time. To overcome this problem, the table being inserted must be partitioned with hash partition. Depending on my experience, you &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2111\" class=\"pvc_stats all  \" data-element-id=\"2111\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[1424,1425,1426],"class_list":["post-2111","post","type-post","status-publish","format-standard","","category-mssql","tag-hash-partition","tag-pagelatch_ex","tag-pagelatch_sh"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-23T08:37:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-18T20:36:41+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server\",\"datePublished\":\"2018-08-23T08:37:26+00:00\",\"dateModified\":\"2018-11-18T20:36:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/\"},\"wordCount\":268,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"Hash Partition\",\"PAGELATCH_EX\",\"PAGELATCH_SH\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/\",\"name\":\"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-08-23T08:37:26+00:00\",\"dateModified\":\"2018-11-18T20:36:41+00:00\",\"description\":\"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server - Database Tutorials","description":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition","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:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server - Database Tutorials","og_description":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-23T08:37:26+00:00","article_modified_time":"2018-11-18T20:36:41+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server","datePublished":"2018-08-23T08:37:26+00:00","dateModified":"2018-11-18T20:36:41+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/"},"wordCount":268,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["Hash Partition","PAGELATCH_EX","PAGELATCH_SH"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/","name":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-08-23T08:37:26+00:00","dateModified":"2018-11-18T20:36:41+00:00","description":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/23\/pagelatch_ex-and-pagelatch_sh-wait-types-and-hash-partition-on-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PAGELATCH_EX and PAGELATCH_SH Wait Types and Hash Partition On SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=2111"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2111\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}