1) Analyze all SQL to get subtree costs to
minimal to make application scalable
2) Performance testing. Creating mega databses with SQL scripts to simulate application
database growth over a 10-15 year period.
3) Enhancing Performance and Scalability through Caching
4) Analyzing database statistics, caps on memory in machineconfig.sys, caps on memory for
SQLManager.exe,use of indexes
5) Understanding the difference in parallelism for CPUs that have more than 1 processor
6) Running a SQL trace. Running the Index Tunning Wizard with a workload to get index
recommendations on clustered vs not clustered indexes.