I need to do some Benchmarking and first establish some baseline performance metrics.
What are the steps involved.
Requirements: Replication from Production system (OLTP) DB Server TO a BI / Reporting DB Server, both running SQL Server 2008.
I want to Benchmark Throughput, Response Time, and establish baseline performance measures, then as the transaction increase and system grows over time I can do some trending and analysis.
I know that Benchmarking involves COMPARISION of performance between two systems or entities. Could someone help me get started.
Secondly, is there a SQL SCRIPT or Program that I could use to do data collection and measurements OR do you have to by a Tool or Benchmark application?