August 2008 - Posts

• 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 Read More... Posted Sunday, August 24, 2008 2:25 PM by jchang | 24 Comments Filed under: Performance, Scalability

• Recommended Server Systems, 2008 Q3 - Dunnington six-core

  Intel Dunnington Yet another update with the publication TPC results for the Intel X7460 six core (Dunnington) X7460 2.67GHz 3x3M L2, 16M L3 Dell, HP lists availability Sep 15, 2008, IBM lists availability on the x3950M2 as Dec 10, Dell R900 with 4 x Read More... Posted Tuesday, August 19, 2008 12:36 PM by jchang | 9 Comments Filed under: Performance, Hardware

• MemToLeave and 32-bit SQL Backup and Restore failures

  Has any one encountered SQL backup or restore failures that were ultimately diagnosed to a MemToLeave issue? This should only occur on 32-bit SQL Server versions, including 2000 and 2005. A number of other operations could generate a MemToLeave issue, Read More... Posted Tuesday, August 12, 2008 6:35 PM by jchang | 6 Comments Filed under: internals, troubleshooting, backups

• Venting at SAN vendors

  I was just about ready to unleash a long accumulating stream of rants against SAN vendors for pushing seriously obsolete computers as powerful storage systems. Of course, in a final check of products specs, I saw that EMC just announced the new Clariion Read More... Posted Wednesday, August 6, 2008 5:40 PM by jchang | 1 Comments Filed under: Performance, Storage

• Reporting Services and the WriteChunkPortion stored procedure

  Reporting Services (2005) uses the ReportServerTempDb database to store cached reports and temporary snapshots. Two of the stored procedure calls I see are WriteChunkPortion and ReadChunkPortion. Because I see that the MS ASP Session state manager also Read More... Posted Tuesday, August 5, 2008 5:27 PM by jchang | 3 Comments Filed under: Performance, Reporting Services