结构化查询语言SQL Server Summit 2004_ Scaling SQL Server to the …….pptVIP

Scaling SQL Server 2000 to the MAX Raj Gill Scalability Experts, Inc. Agenda Introduction to Scalability Define, measure, forecast, build a roadmap Hardware specifications Beware of ‘Commodity Box’ trap The best hardware deal may not be good for scalability SQL Server scalable architecture Thread management (UMS) Delivers inherent efficiency for linear scalability Memory management Large memory support allows for higher logical reads I/O architecture Affinity management Agenda (cont.) Query optimization and parallelism Pulling it all together SQL Server 2000 32-bit 64-bit comparison