Merge Module with Verbose Logging?

Is this possible?
When troubleshooting MSDE install issues in the field, verbose logging
would be nice. But as far as I can see, it's only available for the
standalone install (/L*v), and not the merge module.
I should probably add that my install is an Installshield-based
compressed setup.exe.

Memory setting on a Cluster

Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machine has 4 GB o Physical Memory (RAM), but I want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have differentes memory configuration in a cluster?
2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
Thanks a lot!!
AA
I forgot to mention that both machine are with 32 bits processors
Thanks again
AA
"AA" <aa@.personal.net.py> wrote in message
news:%23qJn80MIEHA.3848@.tk2msftngp13.phx.gbl...
> Hello, I am purchasing a HP DL-380 (Cluster)
> I am planing to install Windows 2003 and SQL 2000
> Both machine has 4 GB o Physical Memory (RAM), but I want to put 6 GB in
the
> Active Machine and 2 GB in the Passive Machine.
> So, That is possible?
> 1) Is possible to have differentes memory configuration in a cluster?
> 2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
>
> Thanks a lot!!
>
> AA
>
|||1. Yes, it is possible. Not sure why you'd want to do it though.
2. Yes, it is supported as long as you enable AWE.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||1. ) because an error in the requirement the cluster come with 4 GB Memory
each, but I think that the Active Server must be more powerful
In the current environment we have installed SQL 2000 in a single machine
dual processor and is UP without restart (the OS and the DB) for more that 6
months, without any kind of problems. In two years we NEVER have any
problems with our SQL 2000 database. I am very happy
So, I want to use the Pasive machine just for emergencies (when the Active
Failure) and increment the Active server power.
Is that ok?
Thanks Michael
AA
"Michael Hotek" <mhotek@.nomail.com> wrote in message
news:u6MKyDSIEHA.3968@.TK2MSFTNGP12.phx.gbl...
> 1. Yes, it is possible. Not sure why you'd want to do it though.
> 2. Yes, it is supported as long as you enable AWE.
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>
|||Yes, you can do that. You just need to recognize that if you ever have to
fail over, you can have some performance issues.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Memory management (fixed memory, AWE)

Hi,

I am going to install SQL Server 2000 (then SQL 2K5) on a Win Server 2K3 with 8 GB of ram, but it will be 16 GB in the near future.

I would like to reserve a fixed memory (for momemt less than 3-4 GB) for SQL Server and the rest for application (virtualization).

Without AWE enabled, max memory for SQL Server 2K5 is 4GB as for SQL Server 2000?

How can I manage and optimize memory keeping in mind AWE. (any doc, website available?)

Thank

I forgot to write that SQL server is 2000 Standard Ed:

On Windows Server 2003, max memory is 2 or 4 GB

And in the case of SQL Server 2K5?

Thank

|||

I am a bit confused by your questions but I can tell you that SQL 2005 Std. edition UNLIKE 2000's max memory is only bound by the OS it runs on. Thus I have deployed sql 2005 std on 2003 server ent. with 16GBs of memory in them.

Derek

|||fasttrack, did this solve your problems? Can you update thread?|||

Thank,

how to solve:

/PAE for win server 2003 Enterprise edition.

If SQL server 2000 Std, not enable AW, because max memory is 4 gb.

If SQL server 2000 Ent AWE enable to take advantage of all memory available. Setted max memory for other applications.

If SQL server 2005, both std and Ent AWE is enable. Max memory setted for others applications

Memory management (fixed memory, AWE)

Hi,

I am going to install SQL Server 2000 (then SQL 2K5) on a Win Server 2K3 with 8 GB of ram, but it will be 16 GB in the near future.

I would like to reserve a fixed memory (for momemt less than 3-4 GB) for SQL Server and the rest for application (virtualization).

Without AWE enabled, max memory for SQL Server 2K5 is 4GB as for SQL Server 2000?

How can I manage and optimize memory keeping in mind AWE. (any doc, website available?)

Thank

I forgot to write that SQL server is 2000 Standard Ed:

On Windows Server 2003, max memory is 2 or 4 GB

And in the case of SQL Server 2K5?

Thank

|||

I am a bit confused by your questions but I can tell you that SQL 2005 Std. edition UNLIKE 2000's max memory is only bound by the OS it runs on. Thus I have deployed sql 2005 std on 2003 server ent. with 16GBs of memory in them.

Derek

|||fasttrack, did this solve your problems? Can you update thread?|||

Thank,

how to solve:

/PAE for win server 2003 Enterprise edition.

If SQL server 2000 Std, not enable AW, because max memory is 4 gb.

If SQL server 2000 Ent AWE enable to take advantage of all memory available. Setted max memory for other applications.

If SQL server 2005, both std and Ent AWE is enable. Max memory setted for others applications