We are deploying an asp.net web service to Amazon EC2 which has an MSSQL 2008 data backend. We need the data backend to be highly scalable, so we have designed and built the web service to distribute data across multiple SQL Servers.
We need assistance in performance testing, monitoring and optimizing our SQL Server 2008 installation. Ideally you have experience with:
- SQL Server 2008 design, deployment and optimization
- Transactional replication