SQL Server 2008 launched today, with great performance and scalability

BioSensorAB » SQL Server 2008 launched today, with great performance and scalability

Thu, 28 Feb 2008 02:36:53 GMT

PingBack from http://www.biosensorab.org/2008/02/27/sql-server-2008-launched-today-with-great-performance-and-scalability/

ETL 1.18TB data σε 1794 δευτερόλεπτα: Pas mal!

Manos Kelaiditis' Weblog — Fri, 29 Feb 2008 14:27:37 GMT

Σήμερα, κατά το επίσημο launch των Windows Server 2008, SQL Server 2008 και Visual Studio 2008 ανακοινώθηκε

SQL Shorts

SQL Server Blog by Jason Massie on SQL Server 2005 and SQL Server 2008. — Fri, 29 Feb 2008 21:15:42 GMT

Xenomoroph to use SQL Server

Watson's Ramblings — Mon, 03 Mar 2008 12:15:35 GMT

re: SQL Server 2008 launched today, with great performance and scalability

jchang6 — Thu, 06 Mar 2008 06:38:03 GMT

some one on RealWorldTech pointed out the TPC-E scaling from the 16-core Xeon to 64-core Itanium (2.35X). I am fully aware that 1) at the single core level, a Core2 Xeon and Itanium 2 are very different, and 2) scaling from 16c to 32c to 64c is not 1X->2X->4X. For that matter, 479->1126 corresponds to 1.53X for each doubling of cores not accounting for the difference in core type, which really isn't that bad, but its not great either.

so I am looking through the TPC-E stored procedures. What caught my attention is the MarketWatchFrame1 procedure, which opens a cursor. Back in SQL Server 2000 days, cursors had horrible scaling, negative scaling in fact beyond 4 concurrent threads. Is this still the case in SQL Server 2005/8? Can the cursor be eliminated?

re: SQL Server 2008 launched today, with great performance and scalability

Data & SQL Storage Performance Team — Thu, 06 Mar 2008 21:09:31 GMT

As you pointed out, it's hard to compare the 3.4 GHz Xeon and 1.6 GHz Itanium results you referenced since cache and clock characteristics are so different. SQL Server 2008 scaling on TPC-E is very good, and is considerably better than SQL Server 2005.

SQL Server 2008 Performance Data

Is This Thing On? — Mon, 24 Mar 2008 04:31:50 GMT

  The subject of SQL08 perf data came up and I thought some of you might like to see some early

Early peek at SQL Server 2008 performance

US ISV Developer Evangelism Team — Mon, 24 Mar 2008 07:25:30 GMT

I'll often be asked for solid information about the performance of SQL Server 2008 . Even though it is

Launch? Hardly

mbourgon — Tue, 22 Apr 2008 22:46:39 GMT

Not to be a spoilsport, but calling that a "Launch" is a bit of a misnomer - all that's been released are CTPs. A "launch" normally requires a product. While I'm looking forward to 2008 as much as the next guy (maybe a little bit more), I'm eagerly awaiting the _real_ launch this fall(?), when it actually ships.

Scalability: Reporting Services 2008 vs Reporting Services 2005

DavidRaskino — Thu, 10 Jul 2008 18:57:32 GMT

Take a look at the recently released scalability technical note comparing Reporting Servives 2008 to Reporting Services 2005

Scalability: SSRS 2008 vs SSRS 2005

DavidRaskino — Thu, 10 Jul 2008 18:58:16 GMT

Take a look at the recently released scalability technical note comparing Reporting Servives 2008 to Reporting Services 2005

http://sqlcat.com/technicalnotes/archive/2008/07/09/scaling-up-reporting-services-2008-vs-reporting-services-2005-lessons-learned.aspx

re: SQL Server 2008 launched today, with great performance and scalability

mycorrado — Wed, 10 Sep 2008 02:24:48 GMT

The MarketWatchFrame1 proc can be re-factored without the cursor. In my tests it went from runing one minute to subsecond performance.