Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/joe/wp-config.php on line 93

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":500,"date":"2012-03-29T03:05:00","date_gmt":"2012-03-29T03:05:00","guid":{"rendered":"\/blogs\/joe\/post\/Capturing-session_id-scheduler-assignment-using-SQLCMD-Mode.aspx"},"modified":"2013-01-02T20:32:09","modified_gmt":"2013-01-03T04:32:09","slug":"capturing-session_id-scheduler-assignment-using-sqlcmd-mode","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/","title":{"rendered":"Capturing session_id scheduler assignment using SQLCMD Mode"},"content":{"rendered":"

\nYesterday I was working on a SSMS SQLCMD-mode script and I noticed that periodically my session_id changed across test executions.  <\/span>I was tracking wait statistics based on specific session IDs, so I had to periodically add new session ids to my extended events session definition to make sure I captured my session’s wait stats accordingly. It was an isolated instance, so I could rely on the various session ids only being associated with my test.<\/font><\/font>\n<\/p>\n

\nIt got me thinking about capturing session_id and scheduler assignment using SQLCMD mode. I wasn’t so much interested in the new session ids being used, but rather, I was interested in where my session ids were landing from a scheduler perspective. Certainly you could test this through an application, PowerShell script, etc. But SQLCMD mode offered a quick way to do this and I thought I would explore further.<\/font>  <\/font><\/span><\/font>\n<\/p>\n

\nThere are a few scenarios that I thought would be interesting, but for now I’ll just show one of them. For this scenario I had SQL Server instance (10.50.2500) with four visible schedulers and without<\/em> multiple NUMA nodes (stay tuned on that for another time).  <\/span>I started off by creating a table in tempdb to track session_id, scheduler_id, parent_node_id, cpu_id and a counter of connects:<\/font><\/font>\n<\/p>\n

\n:CONNECT CAESAR<\/font><\/font><\/span><\/span>\n<\/p>\n

\nUSE<\/font><\/font><\/span> tempdb<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nCREATE<\/font><\/font><\/span> TABLE<\/font><\/span> [dbo]<\/font><\/span>.<\/font><\/span>[SQLCMDRoundRobin]<\/font><\/span><\/font>(<\/font><\/span><\/span><\/font>\n<\/p>\n

\n    <\/font><\/span>[sqlcmdroundrobin_id]<\/font><\/span> [int]<\/font><\/span> NOT<\/font><\/span> NULL<\/font><\/span> PRIMARY<\/font><\/span> KEY<\/font><\/span> CLUSTERED<\/font><\/span> IDENTITY<\/font><\/span>(<\/font><\/span>1,<\/font><\/span>1<\/font>),<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>[session_id]<\/font><\/span> [smallint]<\/font><\/span> NOT<\/font><\/span> <\/font>NULL,<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>[scheduler_id]<\/font><\/span> [int]<\/font><\/span> NOT<\/font><\/span> <\/font>NULL,<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>[parent_node_id]<\/font><\/span> [int]<\/font><\/span> NOT<\/font><\/span> <\/font>NULL,<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>[cpu_id]<\/font><\/span> [smallint]<\/font><\/span> NOT<\/font><\/span> <\/font>NULL,<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>[connect_counter]<\/font><\/span> [int]<\/font><\/span> NOT<\/font><\/span> <\/font>NULL<\/font><\/span><\/font><\/span>\n<\/p>\n

\n)<\/font><\/font><\/span> ON<\/font><\/span> [PRIMARY]<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nGO<\/font><\/font><\/span>\n<\/p>\n

\n<\/font><\/font>\n<\/p>\n

\nBefore I executed my test, I launched a separate background set of query executions (looping) which put the system under CPU pressure across all schedulers.<\/font><\/font>\n<\/p>\n

\n\"clip_image001[4]\"<\/a><\/span>\n<\/p>\n

\nNext, I connected using SQLCMD mode and used MERGE to INSERT\/UPDATE specific session_id\/scheduler_id combos.  <\/span>I used “GO 10000” to connect-and-execute 10,000 times:<\/font><\/font>\n<\/p>\n

\n:CONNECT CAESAR<\/font><\/font><\/span><\/span>\n<\/p>\n

\nUSE<\/font><\/font><\/span> tempdb<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nSET<\/font><\/font><\/span> NOCOUNT<\/font><\/span> ON<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nMERGE<\/font><\/font><\/span>  <\/span>dbo<\/font><\/span>.<\/font><\/span>SQLCMDRoundRobin<\/font><\/span> AS<\/font><\/span> <\/font>target<\/font><\/span><\/span><\/font>\n<\/p>\n

