Discussion Locked

W2K+SQL Server Hardware Upgrade

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm coming back into my 'day job' in IT after a 2 year break and one of my many tasks is to upgrade a production W2K+SQL Server. I have tried to suggest a new platform may be appropriate, but cant convince them to spend the money. Alas, that's a different issue.

Anyhow, I reckon it needs a boost to 4GB RAM (from 1 GB) and also it could do with a 2nd array to move the transaction logs onto. I'm happy enough with carrying out the physical upgrade in terms of plugging in the components. I am, however, a little concerned with how both SQL & Windows will deal with this new hardware configuration.

Does anyone out have experience of beefing up an exisiting server? Is SQL happy with suddenly finding more memory? Is it complicated to move the trans logs to a different disk.

Thanks in advance

1 reply

by deepsand

Try the "Questions" forum; the "Discussion" forum is for matters of general discussion, not specific problems in search of a solution.

Post problems such as this to the "Question" forum, rather than the "Discussion" forum. There are those who specifically seek out problems in need of a solution, and that's where they go to look for such.

Additionally there are the benefits that:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The revised TR makes it quite difficult to find both "Discussions" and "Questions" that have not had a fairly recent post, owing to some functions comingling them in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for.

This discussion is closed to new replies.