Re: SQL active/active questions



Generally you want enough memory on both nodes to satisfy the requirements
of each instance in the event of a failover. Each node can only access
databases that are in the resources for that node. Resources do not span
nodes. They share the same storage facilities but not the same drives. Have
a look at these:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EUEBG
http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp
http://www.support.microsoft.com/?id=254321


--
Andrew J. Kelly SQL MVP

"Jonildo Santos" <jonildosantos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ePS0a%234pGHA.1440@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I Have some questions as regards the cluster of the SQL Server
active/active.
- Which I calculate of memory for the environment to it?
- The two virtual nodes will access to same data base?
- The two nodes will be accessing the same storage shared?
Thanks!





.



Relevant Pages

  • Re: REGION=0M and LSQA
    ... At the time, memory was very expensive, and we ... remaining storage and always issued a return code zero. ... programs actually worked in production, ... all of the resources used by the job up until that point ...
    (bit.listserv.ibm-main)
  • Re: A realistic price comparison
    ... > Spreading Apple FUD is just as bad as spreading Microsoft FUD. ... > However, I assure you, I had more than enough resources on my XP ... > instilled in them by having limited memory and disk space early on. ...
    (comp.sys.mac.advocacy)
  • Re: Alternatives to C: ObjectPascal, Eiffel, Ada or Modula-3?
    ... pretty much have memory bugs, ... having to do manual cleanups for 100% of your resources or for only 1%? ... This is a slight problem in languages like Java that have GC but no flow-control abstraction. ... Languages like Lisp and Smalltalk are another story: it's easy to have a with-open flow control construct that runs some subordinate code and then cleans up, and to have this be the standard way to use such things. ...
    (comp.programming)
  • Re: Fork bombing a Linux machine as a non-root user
    ... It is past time for the linux enthusiats touting linux as more ... systems limited resources (CPU time, physical memory, and so on). ...
    (Fedora)
  • Re: When will ZFS become stable?
    ... Pipe buffer memory and a few other things are still allocated from separate maps, ... In fact, this was one of the known issues with the introduction of large cluster sizes without resource limits: address space and memory use were potentially unbounded, so Randall recently properly implemented the resource limits on mbuf clusters of large sizes. ... Handling resource exhaustion is a tricky issue, because sometimes it takes resources to make resources available. ...
    (freebsd-current)

Loading