We have a production database that sits on server1.
This database has transactional replication. There is a replicated database that sits on server2. On server2 there are other databases that READ from the replicated database.
Our admins have noticed that there are deadlocks getting created in the replicated database. So the developers have requested for a second replicated instances. This request has been turned down with a note - Another replicated instance would put a load
on the production database that sits on sqlserver1.
How do you collect stats to prove or disprove this statement?
This is SQL Server 2008 (not R2)
Edited byc-sharp-coderFriday, March 28, 2014 6:06 PMversion of sql server.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.