{"id":3787,"date":"2018-10-14T17:56:25","date_gmt":"2018-10-14T17:56:25","guid":{"rendered":"https:\/\/dbtut.com\/?p=3787"},"modified":"2018-11-26T11:03:36","modified_gmt":"2018-11-26T11:03:36","slug":"how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/","title":{"rendered":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>If you define the availability group asynchronous in the SQL Server Always ON architecture, the secondary database is slightly behind.<\/p>\n<p>You can find details about Always On in my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/18\/sql-server-always-on-availability-group\/\" target=\"_blank\" rel=\"noopener\">SQL Server Always ON Availability Group<\/a>&#8220;.<\/p>\n<p>The difference between the secondary database and the primary database is related to the application&#8217;s transaction intensity.<\/p>\n<p>For example, if the application contains very intensive insert, update, and delete operations, it may take some time for the processes to be transferred to the secondary database.<\/p>\n<p>Sometimes, even if you define the availability group as synchronous, the databases may appear synchronous, but the secondary may be behind for various reasons. For example, the slowness of the disk on the secondary server.<\/p>\n<p>For the secondary database to be fully synchronized, the log records from the primary server must be written to the disk (log hardened operation).<\/p>\n<p>Then the records written in the log files need to be written to the data files (redone process)<\/p>\n<p>Commit process is also done with the redone process.<\/p>\n<p>If the log hardened process occurs, there is no data loss. Because data is somehow transferred to the secondary. SQL Server determines the synchronization status according to the log hardened process.<\/p>\n<p>So if the log hardened process is complete, and you are using the sync availability group, you see synchronized on the dashboard.<\/p>\n<p>But in some cases, even if the log hardened process has been completed, the redone operation may be behind.(Disk slowness, etc.)<\/p>\n<p>In this case, assume that you see the availability group synchronized.<\/p>\n<p>If you try to perform a failover, you may have to wait for hours to complete the failover.<\/p>\n<p>Because the &#8220;redone&#8221; process is incomplete. So the records written to the log file are not processed in the data file.<\/p>\n<p>Therefore, the secondary database needs to be recovered to become a primary.<\/p>\n<p>That&#8217;s why last redone time and last commit time has a serious importance for us before failover.<\/p>\n<p>With the help of the following script, you can find the real difference between the Secondary database and the primary database. You must run this script on the secondary server.<\/p>\n<pre class=\"lang:default decode:true \">SELECT ag.name AS ag_name, ar.replica_server_name AS ag_replica_server, DB_NAME(dr_state.database_id) as database_name, \r\ndr_state.last_hardened_time,dr_state.last_redone_time,dr_state.last_commit_time, datediff(s,last_commit_time, \r\ngetdate()) as 'secondary sunucunun geriden geldi\u011fi s\u00fcre SN' \r\nFROM (( sys.availability_groups AS ag JOIN sys.availability_replicas AS ar ON ag.group_id = ar.group_id ) \r\nJOIN sys.dm_hadr_availability_replica_states AS ar_state ON ar.replica_id = ar_state.replica_id) \r\nJOIN sys.dm_hadr_database_replica_states dr_state on ag.group_id = dr_state.group_id \r\nand dr_state.replica_id = ar_state.replica_id\r\nwhere ar_state.role_desc='SECONDARY' AND ar_state.is_local=1\r\norder by last_commit_time asc<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3787\" class=\"pvc_stats all  \" data-element-id=\"3787\" 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; If you define the availability group asynchronous in the SQL Server Always ON architecture, the secondary database is slightly behind. You can find details about Always On in my article &#8220;SQL Server Always ON Availability Group&#8220;. The difference between the secondary database and the primary database is related to the application&#8217;s transaction intensity. For &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3787\" class=\"pvc_stats all  \" data-element-id=\"3787\" 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":[],"class_list":["post-3787","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":1104,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture\" \/>\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\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-14T17:56:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-26T11:03:36+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\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture\",\"datePublished\":\"2018-10-14T17:56:25+00:00\",\"dateModified\":\"2018-11-26T11:03:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/\"},\"wordCount\":371,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/\",\"name\":\"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-10-14T17:56:25+00:00\",\"dateModified\":\"2018-11-26T11:03:36+00:00\",\"description\":\"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture\"}]},{\"@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":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture - Database Tutorials","description":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture","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\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/","og_locale":"en_US","og_type":"article","og_title":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture - Database Tutorials","og_description":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-14T17:56:25+00:00","article_modified_time":"2018-11-26T11:03:36+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\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture","datePublished":"2018-10-14T17:56:25+00:00","dateModified":"2018-11-26T11:03:36+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/"},"wordCount":371,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/","name":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-10-14T17:56:25+00:00","dateModified":"2018-11-26T11:03:36+00:00","description":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/14\/how-to-find-time-difference-between-primary-and-secondary-database-in-sql-server-always-on-architecture\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture"}]},{"@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\/3787","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=3787"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3787\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}