question about memory usage

Using SS2000. I'm having some timeouts on some queries from a web site and
I'm trying to figure out why they're occurring. We have some dts packages
that run every 30 minutes so there may be a conflict.
We have memory configured dynamically for min - 0 and max 3583MB. However,
when I look at System Monitor for SQL Server:Memory Manager:Total Server
Manager, the memory is always around 1,678,880(KB). It only seems to
fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes in
Use for the system, it is always around 40%. Memory Object:Available MBytes
is about 1086. Between what SS is using and the system memory available,
about 2.5G is accounted for. I don't know where the other 1G has gone to.
I'm also wondering why SS never seems to get any more than 1.6G. Is it
actually using all of the 1.6G or only a part of it? We have a 4 processor
system and even when all 4 processors are around 80% processor time, the
memory doesn't change.
Any ideas or suggestions?
Thanks,
DanDid you turn on AWE flag?
--
Eric Li
SQL DBA
MCDBA
Dan wrote:
> Using SS2000. I'm having some timeouts on some queries from a web site and
> I'm trying to figure out why they're occurring. We have some dts packages
> that run every 30 minutes so there may be a conflict.
> We have memory configured dynamically for min - 0 and max 3583MB. However,
> when I look at System Monitor for SQL Server:Memory Manager:Total Server
> Manager, the memory is always around 1,678,880(KB). It only seems to
> fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes in
> Use for the system, it is always around 40%. Memory Object:Available MBytes
> is about 1086. Between what SS is using and the system memory available,
> about 2.5G is accounted for. I don't know where the other 1G has gone to.
> I'm also wondering why SS never seems to get any more than 1.6G. Is it
> actually using all of the 1.6G or only a part of it? We have a 4 processor
> system and even when all 4 processors are around 80% processor time, the
> memory doesn't change.
> Any ideas or suggestions?
> Thanks,
> Dan
>
>|||Do you have the Enterprise version of 2000?
-John Oakes
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:OX1gKzKTEHA.3016@.tk2msftngp13.phx.gbl...
> Using SS2000. I'm having some timeouts on some queries from a web site and
> I'm trying to figure out why they're occurring. We have some dts packages
> that run every 30 minutes so there may be a conflict.
> We have memory configured dynamically for min - 0 and max 3583MB. However,
> when I look at System Monitor for SQL Server:Memory Manager:Total Server
> Manager, the memory is always around 1,678,880(KB). It only seems to
> fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
in
> Use for the system, it is always around 40%. Memory Object:Available
MBytes
> is about 1086. Between what SS is using and the system memory available,
> about 2.5G is accounted for. I don't know where the other 1G has gone to.
> I'm also wondering why SS never seems to get any more than 1.6G. Is it
> actually using all of the 1.6G or only a part of it? We have a 4 processor
> system and even when all 4 processors are around 80% processor time, the
> memory doesn't change.
> Any ideas or suggestions?
> Thanks,
> Dan
>
>|||You need to set the /3GB switch in the Boot.ini file to get use of up to 3GB
of ram for SQL Server. What you are seeing is the 2Gb minus the memtoleave
area that is reserved up front. Your timeouts are most likely due to
blocking fromt eh DTS packages though. Running sp_who2 will give you a
start as to who is blocking.
--
Andrew J. Kelly
SQL Server MVP
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:OX1gKzKTEHA.3016@.tk2msftngp13.phx.gbl...
> Using SS2000. I'm having some timeouts on some queries from a web site and
> I'm trying to figure out why they're occurring. We have some dts packages
> that run every 30 minutes so there may be a conflict.
> We have memory configured dynamically for min - 0 and max 3583MB. However,
> when I look at System Monitor for SQL Server:Memory Manager:Total Server
> Manager, the memory is always around 1,678,880(KB). It only seems to
> fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
in
> Use for the system, it is always around 40%. Memory Object:Available
MBytes
> is about 1086. Between what SS is using and the system memory available,
> about 2.5G is accounted for. I don't know where the other 1G has gone to.
> I'm also wondering why SS never seems to get any more than 1.6G. Is it
> actually using all of the 1.6G or only a part of it? We have a 4 processor
> system and even when all 4 processors are around 80% processor time, the
> memory doesn't change.
> Any ideas or suggestions?
> Thanks,
> Dan
>
>|||We're running developer.
"John Oakes" <john@.nospam.networkproductions.net> wrote in message
news:Ov2dPRLTEHA.760@.TK2MSFTNGP12.phx.gbl...
> Do you have the Enterprise version of 2000?
> -John Oakes
> "Dan" <ddonahue@.archermalmo.com> wrote in message
> news:OX1gKzKTEHA.3016@.tk2msftngp13.phx.gbl...
> > Using SS2000. I'm having some timeouts on some queries from a web site
and
> > I'm trying to figure out why they're occurring. We have some dts
packages
> > that run every 30 minutes so there may be a conflict.
> >
> > We have memory configured dynamically for min - 0 and max 3583MB.
However,
> > when I look at System Monitor for SQL Server:Memory Manager:Total Server
> > Manager, the memory is always around 1,678,880(KB). It only seems to
> > fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
> in
> > Use for the system, it is always around 40%. Memory Object:Available
> MBytes
> > is about 1086. Between what SS is using and the system memory available,
> > about 2.5G is accounted for. I don't know where the other 1G has gone
to.
> > I'm also wondering why SS never seems to get any more than 1.6G. Is it
> > actually using all of the 1.6G or only a part of it? We have a 4
processor
> > system and even when all 4 processors are around 80% processor time, the
> > memory doesn't change.
> >
> > Any ideas or suggestions?
> >
> > Thanks,
> >
> > Dan
> >
> >
> >
>|||It's not enabled. Do I need Enterprise version for that? We're running
Developer.
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:%23xaNDJLTEHA.1232@.TK2MSFTNGP09.phx.gbl...
> Did you turn on AWE flag?
> --
> Eric Li
> SQL DBA
> MCDBA
> Dan wrote:
> > Using SS2000. I'm having some timeouts on some queries from a web site
and
> > I'm trying to figure out why they're occurring. We have some dts
packages
> > that run every 30 minutes so there may be a conflict.
> >
> > We have memory configured dynamically for min - 0 and max 3583MB.
However,
> > when I look at System Monitor for SQL Server:Memory Manager:Total Server
> > Manager, the memory is always around 1,678,880(KB). It only seems to
> > fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
in
> > Use for the system, it is always around 40%. Memory Object:Available
MBytes
> > is about 1086. Between what SS is using and the system memory available,
> > about 2.5G is accounted for. I don't know where the other 1G has gone
to.
> > I'm also wondering why SS never seems to get any more than 1.6G. Is it
> > actually using all of the 1.6G or only a part of it? We have a 4
processor
> > system and even when all 4 processors are around 80% processor time, the
> > memory doesn't change.
> >
> > Any ideas or suggestions?
> >
> > Thanks,
> >
> > Dan
> >
> >
> >|||Will I be able to tell in profiler that blocking is going on? If so, can you
suggest what to look for? Otherwise, I'll have to get lucky and catch it in
current activity.
Thanks,
Dan
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OQZBBSLTEHA.3752@.TK2MSFTNGP12.phx.gbl...
> You need to set the /3GB switch in the Boot.ini file to get use of up to
3GB
> of ram for SQL Server. What you are seeing is the 2Gb minus the
memtoleave
> area that is reserved up front. Your timeouts are most likely due to
> blocking fromt eh DTS packages though. Running sp_who2 will give you a
> start as to who is blocking.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Dan" <ddonahue@.archermalmo.com> wrote in message
> news:OX1gKzKTEHA.3016@.tk2msftngp13.phx.gbl...
> > Using SS2000. I'm having some timeouts on some queries from a web site
and
> > I'm trying to figure out why they're occurring. We have some dts
packages
> > that run every 30 minutes so there may be a conflict.
> >
> > We have memory configured dynamically for min - 0 and max 3583MB.
However,
> > when I look at System Monitor for SQL Server:Memory Manager:Total Server
> > Manager, the memory is always around 1,678,880(KB). It only seems to
> > fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
> in
> > Use for the system, it is always around 40%. Memory Object:Available
> MBytes
> > is about 1086. Between what SS is using and the system memory available,
> > about 2.5G is accounted for. I don't know where the other 1G has gone
to.
> > I'm also wondering why SS never seems to get any more than 1.6G. Is it
> > actually using all of the 1.6G or only a part of it? We have a 4
processor
> > system and even when all 4 processors are around 80% processor time, the
> > memory doesn't change.
> >
> > Any ideas or suggestions?
> >
> > Thanks,
> >
> > Dan
> >
> >
> >
>|||I can't remember if developer lets you use more than 2G, regardless of the
3G switch. Maybe someone here will remember?
-John Oakes
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:%23Aar7nLTEHA.3552@.TK2MSFTNGP09.phx.gbl...
> We're running developer.
> "John Oakes" <john@.nospam.networkproductions.net> wrote in message
> news:Ov2dPRLTEHA.760@.TK2MSFTNGP12.phx.gbl...
> > Do you have the Enterprise version of 2000?
> >
> > -John Oakes
> >
> > "Dan" <ddonahue@.archermalmo.com> wrote in message
> > news:OX1gKzKTEHA.3016@.tk2msftngp13.phx.gbl...
> > > Using SS2000. I'm having some timeouts on some queries from a web site
> and
> > > I'm trying to figure out why they're occurring. We have some dts
> packages
> > > that run every 30 minutes so there may be a conflict.
> > >
> > > We have memory configured dynamically for min - 0 and max 3583MB.
> However,
> > > when I look at System Monitor for SQL Server:Memory Manager:Total
Server
> > > Manager, the memory is always around 1,678,880(KB). It only seems to
> > > fluctuate by a few MB. In looking at the Memory Object:% Committed
Bytes
> > in
> > > Use for the system, it is always around 40%. Memory Object:Available
> > MBytes
> > > is about 1086. Between what SS is using and the system memory
available,
> > > about 2.5G is accounted for. I don't know where the other 1G has gone
> to.
> > > I'm also wondering why SS never seems to get any more than 1.6G. Is it
> > > actually using all of the 1.6G or only a part of it? We have a 4
> processor
> > > system and even when all 4 processors are around 80% processor time,
the
> > > memory doesn't change.
> > >
> > > Any ideas or suggestions?
> > >
> > > Thanks,
> > >
> > > Dan
> > >
> > >
> > >
> >
> >
>|||You need Enterprise Edition to access full 4GB RAM
--
Eric Li
SQL DBA
MCDBA
Dan wrote:
> It's not enabled. Do I need Enterprise version for that? We're running
> Developer.
> "Eric.Li" <anonymous@.microsoftnews.org> wrote in message
> news:%23xaNDJLTEHA.1232@.TK2MSFTNGP09.phx.gbl...
>>Did you turn on AWE flag?
>>--
>>Eric Li
>>SQL DBA
>>MCDBA
>>Dan wrote:
>>
>>Using SS2000. I'm having some timeouts on some queries from a web site
> and
>>I'm trying to figure out why they're occurring. We have some dts
> packages
>>that run every 30 minutes so there may be a conflict.
>>We have memory configured dynamically for min - 0 and max 3583MB.
> However,
>>when I look at System Monitor for SQL Server:Memory Manager:Total Server
>>Manager, the memory is always around 1,678,880(KB). It only seems to
>>fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
> in
>>Use for the system, it is always around 40%. Memory Object:Available
> MBytes
>>is about 1086. Between what SS is using and the system memory available,
>>about 2.5G is accounted for. I don't know where the other 1G has gone
> to.
>>I'm also wondering why SS never seems to get any more than 1.6G. Is it
>>actually using all of the 1.6G or only a part of it? We have a 4
> processor
>>system and even when all 4 processors are around 80% processor time, the
>>memory doesn't change.
>>Any ideas or suggestions?
>>Thanks,
>>Dan
>>
>
>|||Bummer. Thanks.|||Andrew recommended the 3G switch. Maybe he'll know although Eric said that I need Enterprise version. So it sounds like the switch won't work
Thanks
Dan|||Andrew, can you confirm that I need Enterprise version in order to use the 3G switch
Thanks
Dan|||Actually Developer Edition has the same capabilities as EE but AWE is not
the answer with under 4GB of RAM. Just ensure the /3GB is set.
--
Andrew J. Kelly
SQL Server MVP
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:u8Gno$LTEHA.3420@.TK2MSFTNGP12.phx.gbl...
> You need Enterprise Edition to access full 4GB RAM
> --
> Eric Li
> SQL DBA
> MCDBA
> Dan wrote:
> > It's not enabled. Do I need Enterprise version for that? We're running
> > Developer.
> >
> > "Eric.Li" <anonymous@.microsoftnews.org> wrote in message
> > news:%23xaNDJLTEHA.1232@.TK2MSFTNGP09.phx.gbl...
> >
> >>Did you turn on AWE flag?
> >>
> >>--
> >>Eric Li
> >>SQL DBA
> >>MCDBA
> >>
> >>Dan wrote:
> >>
> >>
> >>Using SS2000. I'm having some timeouts on some queries from a web site
> >
> > and
> >
> >>I'm trying to figure out why they're occurring. We have some dts
> >
> > packages
> >
> >>that run every 30 minutes so there may be a conflict.
> >>
> >>We have memory configured dynamically for min - 0 and max 3583MB.
> >
> > However,
> >
> >>when I look at System Monitor for SQL Server:Memory Manager:Total
Server
> >>Manager, the memory is always around 1,678,880(KB). It only seems to
> >>fluctuate by a few MB. In looking at the Memory Object:% Committed
Bytes
> >
> > in
> >
> >>Use for the system, it is always around 40%. Memory Object:Available
> >
> > MBytes
> >
> >>is about 1086. Between what SS is using and the system memory
available,
> >>about 2.5G is accounted for. I don't know where the other 1G has gone
> >
> > to.
> >
> >>I'm also wondering why SS never seems to get any more than 1.6G. Is it
> >>actually using all of the 1.6G or only a part of it? We have a 4
> >
> > processor
> >
> >>system and even when all 4 processors are around 80% processor time,
the
> >>memory doesn't change.
> >>
> >>Any ideas or suggestions?
> >>
> >>Thanks,
> >>
> >>Dan
> >>
> >>
> >>
> >
> >
> >|||Profiler is not the best tool to look for blocking issues. These links
should help but sp_who2 will tell you right away if the DTS package is
blocking other users while running:
http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking
http://www.sql-server-performance.com/sf_block_prevention.asp Blocking
Prevention
Andrew J. Kelly
SQL Server MVP
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:OwY3VpLTEHA.3756@.TK2MSFTNGP11.phx.gbl...
> Will I be able to tell in profiler that blocking is going on? If so, can
you
> suggest what to look for? Otherwise, I'll have to get lucky and catch it
in
> current activity.
> Thanks,
> Dan
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OQZBBSLTEHA.3752@.TK2MSFTNGP12.phx.gbl...
> > You need to set the /3GB switch in the Boot.ini file to get use of up to
> 3GB
> > of ram for SQL Server. What you are seeing is the 2Gb minus the
> memtoleave
> > area that is reserved up front. Your timeouts are most likely due to
> > blocking fromt eh DTS packages though. Running sp_who2 will give you a
> > start as to who is blocking.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Dan" <ddonahue@.archermalmo.com> wrote in message
> > news:OX1gKzKTEHA.3016@.tk2msftngp13.phx.gbl...
> > > Using SS2000. I'm having some timeouts on some queries from a web site
> and
> > > I'm trying to figure out why they're occurring. We have some dts
> packages
> > > that run every 30 minutes so there may be a conflict.
> > >
> > > We have memory configured dynamically for min - 0 and max 3583MB.
> However,
> > > when I look at System Monitor for SQL Server:Memory Manager:Total
Server
> > > Manager, the memory is always around 1,678,880(KB). It only seems to
> > > fluctuate by a few MB. In looking at the Memory Object:% Committed
Bytes
> > in
> > > Use for the system, it is always around 40%. Memory Object:Available
> > MBytes
> > > is about 1086. Between what SS is using and the system memory
available,
> > > about 2.5G is accounted for. I don't know where the other 1G has gone
> to.
> > > I'm also wondering why SS never seems to get any more than 1.6G. Is it
> > > actually using all of the 1.6G or only a part of it? We have a 4
> processor
> > > system and even when all 4 processors are around 80% processor time,
the
> > > memory doesn't change.
> > >
> > > Any ideas or suggestions?
> > >
> > > Thanks,
> > >
> > > Dan
> > >
> > >
> > >
> >
> >
>|||I found this in kb 274750
"You cannot allocate more than 4 GB of physical memory to an application on Windows 2000 Server because Physical Address Extension (PAE) is not available on Microsoft Windows 2000 Server. Also, you cannot use the 3 GB switch in the Boot.ini file with Windows 2000 Server; however, you can use the 3 GB switch in the Boot.ini file with Microsoft Windows 2000 Advanced Server or Microsoft Windows Datacenter versions."
So even though SS developer will allow it Windows 2000 Server won't
Thanks for all your help Andrew, Eric and John
Dan|||I meant Windows, sorry for the confusion
--
Eric Li
SQL DBA
MCDBA
Dan wrote:
> Eric, do you mean Windows NT Enterprise or Sql Server Enterprise. In BOL I found this under Using AWE memory:
> "Standard 32-bit addresses can map a maximum of 4 GB of memory. The standard address spaces of 32-bit Microsoft Windows NT® 4.0 and Windows 2000 processes are therefore limited to 4-GB. By default, 2 GB is reserved for the operating system, and 2 GB is made available to the application. If you specify a /3GB switch in the Boot.ini file of Windows NT Enterprise Edition or Windows 2000 Advanced Server, the operating system reserves only 1 GB of the address space, and the application can access up to 3 GB."
> We're running Windows 2000 Server. This makes it sound like the it is a function of the OS rather than Sql Server. Or is it a function of both the OS and Sql Server? Of course, since we only have Windows 2000 server I guess we're out of luck anyway?
> Do you know if it's the same with Windows 2003 Server? We have that on another machine. Do you have to have Windows 2003 Advanced Server and SS Enterprise?
> Thanks
> Dan|||I didn't realize you had just Server edition of Windows. Server only
supports the /3GB for testing type purposes. If you want to use more than
2GB you need at least ADV Server of Win2K or higher and EE for SQL. Wile
Developer has the same capabilities as EE it is not legal for a production
server.
--
Andrew J. Kelly
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:43AC99B3-3040-4A0A-9DBD-B870AAE4816A@.microsoft.com...
> Well, now in the same article I find this:
> -or-Use of the /3GB switch in the Boot.ini file allows SQL Server 2000 to
use up to 3 GB of available memory.
> This seems to directly contradict the other statement in the same article.
How do I set the switch? I'll try it and see if it works.
> Thanks,
> Dan
> -- Andrew J. Kelly wrote: --
> Actually Developer Edition has the same capabilities as EE but AWE is
not
> the answer with under 4GB of RAM. Just ensure the /3GB is set.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Eric.Li" <anonymous@.microsoftnews.org> wrote in message
> news:u8Gno$LTEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > You need Enterprise Edition to access full 4GB RAM
> >> --
> > Eric Li
> > SQL DBA
> > MCDBA
> >> Dan wrote:
> >> It's not enabled. Do I need Enterprise version for that? We're
running
> >> Developer.
> >> "Eric.Li" <anonymous@.microsoftnews.org> wrote in message
> >> news:%23xaNDJLTEHA.1232@.TK2MSFTNGP09.phx.gbl...
> >>Did you turn on AWE flag?
> >>--
> >>Eric Li
> >>SQL DBA
> >>MCDBA
> >>Dan wrote:
> >>>>Using SS2000. I'm having some timeouts on some queries from
a web site
> >> and
> >>I'm trying to figure out why they're occurring. We have some
dts
> >> packages
> >>that run every 30 minutes so there may be a conflict.
> >>>We have memory configured dynamically for min - 0 and max
3583MB.
> >> However,
> >>when I look at System Monitor for SQL Server:Memory
Manager:Total
> Server
> >>Manager, the memory is always around 1,678,880(KB). It only seems
to
> >>fluctuate by a few MB. In looking at the Memory Object:%
Committed
> Bytes
> >> in
> >>Use for the system, it is always around 40%. Memory
Object:Available
> >> MBytes
> >>is about 1086. Between what SS is using and the system memory
> available,
> >>about 2.5G is accounted for. I don't know where the other 1G has
gone
> >> to.
> >>I'm also wondering why SS never seems to get any more than
1.6G. Is it
> >>actually using all of the 1.6G or only a part of it? We have a 4
> >> processor
> >>system and even when all 4 processors are around 80% processor
time,
> the
> >>memory doesn't change.
> >>>Any ideas or suggestions?
> >>>Thanks,
> >>>Dan
> >>>>>>|||See my other reply.
--
Andrew J. Kelly
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:9F281D4E-7EB7-42E9-9689-0A72436CC7BC@.microsoft.com...
> Andrew, can you confirm that I need Enterprise version in order to use the
3G switch?
> Thanks,
> Dan|||Thanks.|||If you are using Dev Ed for a production environment, you are violating the licensing agreement. So I assume
this is a test environment. Dev Ed is identical to EE, except for the licensing agreement. But, as already
communicated, you need an OS that supported /3G and/or PAE/AWE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan" <ddonahue@.archermalmo.com> wrote in message news:ueHu0nLTEHA.644@.tk2msftngp13.phx.gbl...
> It's not enabled. Do I need Enterprise version for that? We're running
> Developer.
> "Eric.Li" <anonymous@.microsoftnews.org> wrote in message
> news:%23xaNDJLTEHA.1232@.TK2MSFTNGP09.phx.gbl...
> > Did you turn on AWE flag?
> >
> > --
> > Eric Li
> > SQL DBA
> > MCDBA
> >
> > Dan wrote:
> >
> > > Using SS2000. I'm having some timeouts on some queries from a web site
> and
> > > I'm trying to figure out why they're occurring. We have some dts
> packages
> > > that run every 30 minutes so there may be a conflict.
> > >
> > > We have memory configured dynamically for min - 0 and max 3583MB.
> However,
> > > when I look at System Monitor for SQL Server:Memory Manager:Total Server
> > > Manager, the memory is always around 1,678,880(KB). It only seems to
> > > fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
> in
> > > Use for the system, it is always around 40%. Memory Object:Available
> MBytes
> > > is about 1086. Between what SS is using and the system memory available,
> > > about 2.5G is accounted for. I don't know where the other 1G has gone
> to.
> > > I'm also wondering why SS never seems to get any more than 1.6G. Is it
> > > actually using all of the 1.6G or only a part of it? We have a 4
> processor
> > > system and even when all 4 processors are around 80% processor time, the
> > > memory doesn't change.
> > >
> > > Any ideas or suggestions?
> > >
> > > Thanks,
> > >
> > > Dan
> > >
> > >
> > >
>|||Standard edition of Windows 2003 server supports the /3gb switch. If you
have more then 4gb of memory you have to go to EE of Windows 2003 Server
Rick
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23B2jB$STEHA.2944@.tk2msftngp13.phx.gbl...
> If you are using Dev Ed for a production environment, you are violating
the licensing agreement. So I assume
> this is a test environment. Dev Ed is identical to EE, except for the
licensing agreement. But, as already
> communicated, you need an OS that supported /3G and/or PAE/AWE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dan" <ddonahue@.archermalmo.com> wrote in message
news:ueHu0nLTEHA.644@.tk2msftngp13.phx.gbl...
> > It's not enabled. Do I need Enterprise version for that? We're running
> > Developer.
> >
> > "Eric.Li" <anonymous@.microsoftnews.org> wrote in message
> > news:%23xaNDJLTEHA.1232@.TK2MSFTNGP09.phx.gbl...
> > > Did you turn on AWE flag?
> > >
> > > --
> > > Eric Li
> > > SQL DBA
> > > MCDBA
> > >
> > > Dan wrote:
> > >
> > > > Using SS2000. I'm having some timeouts on some queries from a web
site
> > and
> > > > I'm trying to figure out why they're occurring. We have some dts
> > packages
> > > > that run every 30 minutes so there may be a conflict.
> > > >
> > > > We have memory configured dynamically for min - 0 and max 3583MB.
> > However,
> > > > when I look at System Monitor for SQL Server:Memory Manager:Total
Server
> > > > Manager, the memory is always around 1,678,880(KB). It only seems to
> > > > fluctuate by a few MB. In looking at the Memory Object:% Committed
Bytes
> > in
> > > > Use for the system, it is always around 40%. Memory Object:Available
> > MBytes
> > > > is about 1086. Between what SS is using and the system memory
available,
> > > > about 2.5G is accounted for. I don't know where the other 1G has
gone
> > to.
> > > > I'm also wondering why SS never seems to get any more than 1.6G. Is
it
> > > > actually using all of the 1.6G or only a part of it? We have a 4
> > processor
> > > > system and even when all 4 processors are around 80% processor time,
the
> > > > memory doesn't change.
> > > >
> > > > Any ideas or suggestions?
> > > >
> > > > Thanks,
> > > >
> > > > Dan
> > > >
> > > >
> > > >
> >
> >
>|||Thank you Rick and Tibor.