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 |
|
salim71
Starting Member
4 Posts |
 Posted - 2011-08-10 : 08:18:03
|
| Hello everyone,I have a customized application which replicates data in to sql server 2008 r2. the database is created in sql server 2008 once you installed the customized application (i assumed by means of scripts). Recently i have noticed that the database itself keeps growing and when the replicator program is running it takes a long time to replicate all the data and data is also missing. Can anyone give me any hint of what might be wrong and how i can resolve that? How can i increase the performance of sql server?Any help is highly appreciated. Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-08-10 : 08:22:06
|
| What do you mean by database growing ? What exactly is growing the data file or the log file ?PBUH |
 |
|
|
salim71
Starting Member
4 Posts |
Posted - 2011-08-10 : 08:40:41
|
| the data file is growing |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-08-10 : 08:44:34
|
| Does the "Distribution clean up: distribution" job run? It cleans up previously replicated commands...- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-08-10 : 08:49:29
|
| have you tried to monitor the replicaion using replication monitor ?PBUH |
|
|
|
salim71
Starting Member
4 Posts |
Posted - 2011-08-10 : 09:41:58
|
| no i haven't used it since i am not using replication in sql server 2008 r2, its a third party application which replicates data to sql server. Should i still use the replication monitor?Thanks for your assistance. |
|
|
|
|
|
|
SQL Server Database