Re: Performance discrepancy between two boxes on an active/active?

Well, things look OK there. On the box that's slow, I'd be tempted to put
in the /PAE switch explicitly, just to see if it is taking you seriously on
the DEP thing.

Also, what happens when you run just one instance on that box? Is the
performance OK? If not, what happens when you crank up the memory for that
one instance (temporarily)?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"M Bourgon" <bourgon@xxxxxxxxx> wrote in message
news:13929192-7544-4e0e-9ae7-e8ec91ff3df6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Mar 24, 11:34 am, "Tom Moreau" <t...@xxxxxxxxxxxxxxxxxxxx> wrote:
OK. How much RAM do these servers have?

16gb each, but we have the amounts capped to 8gb and 6gb, so that if
they're on the same box, we don't have memory issues.

.

Relevant Pages

  • Re: FTS Performance in SQL 2005
    ... Can you post you query plans and the output of statistics IO ... SQL Server MVP ... Because i've set the MAX sql-server memory to 3.5 GB instead of 4.0 GB ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL 2005 SP2 Memory
    ... SQL Server MVP ... I looked at the memory and it appears that the applications are only using ... SQLServer:Buffer Manager - Buffer cache hit ratio ... with the default memory settings. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Data Execution Prevention
    ... >>DEP prevents malicious code from executing from protected areas of memory. ... > It has no inherent notion of "maliciousness". ...
    (microsoft.public.windowsxp.general)
  • Re: SQL 2005 SP2 Memory
    ... I looked at the memory and it appears that the applications are only using ... "Tom Moreau" wrote: ... SQL Server MVP ... SQLServer:Buffer Manager - Buffer cache hit ratio ...
    (microsoft.public.sqlserver.clustering)
  • Re: XP or Media Center Edition not working ???
    ... Physical Memory ... hardware-enforced DEP. ... my son deleted the Doctor Watson programs in Windows and I am ... Microsoft Windows Media Center 2005. ...
    (microsoft.public.windowsxp.general)