November 2008 - Posts

• Dedicated Network Adapter(s) for transferring SQL backups to the tape archival system

  One thing that really surprises me is how few people configure dedicated network adapters/ports (and preferably multiple adapters) for copying the SQL Server backup to the server with the tape archival system. The common reason cited by a really naïve Read More... Posted Saturday, November 22, 2008 1:04 AM by jchang | 7 Comments Filed under: Network configuration, backups

• Early TPC-C and H reports for Shanghai relative to Barcelona and Dunnington

  Below are the first performance numbers for the new AMD 45nm Opteron (Shanghai) relative to other recent AMD and Intel Xeon results. 4-way TPC-C Opteron 8360 Quad-core 2.5GHz (Barcelona) 2M L3, 471,883 (DL585G2) Opteron 8384 Quad-core 2.7GHz (Shanghai) Read More... Posted Wednesday, November 19, 2008 2:58 PM by jchang | 3 Comments Filed under: Performance, Hardware

• Statistics Blunders

  One of the major blunders in SQL Server 2000 is in the calculation of data distribution statistics. In theory, it should be possible to take just a small true random sample to get a reasonable estimate of the true distribution. Because of the page organization Read More... Posted Friday, November 14, 2008 5:21 PM by jchang | 0 Comments Filed under: Statistics