{"id":11670,"date":"2019-04-19T19:37:51","date_gmt":"2019-04-19T19:37:51","guid":{"rendered":"https:\/\/dbtut.com\/?p=11670"},"modified":"2020-10-02T08:12:52","modified_gmt":"2020-10-02T08:12:52","slug":"how-to-find-most-expensive-queries-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/","title":{"rendered":"How To Find Most Expensive Queries in SQL Server"},"content":{"rendered":"

One of the first things that we look at to improve performance in systems that have performance problems is the ones that finding queries that use CPU and Disk most. You can identify the queries that use the CPU most and make the necessary improvements.<\/p>\n\n

Top 50 CPU Consuming Queries in SQL Server<\/h2>\n
Select \n     st.[text] AS [Query Text],          \n     wt.last_execution_time AS [Last Execution Time],\n     wt.execution_count AS [Execution Count],\n     wt.total_worker_time\/1000000 AS [Total CPU Time(second)],\n     wt.total_worker_time\/wt.execution_count\/1000 AS [Average CPU Time(milisecond)],\n     qp.query_plan,\n     DB_NAME(st.dbid) AS [Database Name]\nfrom \n    (select top 50 \n          qs.last_execution_time,\n          qs.execution_count,\n\t  qs.plan_handle, \n          qs.total_worker_time\n    from sys.dm_exec_query_stats qs\n    order by qs.total_worker_time desc) wt\ncross apply sys.dm_exec_sql_text(plan_handle) st\ncross apply sys.dm_exec_query_plan(plan_handle) qp\norder by wt.total_worker_time desc\n<\/pre>\n
The query will return a result set as follows.<\/p>\n
\"\"<\/p>\n
All of the values \u200b\u200breturned as a result of this query are taken from the statistics collected from the moment the sql server service was last started. So if your SQL Server service has been restarted 1 minute ago, you cannot perform a very efficient analysis.<\/p>\n
In the query section, shows the parameterized state of the query.<\/p>\n
Average CPU Time (in milliseconds) gives the average run time of the query, in milliseconds.<\/p>\n
In general, we decide which queries we will improve based on the Average CPU Time (milliseconds). We understand that if the average CPU Time (in milliseconds) of a query that needs to be completed in a few milliseconds is 2 seconds, we need to improve this query.<\/p>\n
Sometimes, when we improve a query that has an average CPU Time of 200 milliseconds, we can see that the server’s CPU usage is reduced. In such cases, the query’s Execution Count is usually too much, and if the query’s average CPU Time (milliseconds) is reduced to a few milliseconds, it may have a cumulative impact on the CPU.<\/p>\n
Top 50 Disk IO Consuming Queries in SQL Server<\/h2>\n
In the following query, you can find it sorted by total logical read. You can sort by another value.<\/p>\n
select \n     st.[text] AS [Query Text],      \n     qs.last_execution_time AS [Last Execution Time],\n     qs.execution_count AS [Execution Count],\n     qs.total_logical_reads AS [Total Logical Read],\n     qs.total_logical_reads\/execution_count AS [Average Logical Read],\n     qs.total_worker_time\/1000000 AS [Total CPU Time(second)],\n     qs.total_worker_time\/qs.execution_count\/1000 AS [Average CPU Time(milisecond)],\n     qp.query_plan AS [Execution Plan],\n     DB_NAME(st.dbid) AS [Database Name]\nfrom \n    (select top 50 \n          qs.last_execution_time,\n          qs.execution_count,\n\t  qs.plan_handle, \n          qs.total_worker_time,\n          qs.total_logical_reads\n    from sys.dm_exec_query_stats qs\n    order by qs.total_worker_time desc) qs\ncross apply sys.dm_exec_sql_text(plan_handle) st\ncross apply sys.dm_exec_query_plan(plan_handle) qp\norder by qs.total_logical_reads desc\n<\/pre>\n
\"\"<\/p>\n
You may want to read the following articles.<\/p>\n
“How To Find Missing Indexes in SQL Server<\/a>”<\/p>\n
“How To Identify Long Running Queries Using Extended Events<\/a>“,<\/p>\n
“How To Identify Long Running Queries Using SQL Server Profiler<\/a>“,<\/p>\n
“Running SQL Server With High Performance(High Performance)<\/a>“,<\/p>\n
“Index Concept and Performance Effect on SQL Server<\/a>“,<\/p>\n
“Statistics Concept and Performance Effect on SQL Server<\/a>”<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
One of the first things that we look at to improve performance in systems that have performance problems is the ones that finding queries that use CPU and Disk most. You can identify the queries that use the CPU most and make the necessary improvements. Top 50 CPU Consuming Queries in SQL Server Select st.[text] …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":11681,"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":[3493,3503,3495,3487,3508,3509,3504,3505,3492,3486,3499,3506,3496,3494,3501,3498,3488,3502,3490,3483,3484,3489,3482,3481,3480,3479,3491,3485,3500,3497,3507],"class_list":["post-11670","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-check-expensive-query","tag-find-expensive-queries-sql-server","tag-finding-expensive-queries-in-sql-server","tag-get-top-resource-consuming-queries","tag-how-can-you-increase-sql-performance","tag-how-do-you-perform-a-performance-tuning-in-sql","tag-how-to-find-slow-running-query-in-sql-server","tag-how-to-find-which-query-is-taking-more-time-in-sql-server","tag-how-to-find-worst-performing-queries-in-sql-server","tag-how-to-find-worst-performing-sql-server-queries","tag-how-to-resolve-high-cpu-utilization-in-sql-server","tag-how-to-troubleshoot-long-running-queries-in-sql-server","tag-list-expensive-queries","tag-most-expensive-queries-sql-server","tag-sql-high-cpu-usage","tag-sql-server-cpu-usage-100-percent","tag-sql-server-top-10-worst-performing-queries","tag-sql-server-what-query-is-using-cpu","tag-sql-top-ten-queries","tag-top-10-cpu-consuming-queries-in-sql-server","tag-top-10-disk-io-consuming-queries-in-sql-server","tag-top-10-expensive-queries","tag-top-50-cpu-consuming-queries","tag-top-50-cpu-consuming-queries-in-sql-server","tag-top-50-disk-io-consuming-queries","tag-top-50-disk-io-consuming-queries-in-sql-server","tag-top-50-queries-sql-server","tag-top-queries-by-cpu-and-io","tag-troubleshoot-high-cpu-usage-in-sql-server","tag-troubleshooting-high-cpu-utilization-in-sql-server","tag-where-can-i-find-slow-running-query-in-sql-server"],"aioseo_notices":[],"yoast_head":"\nHow To Find Most Expensive Queries in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Find Most Expensive Queries in SQL Server\" \/>\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\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Find Most Expensive Queries in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Find Most Expensive Queries in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-19T19:37:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-02T08:12:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png\" \/>\n\t<meta property=\"og:image:width\" content=\"530\" \/>\n\t<meta property=\"og:image:height\" content=\"327\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Find Most Expensive Queries in SQL Server\",\"datePublished\":\"2019-04-19T19:37:51+00:00\",\"dateModified\":\"2020-10-02T08:12:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\"},\"wordCount\":337,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png\",\"keywords\":[\"check expensive query\",\"find expensive queries sql server\",\"Finding Expensive Queries in SQL Server\",\"Get Top Resource-Consuming Queries\",\"How can you increase SQL performance?\",\"How do you perform a performance tuning in SQL?\",\"how to find slow running query in sql server\",\"how to find which query is taking more time in sql server\",\"how to find worst performing queries in sql server\",\"How to find worst performing SQL Server queries\",\"how to resolve high cpu utilization in sql server\",\"how to troubleshoot long running queries in sql server\",\"List expensive queries\",\"most expensive queries sql server\",\"sql high cpu usage\",\"sql server cpu usage 100 percent\",\"sql server top 10 worst performing queries\",\"sql server what query is using cpu\",\"sql top ten queries\",\"Top 10 CPU Consuming Queries in SQL Server\",\"Top 10 Disk IO Consuming Queries in SQL Server\",\"top 10 expensive queries\",\"Top 50 CPU Consuming Queries\",\"Top 50 CPU Consuming Queries in SQL Server\",\"Top 50 Disk IO Consuming Queries\",\"Top 50 Disk IO Consuming Queries in SQL Server\",\"top 50 queries sql server\",\"Top Queries by CPU and IO\",\"troubleshoot high cpu usage in sql server\",\"troubleshooting high cpu utilization in sql server\",\"Where can I find slow running query in SQL Server?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\",\"name\":\"How To Find Most Expensive Queries in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png\",\"datePublished\":\"2019-04-19T19:37:51+00:00\",\"dateModified\":\"2020-10-02T08:12:52+00:00\",\"description\":\"How To Find Most Expensive Queries in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png\",\"width\":530,\"height\":327},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Find Most Expensive Queries in 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":"How To Find Most Expensive Queries in SQL Server - Database Tutorials","description":"How To Find Most Expensive Queries in SQL Server","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\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Find Most Expensive Queries in SQL Server - Database Tutorials","og_description":"How To Find Most Expensive Queries in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-19T19:37:51+00:00","article_modified_time":"2020-10-02T08:12:52+00:00","og_image":[{"width":530,"height":327,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Find Most Expensive Queries in SQL Server","datePublished":"2019-04-19T19:37:51+00:00","dateModified":"2020-10-02T08:12:52+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/"},"wordCount":337,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png","keywords":["check expensive query","find expensive queries sql server","Finding Expensive Queries in SQL Server","Get Top Resource-Consuming Queries","How can you increase SQL performance?","How do you perform a performance tuning in SQL?","how to find slow running query in sql server","how to find which query is taking more time in sql server","how to find worst performing queries in sql server","How to find worst performing SQL Server queries","how to resolve high cpu utilization in sql server","how to troubleshoot long running queries in sql server","List expensive queries","most expensive queries sql server","sql high cpu usage","sql server cpu usage 100 percent","sql server top 10 worst performing queries","sql server what query is using cpu","sql top ten queries","Top 10 CPU Consuming Queries in SQL Server","Top 10 Disk IO Consuming Queries in SQL Server","top 10 expensive queries","Top 50 CPU Consuming Queries","Top 50 CPU Consuming Queries in SQL Server","Top 50 Disk IO Consuming Queries","Top 50 Disk IO Consuming Queries in SQL Server","top 50 queries sql server","Top Queries by CPU and IO","troubleshoot high cpu usage in sql server","troubleshooting high cpu utilization in sql server","Where can I find slow running query in SQL Server?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/","name":"How To Find Most Expensive Queries in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png","datePublished":"2019-04-19T19:37:51+00:00","dateModified":"2020-10-02T08:12:52+00:00","description":"How To Find Most Expensive Queries in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-38.png","width":530,"height":327},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Find Most Expensive Queries in 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\/11670","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=11670"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11670\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11681"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}