Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kuldip
Starting Member
4 Posts |
 Posted - 2014-03-13 : 23:08:00
|
| I have transactional replication on sql server 2008r2 database and crystal reports 2008 are linked to this database which is very slow. If I link the crystal reports to production database then crystal reports are very fast but when I link to this replicated database which is replicated from production database then it is very slow. Please help me where i am doing something wrong. |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2014-03-14 : 11:38:34
|
| Is the replicated database on the other side of a firewall?djj |
 |
|
|
Lunatic
Starting Member
3 Posts |
Posted - 2014-03-18 : 14:16:21
|
| Spend please more details about the topology, because it has many variables. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-03-18 : 14:44:03
|
| Did you apply indexes to the subscriber database? Do you have an update stats job on it?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
sql server 2008r2 replication