{"id":13589,"date":"2024-03-15T07:27:22","date_gmt":"2024-03-15T07:27:22","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/"},"modified":"2025-08-05T20:38:45","modified_gmt":"2025-08-05T20:38:45","slug":"how-to-query-the-historical-execution-records-of-sql-server","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/","title":{"rendered":"SQL Server Execution History Query Guide"},"content":{"rendered":"

In SQL Server, you can retrieve historical SQL execution records by querying system tables. Here are some commonly used system tables and views:<\/p>\n

    \n
  1. sys.dm_exec_query_stats: This view provides statistical information about recently executed queries, including the query’s execution plan, CPU usage, memory usage, and more.<\/li>\n<\/ol>\n
    SELECT<\/span>\r\n    *<\/span>\r\nFROM<\/span>\r\n    sys.dm_exec_query_stats\r\n<\/code><\/pre>\n
      \n
    1. sys.dm_exec_sql_text: This view provides detailed information about SQL statements, including the SQL text and the statement’s execution plan.<\/li>\n<\/ol>\n
      SELECT<\/span>\r\n    *<\/span>\r\nFROM<\/span>\r\n    sys.dm_exec_sql_text(PLAN_HANDLE)\r\n<\/code><\/pre>\n
      PLAN_HANDLE is obtained from the execution plan handle in the sys.dm_exec_query_stats view.<\/p>\n
        \n
      1. sys.dm_exec_requests: This view provides information about the currently executing requests, including the executing SQL statement, progress, and wait type.<\/li>\n<\/ol>\n
        SELECT<\/span>\r\n    *<\/span>\r\nFROM<\/span>\r\n    sys.dm_exec_requests\r\n<\/code><\/pre>\n
          \n
        1. sys.dm_exec_sessions: This view provides information about the sessions currently connected to SQL Server, including session ID, login name, application name, etc.<\/li>\n<\/ol>\n
          SELECT<\/span>\r\n    *<\/span>\r\nFROM<\/span>\r\n    sys.dm_exec_sessions\r\n<\/code><\/pre>\n
            \n
          1. The sys.dm_exec_connections view provides information about connections currently connected to SQL Server, including connection ID, client IP address, and connection status.<\/li>\n<\/ol>\n
            SELECT<\/span>\r\n    *<\/span>\r\nFROM<\/span>\r\n    sys.dm_exec_connections\r\n<\/code><\/pre>\n
              \n
            1. The function sys.dm_exec_query_plan returns the execution plan for a given SQL statement.<\/li>\n<\/ol>\n
              SELECT<\/span>\r\n    *<\/span>\r\nFROM<\/span>\r\n    sys.dm_exec_query_plan(PLAN_HANDLE)\r\n<\/code><\/pre>\n
              The PLAN_HANDLE is obtained from the sys.dm_exec_query_stats view in the execution plan.<\/p>\n
              Please note that the data in these system tables and views will only be retained in memory for a period of time in SQL Server. Once SQL Server is restarted or the cache is cleared, this historical data will be lost. If you need to preserve historical SQL execution records long-term, you may consider using SQL Server’s tracing feature or a third-party tool.<\/p>\n","protected":false},"excerpt":{"rendered":"
              In SQL Server, you can retrieve historical SQL execution records by querying system tables. Here are some commonly used system tables and views: sys.dm_exec_query_stats: This view provides statistical information about recently executed queries, including the query’s execution plan, CPU usage, memory usage, and more. SELECT * FROM sys.dm_exec_query_stats sys.dm_exec_sql_text: This view provides detailed information about […]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[390,2758,18129,572,18130],"class_list":["post-13589","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-administration","tag-performance-monitoring","tag-query-history","tag-sql-server","tag-sys-dm_exec_query_stats"],"yoast_head":"\nSQL Server Execution History Query Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to query historical execution records in SQL Server. Discover system tables and views to track SQL query performance and history.\" \/>\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.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Execution History Query Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to query historical execution records in SQL Server. Discover system tables and views to track SQL query performance and history.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T07:27:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T20:38:45+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\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:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"SQL Server Execution History Query Guide\",\"datePublished\":\"2024-03-15T07:27:22+00:00\",\"dateModified\":\"2025-08-05T20:38:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/\"},\"wordCount\":262,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database administration\",\"Performance monitoring\",\"Query History\",\"sql server\",\"sys.dm_exec_query_stats\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/\",\"name\":\"SQL Server Execution History Query Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T07:27:22+00:00\",\"dateModified\":\"2025-08-05T20:38:45+00:00\",\"description\":\"Learn how to query historical execution records in SQL Server. Discover system tables and views to track SQL query performance and history.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Execution History Query Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Execution History Query Guide - Blog - Silicon Cloud","description":"Learn how to query historical execution records in SQL Server. Discover system tables and views to track SQL query performance and history.","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.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Execution History Query Guide","og_description":"Learn how to query historical execution records in SQL Server. Discover system tables and views to track SQL query performance and history.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T07:27:22+00:00","article_modified_time":"2025-08-05T20:38:45+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"SQL Server Execution History Query Guide","datePublished":"2024-03-15T07:27:22+00:00","dateModified":"2025-08-05T20:38:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/"},"wordCount":262,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database administration","Performance monitoring","Query History","sql server","sys.dm_exec_query_stats"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/","name":"SQL Server Execution History Query Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T07:27:22+00:00","dateModified":"2025-08-05T20:38:45+00:00","description":"Learn how to query historical execution records in SQL Server. Discover system tables and views to track SQL query performance and history.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-historical-execution-records-of-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Execution History Query Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13589"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13589\/revisions"}],"predecessor-version":[{"id":157584,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13589\/revisions\/157584"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}