\nUSING <\/font><\/font><\/span>(<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>SELECT<\/font><\/span>      <\/span>r<\/font><\/span>.<\/font><\/span>session_id<\/font><\/span><\/font>,<\/font><\/span><\/font><\/span>\n<\/p>\n

\n                  <\/font><\/span>s<\/font><\/span>.<\/font><\/span>scheduler_id<\/font><\/span><\/font>,<\/font><\/span><\/font><\/span>\n<\/p>\n

\n                  <\/font><\/span>s<\/font><\/span>.<\/font><\/span>parent_node_id<\/font><\/span><\/font>,<\/font><\/span><\/font><\/span>\n<\/p>\n

\n                  <\/font><\/span>s<\/font><\/span>.<\/font><\/span><\/font>cpu_id<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>FROM<\/font><\/span> sys<\/font><\/span>.<\/font><\/span>dm_exec_requests<\/font><\/span> AS<\/font><\/span> <\/font>r<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>INNER<\/font><\/span> JOIN<\/font><\/span> sys<\/font><\/span>.<\/font><\/span>dm_os_schedulers<\/font><\/span> AS<\/font><\/span> s<\/font><\/span> <\/font>ON<\/font><\/span><\/font><\/span>\n<\/p>\n

\n            <\/font><\/span>r<\/font><\/span>.<\/font><\/span>scheduler_id<\/font><\/span> =<\/font><\/span> s<\/font><\/span>.<\/font><\/span><\/font>scheduler_id<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>WHERE<\/font><\/span> r<\/font><\/span>.<\/font><\/span>scheduler_id<\/font><\/span> IS<\/font><\/span> NOT<\/font><\/span> NULL<\/font><\/span> <\/font>AND<\/font><\/span><\/font><\/span>\n<\/p>\n

\n            <\/font><\/span>r<\/font><\/span>.<\/font><\/span>session_id<\/font><\/span> =<\/font><\/span> @@SPID<\/font><\/span>)<\/font><\/span> AS<\/font><\/span> <\/font>source<\/font><\/span><\/font><\/span>\n<\/p>\n

\n                  <\/font><\/font><\/span><\/span>(<\/font><\/span>session_id<\/font><\/span>,<\/font><\/span><\/font> scheduler_id<\/font><\/span>,<\/font><\/span> parent_node_id<\/font><\/span>,<\/font><\/span> cpu_id<\/font><\/span><\/font>)<\/font><\/span><\/span><\/font>\n<\/p>\n

\nON <\/font><\/font><\/span>(<\/font><\/span>target<\/font><\/span>.<\/font><\/span>session_id<\/font><\/span><\/font> =<\/font><\/span> source.<\/font><\/span>session_id<\/font><\/span> <\/font>AND<\/font><\/span><\/span><\/font>\n<\/p>\n

\n    <\/font><\/span>target<\/font><\/span>.<\/font><\/span>scheduler_id<\/font><\/span> =<\/font><\/span> source.<\/font><\/span>scheduler_id<\/font><\/span><\/font>)<\/font><\/span><\/font><\/span>\n<\/p>\n

\nWHEN<\/font><\/font><\/span> MATCHED<\/font><\/span> THEN<\/font><\/span> <\/font><\/span><\/font>\n<\/p>\n

\n      <\/font><\/span>UPDATE<\/font><\/span> SET<\/font><\/span> connect_counter<\/font><\/span> =<\/font><\/span> target<\/font><\/span>.<\/font><\/span>connect_counter<\/font><\/span>  <\/span>+<\/font><\/span> 1<\/font><\/font><\/span>\n<\/p>\n

\nWHEN<\/font><\/font><\/span> NOT<\/font><\/span> MATCHED<\/font><\/span> <\/font>THEN<\/font><\/span><\/span><\/font>\n<\/p>\n

\n      <\/font><\/span>INSERT <\/font><\/span>(<\/font><\/span>session_id<\/font><\/span>,<\/font><\/span> scheduler_id<\/font><\/span>,<\/font><\/span> parent_node_id<\/font><\/span>,<\/font><\/span> cpu_id<\/font><\/span>,<\/font><\/span> connect_counter<\/font><\/span> <\/font>)<\/font><\/span><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>VALUES <\/font><\/span>(source.<\/font><\/span>session_id<\/font><\/span>,<\/font><\/span> source.<\/font><\/span>scheduler_id<\/font><\/span>,<\/font><\/span> <\/font><\/font><\/span>\n<\/p>\n

\n      <\/font><\/span>       <\/span>source.<\/font><\/span>parent_node_id<\/font><\/span>,<\/font><\/span> source.<\/font><\/span>cpu_id<\/font><\/span>,<\/font><\/span>  <\/span>1<\/font>);<\/font><\/span><\/font><\/span>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nGO<\/font><\/font><\/span> 10000<\/font><\/span><\/font>\n<\/p>\n

\n<\/font><\/font>\n<\/p>\n

\nThen I executed the following query to look at the distribution based on every SQLCMD connect:<\/font><\/font>\n<\/p>\n

\n:CONNECT CAESAR<\/font><\/font><\/span><\/span>\n<\/p>\n

\nUSE<\/font><\/font><\/span> tempdb<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\nSELECT<\/font><\/font><\/span> session_id<\/font><\/span>,<\/font><\/span> scheduler_id<\/font><\/span>,<\/font><\/span> parent_node_id<\/font><\/span>,<\/font><\/span> cpu_id<\/font><\/span>,<\/font><\/span> <\/font>connect_counter<\/font><\/span><\/span><\/font>\n<\/p>\n

\nFROM<\/font><\/font><\/span> [dbo]<\/font><\/span>.<\/font><\/span><\/font>[SQLCMDRoundRobin];<\/font><\/span><\/span><\/font>\n<\/p>\n

\nGO<\/font><\/font><\/span><\/span>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nThis returned:<\/font><\/font>\n<\/p>\n

\n\"clip_image003[4]\"<\/a><\/span>\n<\/p>\n

\nRemoving all concurrent activity, I saw the following distribution instead:<\/font><\/font>\n<\/p>\n

\n\"clip_image005[4]\"<\/a><\/span>\n<\/p>\n

\nI also tested the workload and CPU driving background activity with the processor affinity mask explicitly set, and the distribution was as follows:<\/font><\/font>\n<\/p>\n

\n\"clip_image007[4]\"<\/a><\/span>\n<\/p>\n

\nI’d like to apply this framework to more scenarios – including for those on NUMA systems and also against a wider variety of workloads, since this has an impact on how the sessions will get distributed.  <\/span>When I get the chance, I’ll write about the observations here, but I thought I would share the capturing method in the meantime.<\/font><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

Yesterday I was working on a SSMS SQLCMD-mode script and I noticed that periodically my session_id changed across test executions.  I was tracking wait statistics based on specific session IDs, so I had to periodically add new session ids to my extended events session definition to make sure I captured my session’s wait stats accordingly. […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":["post-500","post","type-post","status-publish","format-standard","hentry","category-performance"],"yoast_head":"\nCapturing session_id scheduler assignment using SQLCMD Mode - Joe Sack<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Capturing session_id scheduler assignment using SQLCMD Mode - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"Yesterday I was working on a SSMS SQLCMD-mode script and I noticed that periodically my session_id changed across test executions.  I was tracking wait statistics based on specific session IDs, so I had to periodically add new session ids to my extended events session definition to make sure I captured my session’s wait stats accordingly. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-29T03:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-03T04:32:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/windows-live-writer\/capturing-session_id-scheduler-assignmen\/7cba4846\/clip_image0014_thumb.png\" \/>\n<meta name=\"author\" content=\"Joseph Sack\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joseph Sack\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/\",\"name\":\"Capturing session_id scheduler assignment using SQLCMD Mode - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2012-03-29T03:05:00+00:00\",\"dateModified\":\"2013-01-03T04:32:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Capturing session_id scheduler assignment using SQLCMD Mode\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\",\"name\":\"Joe Sack\",\"description\":\"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\",\"name\":\"Joseph Sack\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"caption\":\"Joseph Sack\"},\"description\":\"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.\",\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/joe\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Capturing session_id scheduler assignment using SQLCMD Mode - Joe Sack","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:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/","og_locale":"en_US","og_type":"article","og_title":"Capturing session_id scheduler assignment using SQLCMD Mode - Joe Sack","og_description":"Yesterday I was working on a SSMS SQLCMD-mode script and I noticed that periodically my session_id changed across test executions.  I was tracking wait statistics based on specific session IDs, so I had to periodically add new session ids to my extended events session definition to make sure I captured my session’s wait stats accordingly. […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/","og_site_name":"Joe Sack","article_published_time":"2012-03-29T03:05:00+00:00","article_modified_time":"2013-01-03T04:32:09+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/windows-live-writer\/capturing-session_id-scheduler-assignmen\/7cba4846\/clip_image0014_thumb.png"}],"author":"Joseph Sack","twitter_misc":{"Written by":"Joseph Sack","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/","name":"Capturing session_id scheduler assignment using SQLCMD Mode - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2012-03-29T03:05:00+00:00","dateModified":"2013-01-03T04:32:09+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/capturing-session_id-scheduler-assignment-using-sqlcmd-mode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"Performance","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/"},{"@type":"ListItem","position":3,"name":"Capturing session_id scheduler assignment using SQLCMD Mode"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/","name":"Joe Sack","description":"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648","name":"Joseph Sack","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","caption":"Joseph Sack"},"description":"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.","sameAs":["http:\/\/3.209.169.194\/blogs\/joe","https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack"],"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/comments?post=500"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/500\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}