August 10, 2011 at 6:19 am
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 third party 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
August 10, 2011 at 6:24 am
Why are you using replication? Is this for DR, or something like reporting?
Much less complex (to the user) than replication is mirroring and log-shipping.
You mentioned that the database is growing, by what %? And how much growth did you anticipate?
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
August 10, 2011 at 6:44 am
sql server 2008 replication is not involved , its more of reporting
growth around 10-15 %
August 10, 2011 at 6:47 am
This sounds like it's pretty vendor specific, I don't know the app, so I won't speculate on what's wrong.
As for performance:
Add RAM
Add Disks
Get faster disks
Add CPU's
Stop unnecvessary services
Migrate other DB's to other servers
etc...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
August 10, 2011 at 6:50 am
thank you
August 10, 2011 at 6:51 am
can anyone give me some guidelines (tips and tricks) on fine tuning sql server 2008 r2 database ?
Thank You
August 10, 2011 at 8:20 am
sal-295209 (8/10/2011)
can anyone give me some guidelines (tips and tricks) on fine tuning sql server 2008 r2 database ? my email is sali2610@hotmail.comThank You
Take a look at my signature line. Read the book on performance tuning. It has more tips & tricks than you can shake stick at.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2011 at 8:29 am
thank you
August 10, 2011 at 8:34 am
sal-295209 (8/10/2011)
can anyone give me some guidelines (tips and tricks) on fine tuning sql server 2008 r2 database ? my email is <obfuscated>Thank You
I hope you like spam. If not, I'd edit your e-mail out ;-).
August 10, 2011 at 9:21 am
noooooooooooooooooooooooooooo
August 10, 2011 at 9:26 am
sal-295209 (8/10/2011)
noooooooooooooooooooooooooooo
You should be fine :-P.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply