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 |
|
chilluk
Starting Member
24 Posts |
 Posted - 2002-04-15 : 10:35:02
|
| I have 2 servers which originally were set up so one would replicate certain tables to another (i.e. one was the publisher, one the subscriber). If the publisher would fail, the subscriber would also run very slowly indeed, so I broke apart the replication by deleting both the publication and subscription.I next tried using stored procedures to do the same job, and added one server as a linked server to the other. Same symptoms.I now use DTS to export data as text to a share on the opposite server, and then import that data in via DTS, so there are no obvious links anymore. I have deleted the reference to the linked server.However, I still get the slowdown on one when the other crashes.Is it a result of the historic links that seem to make one server dependant on the other? Anyone else seen this behaviour - how do I make sure they are seperate?Thanks.Chris Hillchris@softwarefirst.com |
|
|
MuadDBA
628 Posts |
Posted - 2002-04-16 : 14:10:35
|
| Have you tried to use profiler to see what's going on? That would be a good first step. |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-16 : 15:11:52
|
quote:
Have you tried to use profiler to see what's going on? That would be a good first step.
Naw....my first question is why are your servers crashing so much? That sounds like the bigger problem...<O> |
|
|
|
sqlxpert
Starting Member
11 Posts |
Posted - 2002-04-16 : 15:23:21
|
| hi chillukfirst thing, pls specify the veersion. At i found at the first glance is that there you are porting the data but what about indexes, also when you say slow you need to check the hardware configration, cpu utilization and other things.I am also running T-replication on my site on sql 7.0 SP3 and this is working absoultely fine when publisher is not available only thing i do is reindexing and recompiling the SPs , hope this will help you if not do share the details.AB |
|
|
|
chilluk
Starting Member
24 Posts |
Posted - 2002-04-17 : 07:02:58
|
| I am using SQL 2000 Standard SP2.I have this morning disabled publications on the first server, so I'll see how it goes.You are right - the frequest crashes are the biggest problem, but I have been unable to get over this as yet - hence we added a server to try and stabilize things - despite help from forums and even from good old Microsoft themselves.I have posted here before I think on this - we run several large websites from what was a single SQL database (now split across 2 servers and db's). We have problems with it locking up every so often - usually when we refresh the data from a raw text source which is done via DTS package into temp tables and SP's to copy data over. This runs every 2 hours as it's fast moving data - but often it crashes all sites at once. Any new ideas/comments from people who have got over this will help stop me going completely mad!!Thanks all!!Chris Hillchris@softwarefirst.com |
|
|
|
|
|
|
|
|
Seperate Servers