{"id":9327,"date":"2019-02-12T06:39:03","date_gmt":"2019-02-12T06:39:03","guid":{"rendered":"https:\/\/dbtut.com\/?p=9327"},"modified":"2019-02-12T06:39:03","modified_gmt":"2019-02-12T06:39:03","slug":"how-to-identify-long-running-queries-using-sql-server-profiler","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/","title":{"rendered":"How To Identify Long Running Queries Using SQL Server Profiler"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Your queries are running slow and you want to determine which queries are running slowly. You can perform this operation by using SQL Server Profiler. We are opening SQL Server Profiler with Run As Administrator as follows.<\/p>\n<p id=\"zQzxglR\"><img loading=\"lazy\" decoding=\"async\" width=\"395\" height=\"319\" class=\"size-full wp-image-9329  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png\" alt=\"\" \/><\/p>\n<p>Click File-&gt;New.<\/p>\n<p id=\"CqxcFgI\"><img loading=\"lazy\" decoding=\"async\" width=\"518\" height=\"244\" class=\"size-full wp-image-9331  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c626879a439d.png\" alt=\"\" \/><\/p>\n<p>On the screen that appears, write the instance name in the &#8220;Server Name&#8221; section and click Connect.<\/p>\n<p id=\"WGRqvAy\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9333  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c626892342cb.png\" alt=\"\" width=\"515\" height=\"392\" \/><\/p>\n<p>We go to Event Selection on the screen and select &#8220;RPC: Completed&#8221; and &#8220;SQL: BatchCompleted&#8221; as below and we deselect others. Then click &#8220;Show all columns&#8221; and deselect\u00a0 and select again &#8220;RPC: Completed&#8221; and &#8220;SQL: BatchCompleted&#8221;. Thus, we have chosen all the columns.<\/p>\n<p id=\"yUONLmS\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9335  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6268c1aa713.png\" alt=\"\" width=\"779\" height=\"494\" \/><\/p>\n<p>Then click on Column Filters and the corresponding Database Name as below. You should write your database name between the %% marks in Like.<\/p>\n<p id=\"wdkYScp\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9337  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6268e6415ee.png\" alt=\"\" width=\"591\" height=\"463\" \/><\/p>\n<p>Click OK and then click Column filters again. In the duration tab, we write 1000 to &#8220;greater than or equal&#8221;.(The value here is in milliseconds. Since we write 1000, we&#8217;ll catch queries that take longer than 1 second.)<\/p>\n<p>Click OK and then run the profiler.<\/p>\n<p id=\"yKdSZWn\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9339  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6269037048c.png\" alt=\"\" width=\"584\" height=\"466\" \/><\/p>\n<p>We have created filter to capture queries that take longer than 1 second. You can also filter by using other parameters according to your needs.<\/p>\n<p>For Example;<\/p>\n<p>You can filter;<\/p>\n<ul type=\"disc\">\n<li>According to the application server that sent the query by using HostName.<\/li>\n<li>According to the login that sends the query using LoginName.<\/li>\n<li>According to the contents of the query using TextData.<\/li>\n<\/ul>\n<p>You can also filter using other parameters. I have shared the most used.<\/p>\n<p>Well, you&#8217;ve watched the trace for a while, but reading through the trace may not be easy. Therefore, you may want to import the trace into the database as a table.<\/p>\n<p>We stop Trace and click File-&gt; Save As-&gt; Trace Table.<\/p>\n<p id=\"MVamQXZ\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9341  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62692d64e1c.png\" alt=\"\" width=\"531\" height=\"269\" \/><\/p>\n<p>We select the instance where the database is located from the screen that appears.<\/p>\n<p id=\"IOKOuHw\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9343  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62694876ceb.png\" alt=\"\" width=\"566\" height=\"430\" \/><\/p>\n<p>From the next screen,<\/p>\n<p>Select the database where we will save trace in the&#8221; database: &#8220;section.<\/p>\n<p>Write the name of the trace table in the &#8220;table:&#8221; section and click OK.<\/p>\n<p>We can then go to the related database and query the trace table as we want.<\/p>\n<p id=\"yXbYxpf\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9346  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6269b896c79.png\" alt=\"\" width=\"549\" height=\"339\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9327\" class=\"pvc_stats all  \" data-element-id=\"9327\" 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; Your queries are running slow and you want to determine which queries are running slowly. You can perform this operation by using SQL Server Profiler. We are opening SQL Server Profiler with Run As Administrator as follows. Click File-&gt;New. On the screen that appears, write the instance name in the &#8220;Server Name&#8221; section and &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9327\" class=\"pvc_stats all  \" data-element-id=\"9327\" 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":[1997,1996],"class_list":["post-9327","post","type-post","status-publish","format-standard","","category-mssql","tag-identify-long-running-queries-using-profiler","tag-long-running-queries"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Identify Long Running Queries Using SQL Server Profiler - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Identify Long Running Queries Using SQL Server Profiler\" \/>\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\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Identify Long Running Queries Using SQL Server Profiler - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Identify Long Running Queries Using SQL Server Profiler\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-12T06:39:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.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=\"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\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Identify Long Running Queries Using SQL Server Profiler\",\"datePublished\":\"2019-02-12T06:39:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\"},\"wordCount\":357,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png\",\"keywords\":[\"Identify Long Running Queries using Profiler\",\"Long Running Queries\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\",\"name\":\"How To Identify Long Running Queries Using SQL Server Profiler - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png\",\"datePublished\":\"2019-02-12T06:39:03+00:00\",\"description\":\"How To Identify Long Running Queries Using SQL Server Profiler\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png\",\"width\":395,\"height\":319},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Identify Long Running Queries Using SQL Server Profiler\"}]},{\"@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 Identify Long Running Queries Using SQL Server Profiler - Database Tutorials","description":"How To Identify Long Running Queries Using SQL Server Profiler","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\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/","og_locale":"en_US","og_type":"article","og_title":"How To Identify Long Running Queries Using SQL Server Profiler - Database Tutorials","og_description":"How To Identify Long Running Queries Using SQL Server Profiler","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-12T06:39:03+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png","type":"","width":"","height":""}],"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\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Identify Long Running Queries Using SQL Server Profiler","datePublished":"2019-02-12T06:39:03+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/"},"wordCount":357,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png","keywords":["Identify Long Running Queries using Profiler","Long Running Queries"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/","name":"How To Identify Long Running Queries Using SQL Server Profiler - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png","datePublished":"2019-02-12T06:39:03+00:00","description":"How To Identify Long Running Queries Using SQL Server Profiler","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c62686331079.png","width":395,"height":319},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Identify Long Running Queries Using SQL Server Profiler"}]},{"@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\/9327","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=9327"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9327\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}