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 |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2004-07-21 : 16:06:55
|
| If I am running SQL2000 Win2000 and I have say 3 different SQL instances running on the server. Can I update say service pack levels on each of them seperately. Do they have to be done seperately. Reason why I'm asking is I have several different applications and not all applications can run on say SQL2000 SP3 or SP4. So I guess the question is can instances be at different different service pack levels when it comes to SQL.Also, how does the memory allocation work for instances. If I have 2 GB physical RAM on the server. Does my first instance use up all 2GB or is it divided or is it first come first get bases...Last but not least what ports are used for clients to communicate to SQL....Again Any feedback is appreciated..Thanks,Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-21 : 16:40:18
|
| Installing service packs are run once for each instance. So you can run sp3a on instance 1 and sp2 on instance 2. To change the memory options for an instance, use sp_configure. By default, each instance can use all of the memory on the server. So one instance could severely impact another instance. 2GB does not sound like enough for a server that has multiple instances.Default port is 1433 for default instance. I believe it increments by one for each additional named instance.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-21 : 16:48:25
|
| As Tara said, you do need to set up a maximum for each instance. 2gb could be enough if you aren't doing much or just have a very small amount of users for testing or something. If you have application that won't run under SP3a, you need to turn them off. This is an EXTREMELY SERIOUS risk to your business. SP 3a was important enough to require an emergency release by many companies.When you set up a new instance, it will give you a default, but you can change it to whatever you want. I prefer to use a set schema for mine so it's easy to document and track. For example, I would use 1549 for default, 1649, and 1749.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
SQL Instances