Re: SQL Memory - The SQL Server can not use more than 2GB
From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/12/04
- Next message: Andrew J. Kelly: "Re: DBCC DBREINDEX and DBCC INDEXDEFRAG not defragging indexes"
- Previous message: Joe Mine: "Re: Merge Agent error number 53 for replication"
- In reply to: Yuri G.Quaresma: "Re: SQL Memory - The SQL Server can not use more than 2GB"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 23:00:55 -0500
I meant YOU should open a case with PSS. They would need to deal directly with you to figure out what is wrong. Since I don't see anything wrong in the output you listed there is nothing more I can do.
--
Andrew J. Kelly SQL MVP
"Yuri G.Quaresma" <yquaresma@gmx.net> wrote in message news:exPVND6BEHA.1588@tk2msftngp13.phx.gbl...
Andrew,
Any news?
"Andrew J. Kelly" <sqlmvpnoooospam@shadhawk.com> wrote in message news:%234nnjgYBEHA.1548@TK2MSFTNGP12.phx.gbl...
I don't see anything wrong in these traces so I am not sure what is going on. I would double check to ensure the /3GB switch is in fact set correctly. If so you may want to open a case with MS PSS.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
"Yuri G.Quaresma" <yquaresma@gmx.net> wrote in message news:u1ogEWUBEHA.2308@tk2msftngp13.phx.gbl...
Andrew,
Here they are:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask -2147483648 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 0 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 3072 3072
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 512 512
nested triggers 0 1 1 1
network packet size (B) 512 65536 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 0 0
scan for startup procs 0 1 0 0
set working set size 0 1 0 0
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 0 0
SQLDIAG
[System Summary]
OS Name : Microsoft Windows 2000 Advanced Server
Version : 5.0.2195 Service Pack 3 Build 2195
OS Manufacturer : Microsoft Corporation
System Manufacturer : IBM
System Model : eserver xSeries 235 -[867111X]-
System Type : X86-based PC
Processor x86 : Family 15 Model 2 Stepping 4 GenuineIntel ~1795 Mhz
Processor x86 : Family 15 Model 2 Stepping 4 GenuineIntel ~1795 Mhz
Processor x86 : Family 15 Model 2 Stepping 4 GenuineIntel ~1796 Mhz
Processor x86 : Family 15 Model 2 Stepping 4 GenuineIntel ~1796 Mhz
BIOS Version : 07/14/03
Time Zone : E. South America Standard Time
Total Physical Memory : 3,931,588 KB
Available Physical Memory: 3,033,316 KB
Total Virtual Memory : 9,791,212 KB
Available Virtual Memory : 8,142,028 KB
Page File Space : 5,859,624 KB
Page File : C:\pagefile.sys
"Andrew J. Kelly" <sqlmvpnoooospam@shadhawk.com> wrote in message news:eTaUEZRBEHA.3064@tk2msftngp13.phx.gbl...
> How much memory is on the machine? Can you post the output of
> sp_configure?
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Yuri G.Quaresma" <yquaresma@gmx.net> wrote in message
> news:e5anY0QBEHA.2888@TK2MSFTNGP09.phx.gbl...
> > Andrew,
> > I am sure that the versions are corrects.
> > Isnt it strange?
> >
> > "Andrew J. Kelly" <sqlmvpnoooospam@shadhawk.com> wrote in message
> > news:uoIPSUyAEHA.356@TK2MSFTNGP10.phx.gbl...
> > > Howmuch memory do you actually have? Are you sure of the editions of
> the
> > OS
> > > and SQL Server?
> > >
> > > --
> > > Andrew J. Kelly SQL MVP
> > >
> > >
> > > "Yuri G.Quaresma" <yquaresma@gmx.net> wrote in message
> > > news:OfgTT1tAEHA.1076@TK2MSFTNGP12.phx.gbl...
> > > > Hi,
> > > >
> > > > This is my server cluster configuration:
> > > > Windows 2000 Advanced Server SP3
> > > > SQL Enterprise Edition SP3a
> > > >
> > > > I have this cluster configured as active-active and each node there is
> > an
> > > > instance of SQL Server 2000.
> > > > My problem is that each instance just use 1.5Gb of memory in each
> node.
> > I
> > > > have configured the SQL Server memory to use dinamic allocation and
> > > included
> > > > the BOOT.INI parameter /3GB.
> > > >
> > > > I have identified the maximum SQL Server memory using Performance
> > Monitor.
> > > > When I have set the SQL to use fixed memory in more than 2GB, it
> starts
> > > and
> > > > make the SQL Server counters disapeared in Performance Monitor, when a
> > set
> > > > the memory to use dinamically allocation I can use the counters again.
> > > >
> > > > Am I missing something? Is it correct?
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Andrew J. Kelly: "Re: DBCC DBREINDEX and DBCC INDEXDEFRAG not defragging indexes"
- Previous message: Joe Mine: "Re: Merge Agent error number 53 for replication"
- In reply to: Yuri G.Quaresma: "Re: SQL Memory - The SQL Server can not use more than 2GB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
