THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Scalability   (RSS)
  • Big-Iron Revival II, Nehalem-EX and Windows Server 2008 R2

    At Intel Developer Forum 2009 last week, Microsoft disclosed significant advances in Windows Server 2008 R2 with the elimination of many locks, most prominently the Dispatch Scheduler lock, that impact the ability scale performance up to and beyond 64 cores. Look for the presentation: Microsoft & Intel Innovations in Hardware and Software to ...
    Posted to Joe Chang (Weblog) by jchang on September 27, 2009
  • Benchmark Omissions for the Six-Core Intel Xeon AMD Opteron Processors

    To date, no 4-way or 8-way TPC-H data warehouse benchmark result has been published for the six-core Xeon X7460 and no TPC-C or TPC-E OLTP benchmark result has been published for six-core Opteron. Usually, the absence of published results means the results are not competitive, in one manner or another. TPC-C, E and H results were published for ...
    Posted to Joe Chang (Weblog) by jchang on September 13, 2009
  • First Nehalem TPC-H

    Earlier I talked about the first TPC-C and TPC-E results for 2-way Nehalem, ie, the Intel Xeon 5500 series. The results were spectacular relative to the previous generation Xeon 5400 series, (2.5X gain on the Intel slide deck for database OLTP) and were pretty much hitting the same range as 4-way Xeon 7460. I pointed out ...
    Posted to Joe Chang (Weblog) by jchang on June 3, 2009
  • Big Iron Revival, Intel Nehalem EX and AMD Magny-Cours

    Yesterday Intel held a product announcement press event for the upcoming Nehalem EX, which will succeed the current Xeon 7400 series based on the Core 2 micro-architecture for ''expandable system'', i.e., 4-way and higher, in late 2009 or early 2010. The current Xeon 5500 series (also Nehalem architecture) has 4 cores, 8M shared L3, 2 QPI links, ...
    Posted to Joe Chang (Weblog) by jchang on May 27, 2009
  • Large Query Performance from SQL Server 2000 to 2008, 32 & 64-bit

    I had been meaning to do a somewhat comprehensive review of SQL Server performance from versions 2000 to 2008 for both 32 and 64-bit on Data Warehouse type queries, with in depth examination of scaling in parallel execution plans.   For now, I can provide a short summary. The test platform is a Dell PowerEdge 2900 with 2 quad-core Xeon ...
    Posted to Joe Chang (Weblog) by jchang on August 24, 2008
  • Is any one seriously looking at the HP ProLiant DL785G5?

    Or the IBM x3950M2 8-way Quad-Core Xeon? Consider the following specs: 8-way Quad-Core Opteron (32 cores total) Max Memory: 512GB (64 DIMM sockets) 11 PCI-E slots: 3x16, 3x8, and 5x4 or option for 7 PCI-E and 2HTx   Compare this with the HP ProLiant DL585G5: 4-way Quad-Core Opteron (16 cores total) Max Memory: 256GB (32 DIMM ...
    Posted to Joe Chang (Weblog) by jchang on July 20, 2008
Privacy Statement