{"id":6583,"date":"2008-02-27T04:00:00","date_gmt":"2008-02-27T12:00:00","guid":{"rendered":""},"modified":"2024-01-22T22:51:34","modified_gmt":"2024-01-23T06:51:34","slug":"sql-server-2008-benchmarks","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/","title":{"rendered":"SQL Server 2008 Benchmarks"},"content":{"rendered":"

With the launch of SQL Server 2008 today (remember, RTM is still planned for a few months later in Q3 2008) we have just posted a number of record breaking results across industry (TPC-E, TPC-H) and ISV benchmarks. These are really amazing results and the team worked extremely hard to get these published by launch. We posted best performance results for TPC-E and our first ever TPC-H 10TB result. We delivered a record breaking ETL benchmark loading 1TB of data in less than 30min. And finally record breaking ISV benchmarks showing incredible results with SQL Server 2008.<\/p>\n

\n
\n
\n
\n
\n
\n
\n
\n
\n

Industry<\/span><\/strong><\/h3>\n\n\n\n\n\n\n
Application<\/th>\nCompany<\/th>\nResult<\/th>\n<\/tr>\n
TPC-E*<\/td>\nNEC<\/td>\nNew world record: 1126 tpsE on an Itanium 32-proc (64-core) server (AsAmA2) <\/b>(1)<\/SUP)< p> <\/sup>

<\/p>\n

1st TPC-E result on 64-way server<\/p>\n

Bests the previous record by 70%<\/p><\/td>\n<\/tr>\n

TPC-E*<\/td>\nIBM<\/td>\n479 tpsE on a Xeon 4-proc (16-core) server <\/b>(2)<\/SUP)< p> <\/sup>

<\/p>\n

14% performance gain over SQL Server 2005 and Windows Server 2003<\/p>\n

Highest performance for 4-socket servers<\/p><\/td>\n<\/tr>\n

TPC-H** (10TB)<\/td>\nHP<\/td>\n1st SQL Server or Windows Server result in 10TB category <\/b>(3)<\/SUP)< p> <\/sup>

<\/p>\n

63K QphH on an Itanium 32-proc (64-core) server [Superdome]<\/p><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
\n
\n
\n

Partners<\/span><\/strong><\/h3>\n\n\n\n\n\n\n\n\n
Application<\/th>\nCompany<\/th>\nResult<\/th>\n<\/tr>\n
Manufacturing Execution Systems<\/td>\nCAMSTAR<\/td>\nWorld Record scale at 205 MES and 60% space reduction due to database compression<\/b>
\nRecord scale at 205 Manufacturing Execution System transactions per second and 60 percent space reduction due to database compression were achieved with Camstar\u2019s MES application, SQL Server 2008 and Windows Server 2008.<\/td>\n<\/tr>\n
Customer Relationship Management<\/td>\nMicrosoft Dynamics<\/td>\nRecord scale at 24,000 concurrent users with sub-second response rate<\/b>
\nBenchmark tests demonstrate that record scale at 24,000 concurrent users with sub-second response rate was achieved with Microsoft Dynamics CRM 4.0, SQL Server 2008 and Windows Server 2008 for enterprise-level workload.<\/td>\n<\/tr>\n
Product Lifecycle Management<\/td>\nSIEMENS Teamcenter<\/td>\nWorld Record scale and 50% pace reduction achieved with Siemens <\/b>Teamcenter 2007, SQL Server 2008 and Windows Server 2008<\/b>
\nScalability benchmark with 5,000 concurrent users and 50 percent space reduction due to database compression achieved with Siemens Teamcenter 2007, SQL Server 2008 and Windows Server 2008.<\/td>\n<\/tr>\n
Enterprise Resource Planning<\/td>\nMicrosoft Dynamics AX<\/td>\nRecord scale improvement of 70% in throughput, scalability and response time<\/b>
\nBenchmark tests demonstrate record scale showing up to 70 percent improvement in throughput scalability and response time; maximizing performance while minimizing database growth using SQL Server 2008 database compression.<\/td>\n<\/tr>\n
Enterprise Resource Planning<\/td>\nSAP\/HP<\/td>\nWorld Record Scale Set by SQL Server 2008 on 4-Socket Industry Standard Blade servers in 3-tier SAP SD Standard Application Benchmark Test<\/b>
\nThis latest benchmark demonstrates an increase of throughput of nearly a factor of 3 over the last 4 years with Industry Standard hardware. The demonstrated throughput by SQL Server 2008 x64 and Windows Server 2008 x64 running on Industry-Standard hardware is expected to cover scalability needs of at least 97% of all SAP deployments worldwide. Learn more<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

ETL Performance<\/span><\/strong><\/h3>\n\n\n\n\n
Application<\/th>\nCompany<\/th>\nResult<\/th>\n<\/tr>\n
ETL Performance<\/td>\nUnisys<\/td>\nLoad 1TB of data in less than 30 minutes using ETL tools<\/b>

<\/p>\n

32-proc (64-core) server [ES7000]<\/p>\n

World record for ETL load performance<\/p><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n

http:\/\/www.microsoft.com\/sqlserver\/2008\/en\/us\/benchmarks.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

With the launch of SQL Server 2008 today (remember, RTM is still planned for a few months later in Q3 2008) we have just posted a number of record breaking results across industry (TPC-E, TPC-H) and ISV benchmarks. These are really amazing results and the team worked extremely hard to get these published by launch.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[],"class_list":["post-6583","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-1593580427-503","review-flag-1593580410-819","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-4-1593580446-456","review-flag-5-1593580452-31","review-flag-new-1593580247-437"],"yoast_head":"\nSQL Server 2008 Benchmarks - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2008 Benchmarks - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"With the launch of SQL Server 2008 today (remember, RTM is still planned for a few months later in Q3 2008) we have just posted a number of record breaking results across industry (TPC-E, TPC-H) and ISV benchmarks. These are really amazing results and the team worked extremely hard to get these published by launch.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2008-02-27T12:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2008 Benchmarks\",\"datePublished\":\"2008-02-27T12:00:00+00:00\",\"dateModified\":\"2024-01-23T06:51:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/\"},\"wordCount\":475,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/\",\"name\":\"SQL Server 2008 Benchmarks - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2008-02-27T12:00:00+00:00\",\"dateModified\":\"2024-01-23T06:51:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008 Benchmarks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2008 Benchmarks - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2008 Benchmarks - Microsoft SQL Server Blog","og_description":"With the launch of SQL Server 2008 today (remember, RTM is still planned for a few months later in Q3 2008) we have just posted a number of record breaking results across industry (TPC-E, TPC-H) and ISV benchmarks. These are really amazing results and the team worked extremely hard to get these published by launch.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2008-02-27T12:00:00+00:00","article_modified_time":"2024-01-23T06:51:34+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2008 Benchmarks","datePublished":"2008-02-27T12:00:00+00:00","dateModified":"2024-01-23T06:51:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/"},"wordCount":475,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/","name":"SQL Server 2008 Benchmarks - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2008-02-27T12:00:00+00:00","dateModified":"2024-01-23T06:51:34+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/02\/27\/sql-server-2008-benchmarks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008 Benchmarks"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/6583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=6583"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/6583\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=6583"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=6583"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=6583"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=6583"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=6583"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=6583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}