{"id":9057,"date":"2019-02-02T14:16:22","date_gmt":"2019-02-02T14:16:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=9057"},"modified":"2019-02-02T14:16:22","modified_gmt":"2019-02-02T14:16:22","slug":"the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/","title":{"rendered":"The Extended Events session named “x” could not be found. Make sure the session exist and is started."},"content":{"rendered":"

 <\/p>\n

One day I opened SSMS (SQL Server Management Studio) and wanted to check the Extended Events Session that captured Timeouts. To find out how to capture Timeouts with Extended Events, you may want to read my article “How To Capture Query Timeout With Extended Events<\/a>“.<\/p>\n

When I right-click on “Extended Events” called Timeout, and then click “Watch Live Data”, I received an error as follows.<\/p>\n

\"\"<\/p>\n

The error was meaningless, but as a result of the research I learned that this error might be because the user’s default database is not a master. So I right-click on my login(Its sysadmin) and click Properties, and I see that the default database is the master from the General tab.<\/p>\n

\"\"<\/p>\n

Although my default database is master, I was getting this error. The reason for the problem was that when connecting to SSMS, there was a database other than the master database in the Connect To Database section.<\/p>\n

Click on the Options tab while connecting to SSMS as follows and on the Connection Properties tab select the “Default” in the Connect to database section. The problem will be solved.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

  One day I opened SSMS (SQL Server Management Studio) and wanted to check the Extended Events Session that captured Timeouts. To find out how to capture Timeouts with Extended Events, you may want to read my article “How To Capture Query Timeout With Extended Events“. When I right-click on “Extended Events” called Timeout, and …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/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-9057","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":157,"today_views":0},"yoast_head":"\nThe Extended Events session named "x" could not be found. Make sure the session exist and is started. - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The Extended Events session named "x" could not be found. Make sure the session exist and is started.\" \/>\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\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Extended Events session named "x" could not be found. Make sure the session exist and is started. - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The Extended Events session named "x" could not be found. Make sure the session exist and is started.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-02T14:16:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.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=\"1 minute\" \/>\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\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"The Extended Events session named “x” could not be found. Make sure the session exist and is started.\",\"datePublished\":\"2019-02-02T14:16:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/\"},\"wordCount\":207,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/\",\"name\":\"The Extended Events session named \\\"x\\\" could not be found. Make sure the session exist and is started. - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png\",\"datePublished\":\"2019-02-02T14:16:22+00:00\",\"description\":\"The Extended Events session named \\\"x\\\" could not be found. Make sure the session exist and is started.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png\",\"width\":1021,\"height\":266},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Extended Events session named “x” could not be found. Make sure the session exist and is started.\"}]},{\"@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":"The Extended Events session named \"x\" could not be found. Make sure the session exist and is started. - Database Tutorials","description":"The Extended Events session named \"x\" could not be found. Make sure the session exist and is started.","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\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/","og_locale":"en_US","og_type":"article","og_title":"The Extended Events session named \"x\" could not be found. Make sure the session exist and is started. - Database Tutorials","og_description":"The Extended Events session named \"x\" could not be found. Make sure the session exist and is started.","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-02T14:16:22+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"The Extended Events session named “x” could not be found. Make sure the session exist and is started.","datePublished":"2019-02-02T14:16:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/"},"wordCount":207,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/","name":"The Extended Events session named \"x\" could not be found. Make sure the session exist and is started. - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png","datePublished":"2019-02-02T14:16:22+00:00","description":"The Extended Events session named \"x\" could not be found. Make sure the session exist and is started.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c55a56c2ce76.png","width":1021,"height":266},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/02\/the-extended-events-session-named-x-could-not-be-found-make-sure-the-session-exist-and-is-started\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The Extended Events session named “x” could not be found. Make sure the session exist and is started."}]},{"@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\/9057","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=9057"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9057\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}