troubleshooting Question

Replicate SQL activity from production to pre-production server

Avatar of Admin_IT
Admin_IT asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
21 Comments2 Solutions304 ViewsLast Modified:
Production DB: 15GB
ServerA: Windows Server 2000 Standard, SQL 2000 Standard, Quad Xeon MP 1.8ghz,  4 GB RAM
ServerB: Windows Server 2003 Enterprise 64bit, SQL 2005 Standard 64bit, Quad Xeon MP 3.16ghz,  8 GB RAM

Question:
How can I replicate the activity on ServerA to ServerB (transaction by transaction) so we can observe, over a time, the performance differences from ServerA compared to ServerB?

Additional Information:
Our production DB is running on ServerA. Given the RAM limitations of ServerA's OS/SQL software, we cannot use the entire 4 GB of ram. The DB is about 15 GB and we need to have as much in RAM as possible. This leads to significant performance problems, locking, blocking, headaches and user complaints.

Segway to ServerB.

We want to migrate to ServerB as soon as possible; however, we want to test ServerB's capabilities to determine the amount of performance improvements this will give us before actually migrating. It is configured with the same drives, RAID, just updated software and MUCH faster hardware.
There is a monitoring workstation running Idera SQL Diagnostic Manager so we can look at a side-by-side comparison.

Next Step:
Upgrading ServerA to Windows Server 2003 Enterprise, SQL 2005 Stanard (32-bit). The idea is to better leverage the hardware and create a mirror instance and another instance for development staff to use.

We are not married to this plan and open to suggestions if there is a better one which can be suggested.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 21 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros