February 20, 2007 at 8:49 am
I have clustered sql server environment with 8 Gig memory on each node. We have allocated 6 gig on each node to sql server. I am being asked to move a 150 gig db on to this environment. I have collected some info on resource usage of this db on its original box. at this point in task manager the sqlmanager.exe process is only acquiring 4 kb.
is there any better way for me to do an impact analysis of moving this db to the clustered environment?
February 20, 2007 at 8:57 am
Not sure what you're asking, really. The sqlmanager.exe process is for the little icon that sits in your system tray and tells you whether SQL Server is running or not. You need to look at sqlservr.exe to see how much memory SQL Server is using. If you are using AWE then the memory shown in Task Manager might not be accurate anyway - you should query the sysperfinfo table or use performance counters instead.
I think the best answer to your question is this: test it before you put it into production.
John
February 20, 2007 at 9:26 am
oops.. I am sorry I meant to type stats for sqlservr.exe . here is what I want to find out? Will moving this db from box xyz to clustered sql server have any negative impact on the performance of clustered sql server? how do go about making sure that the move will not negatively impact the new environment?
hope its clear.
February 21, 2007 at 1:51 am
That all depends on how much the database is used. If, for example, you're running queries that return large result sets then you may be filling up the buffer cache, to the detriment of other databases. If you are using a large amount of memory with AWE this may not be such a problem, but bear in mind the extended memory can only be used for caching data, and not for storing locks or execution plans. Also, will you be putting the new database on the same disk as existing ones? You should consider the effect on disk IO of doing this.
John
February 21, 2007 at 7:26 am
yes it will be put on the same disk as existing databases. isnt there a way to calculate I/O of the old server? or measure the load. that way at least I would know what to expect from adding the new db to the cluster.
February 21, 2007 at 11:01 am
You can use performance monitor to find I/O stats.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply