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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-20 : 07:54:23
|
| Mark writes "Hi !I have a site that is running a very large database with people always logged in. When we run optimisation queries it has a significant effect on speed for people using the system.Is it possible to run optimisation on a copy of the data on a different machine and then transfer the 'tuning' to the live machine to reduce the effect on the users ?Many thanksMark" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-20 : 07:57:58
|
| The only way to do that (that springs to mind) is to run the optimization on the other server, back up the database, then restore it to the production machine. You would lose any changes that were made during that optimization window, and the database will be unavailable while it's being restored, so you don't gain anything.I currently run optimizations in phases, I'll reindex small tables (<100,000 rows) periodically while they're little usage on the server, and do the larger ones during a maintenance window. The point is not to do the entire database or your most heavily used tables all at once. It's better not to use the Maintenance wizard or plans for this because it doesn't give you that kind of control. |
 |
|
|
|
|
|
Can I run optimisation on one machine and transfer it