Re: Physical/Vertial node cluster memory setup?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You are running SQL Clustering on VMWare?

I am struggling to find a polite way to question your sanity. Give it a few months of trying to support this and you will likely be doing the same.

Seriously, this is not a stable configuration, nor is it one you want to support if you like sleeping nights or being NOT in the office on weekends. Get the MSCS cluster back to bare metal and start over.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP





"Jerry Cutshaw" <JerryCutshaw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9EBC83C4-292F-4507-8163-22BCA2B2A55F@xxxxxxxxxxxxxxxx
Hello,
I have a Physical/Virtual node MSCS failover cluster. I am running 64bit
SQL 2005 and Windows 2003. I have read enough posts that indicate you in 64
bit SQL Server you should set the max memory. Unfortunately my physical box
has 32 GB of memory (I could utilize all of it!) and my virtual server node
(VMWare ESX) can only support 16 GB. My question is:

1. Is it possible to configure the two different nodes to use a different
max server memory?
2. If #1 isn't possible what happens if I configure max server memory to
say 24 GB and the server fails over to the virtual node? Will SQL Server
perform a soft crash dump everytime it gets loaded up?
3. I have found references to the "lock pages in memory" on the forums does
this come into play as a possible solution to my problem?

Thank you in advance for your replies.

Jerry L. Cutshaw

.

Relevant Pages

  • Re: Performance problems -- need guidance on scaling
    ... Thanks for the update on the FT Catalog corruption, ... will use, up to a max of 512Mb, if this memory is available. ... a server with 512 MB of RAM and a resource_usage value of 5 ... the data, you could, detach your SQL 2000 mdf & ldf files ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Memory Issues
    ... Exchange and SQL Server. ... you identified memory problems and large amounts of paging. ...
    (microsoft.public.sqlserver.setup)
  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)