March 6, 2014 at 8:00 am
We have a performance issue on one of our server and we are moving one of our tiny database (10gb) on to the server as well when server is quiet but the database will be accessed (readonly) next morning. There is no memory or CPU contention performance issue is because of poor performing query which we have identified and working on it. But my concern is moving db (10gb) will have any impact on the performance of the server
thanks
March 6, 2014 at 8:43 am
You will have some contention during the restore or attach process to the new server (this should not impact the existing server). Without knowing whether or not you have a busy OLTP system or what the current performance issues are (you mention it's not RAM or CPU), then it's really hard to tell you much further information.
You will have a down time for the database being moved....but a 10GB database really isn't going to take long to move (unless your network is connected with 100MB pipes and not gigabit :-))
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply