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 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2008-07-08 : 11:07:09
|
| Guys,We have recently added a new SQL Server 2000 instance, which has identical database structure as a few other servers we had. We have transaction replication set up, and this server was added as a subscriber, getting all its data from the publisher. Now, while its data is identical to all the rest of the subscribers, it is not yet used by our clients (i.e. it is not yet considered a production server). As such, I wanted to take this opportunity to tune it as much as possible (since it is sort of in its downtime).Could anyone advise what is best to be done at this point in time?For example, should I rebuild the indexes or do anything else?Thank you for any input! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-07-08 : 13:29:23
|
| Thank you for the information. We have almost all of these set up.Any other suggestions?Thank you |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 13:32:14
|
| Look at link I provided for Funnel Technique:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106128 |
|
|
|
|
|
|
New Server/database to do list