I need to add an operator to sql server 2000, but for some reason, the email
isn't getting sent out to them.
I have them configured the same as me, and have sent them email several
times, but they haven't received it. I even added my email address to the
"name" in there, and I haven't gotten email addressed to them, but my email
as another operator seems to work fine.
Is there a log of email that is accumulated on sql server's logfiles or
something that you can tell if it's left the server yet?
Any help appreciated.
Thanks,
SC
try xp_sendmail in Query Analyzer. It will show errors on failure.
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>
|||This seems to work fine.
However, when I go to the Operators menu on the tree for the server, and put
in an email address to send it to & then click test, it says it sends it.
However, neither of us are receiving it.
On another operator tab, it'll do the same thing. It had been sending me an
email when a job completed.
SC
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:e7K$LVxeEHA.3632@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> try xp_sendmail in Query Analyzer. It will show errors on failure.
>
> "Goober at christianDOTnet" <me@.privacy.net> wrote in message
> news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> email
the
> email
>
|||If it is working for some operators, but not others.
1. Try sending an email to the failed email address directly ( outside SQL )
to make sure the email is working.
2. drop the operator and re-add the operator in SQL Agent, Be sure to use
the entire email address.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>
Showing posts with label configured. Show all posts
Showing posts with label configured. Show all posts
Thursday, March 8, 2012
adding operator to sql server 2000
I need to add an operator to sql server 2000, but for some reason, the email
isn't getting sent out to them.
I have them configured the same as me, and have sent them email several
times, but they haven't received it. I even added my email address to the
"name" in there, and I haven't gotten email addressed to them, but my email
as another operator seems to work fine.
Is there a log of email that is accumulated on sql server's logfiles or
something that you can tell if it's left the server yet?
Any help appreciated.
Thanks,
SCtry xp_sendmail in Query Analyzer. It will show errors on failure.
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>|||This seems to work fine.
However, when I go to the Operators menu on the tree for the server, and put
in an email address to send it to & then click test, it says it sends it.
However, neither of us are receiving it.
On another operator tab, it'll do the same thing. It had been sending me an
email when a job completed.
SC
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:e7K$LVxeEHA.3632@.TK2MSFTNGP09.phx.gbl...
> try xp_sendmail in Query Analyzer. It will show errors on failure.
>
> "Goober at christianDOTnet" <me@.privacy.net> wrote in message
> news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> email
the[vbcol=seagreen]
> email
>|||If it is working for some operators, but not others.
1. Try sending an email to the failed email address directly ( outside SQL )
to make sure the email is working.
2. drop the operator and re-add the operator in SQL Agent, Be sure to use
the entire email address.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>
isn't getting sent out to them.
I have them configured the same as me, and have sent them email several
times, but they haven't received it. I even added my email address to the
"name" in there, and I haven't gotten email addressed to them, but my email
as another operator seems to work fine.
Is there a log of email that is accumulated on sql server's logfiles or
something that you can tell if it's left the server yet?
Any help appreciated.
Thanks,
SCtry xp_sendmail in Query Analyzer. It will show errors on failure.
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>|||This seems to work fine.
However, when I go to the Operators menu on the tree for the server, and put
in an email address to send it to & then click test, it says it sends it.
However, neither of us are receiving it.
On another operator tab, it'll do the same thing. It had been sending me an
email when a job completed.
SC
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:e7K$LVxeEHA.3632@.TK2MSFTNGP09.phx.gbl...
> try xp_sendmail in Query Analyzer. It will show errors on failure.
>
> "Goober at christianDOTnet" <me@.privacy.net> wrote in message
> news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
>|||If it is working for some operators, but not others.
1. Try sending an email to the failed email address directly ( outside SQL )
to make sure the email is working.
2. drop the operator and re-add the operator in SQL Agent, Be sure to use
the entire email address.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>
adding operator to sql server 2000
I need to add an operator to sql server 2000, but for some reason, the email
isn't getting sent out to them.
I have them configured the same as me, and have sent them email several
times, but they haven't received it. I even added my email address to the
"name" in there, and I haven't gotten email addressed to them, but my email
as another operator seems to work fine.
Is there a log of email that is accumulated on sql server's logfiles or
something that you can tell if it's left the server yet?
Any help appreciated.
Thanks,
SCtry xp_sendmail in Query Analyzer. It will show errors on failure.
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>|||This seems to work fine.
However, when I go to the Operators menu on the tree for the server, and put
in an email address to send it to & then click test, it says it sends it.
However, neither of us are receiving it.
On another operator tab, it'll do the same thing. It had been sending me an
email when a job completed.
SC
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:e7K$LVxeEHA.3632@.TK2MSFTNGP09.phx.gbl...
> try xp_sendmail in Query Analyzer. It will show errors on failure.
>
> "Goober at christianDOTnet" <me@.privacy.net> wrote in message
> news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> > I need to add an operator to sql server 2000, but for some reason, the
> email
> > isn't getting sent out to them.
> >
> > I have them configured the same as me, and have sent them email several
> > times, but they haven't received it. I even added my email address to
the
> > "name" in there, and I haven't gotten email addressed to them, but my
> email
> > as another operator seems to work fine.
> >
> > Is there a log of email that is accumulated on sql server's logfiles or
> > something that you can tell if it's left the server yet?
> >
> > Any help appreciated.
> >
> > Thanks,
> >
> > SC
> >
> >
> >
>|||If it is working for some operators, but not others.
1. Try sending an email to the failed email address directly ( outside SQL )
to make sure the email is working.
2. drop the operator and re-add the operator in SQL Agent, Be sure to use
the entire email address.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
email
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
email
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>
isn't getting sent out to them.
I have them configured the same as me, and have sent them email several
times, but they haven't received it. I even added my email address to the
"name" in there, and I haven't gotten email addressed to them, but my email
as another operator seems to work fine.
Is there a log of email that is accumulated on sql server's logfiles or
something that you can tell if it's left the server yet?
Any help appreciated.
Thanks,
SCtry xp_sendmail in Query Analyzer. It will show errors on failure.
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>|||This seems to work fine.
However, when I go to the Operators menu on the tree for the server, and put
in an email address to send it to & then click test, it says it sends it.
However, neither of us are receiving it.
On another operator tab, it'll do the same thing. It had been sending me an
email when a job completed.
SC
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:e7K$LVxeEHA.3632@.TK2MSFTNGP09.phx.gbl...
> try xp_sendmail in Query Analyzer. It will show errors on failure.
>
> "Goober at christianDOTnet" <me@.privacy.net> wrote in message
> news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> > I need to add an operator to sql server 2000, but for some reason, the
> > isn't getting sent out to them.
> >
> > I have them configured the same as me, and have sent them email several
> > times, but they haven't received it. I even added my email address to
the
> > "name" in there, and I haven't gotten email addressed to them, but my
> > as another operator seems to work fine.
> >
> > Is there a log of email that is accumulated on sql server's logfiles or
> > something that you can tell if it's left the server yet?
> >
> > Any help appreciated.
> >
> > Thanks,
> >
> > SC
> >
> >
> >
>|||If it is working for some operators, but not others.
1. Try sending an email to the failed email address directly ( outside SQL )
to make sure the email is working.
2. drop the operator and re-add the operator in SQL Agent, Be sure to use
the entire email address.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Goober at christianDOTnet" <me@.privacy.net> wrote in message
news:OSoim4weEHA.3348@.TK2MSFTNGP12.phx.gbl...
> I need to add an operator to sql server 2000, but for some reason, the
> isn't getting sent out to them.
> I have them configured the same as me, and have sent them email several
> times, but they haven't received it. I even added my email address to the
> "name" in there, and I haven't gotten email addressed to them, but my
> as another operator seems to work fine.
> Is there a log of email that is accumulated on sql server's logfiles or
> something that you can tell if it's left the server yet?
> Any help appreciated.
> Thanks,
> SC
>
>
Tuesday, March 6, 2012
Adding more RAM for MS SQL Server 2000
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar
No. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:
>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machine
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
>more gigabytes of RAM into the machine and I want to allow the SQL Server to
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it to
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>
|||Hi,
This will work out if your SQL server 2000 edition is Enterprise or Developer. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:OvpsIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. If you wanted to address > 4GB of RAM then you would have to start playing with AWE but <= 4GB is addressable with normal windows memory addressing & therefore normal MSSQL dynamic memory management.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Oskar wrote:
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar
No. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:
>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machine
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
>more gigabytes of RAM into the machine and I want to allow the SQL Server to
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it to
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>
|||Hi,
This will work out if your SQL server 2000 edition is Enterprise or Developer. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:OvpsIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. If you wanted to address > 4GB of RAM then you would have to start playing with AWE but <= 4GB is addressable with normal windows memory addressing & therefore normal MSSQL dynamic memory management.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Oskar wrote:
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar
Adding more RAM for MS SQL Server 2000
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
--
Many thanks,
OskarThis is a multi-part message in MIME format.
--060508000204080606090209
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
No. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:
>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machine
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
>more gigabytes of RAM into the machine and I want to allow the SQL Server to
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it to
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>
--060508000204080606090209
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>No. All you have to do is add the /3GB switch to boot.ini and
reboot. If you wanted to address > 4GB of RAM then you would have
to start playing with AWE but <= 4GB is addressable with normal
windows memory addressing & therefore normal MSSQL dynamic memory
management.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Oskar wrote:
<blockquote cite="midDA9DCAEE-A7F3-4E04-986C-97D1E43CDE91@.microsoft.com"
type="cite">
<pre wrap="">Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
--
Many thanks,
Oskar
</pre>
</blockquote>
</body>
</html>
--060508000204080606090209--|||This is a multi-part message in MIME format.
--=_NextPart_000_004D_01C565EC.8E52DE90
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Hi,
This will work out if your SQL server 2000 edition is Enterprise or =Developer. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:OvpsIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. = If you wanted to address > 4GB of RAM then you would have to start =playing with AWE but <=3D 4GB is addressable with normal windows memory =addressing & therefore normal MSSQL dynamic memory management.
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
Oskar wrote: Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at =my hand. The SQL Server is configured for dynamic memory allocation. The =machine had 2GB of RAM in it when I installed the SQL Server. Now I've installed =two more gigabytes of RAM into the machine and I want to allow the SQL =Server to use a total of 3GB of RAM (by means of turning on the /3GB switch in =Windows boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling =it to use the additional gigabyte of RAM?
--
Many thanks,
Oskar
--=_NextPart_000_004D_01C565EC.8E52DE90
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
This will work out if your SQL server =2000 edition is Enterprise or Developer. Standard edition can support a maximum of 2 =GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" wrote in message news:OvpsIwbZFHA.4088=@.TK2MSFTNGP15.phx.gbl...No. All you have to do is add the /3GB switch to boot.ini and =reboot. If you wanted to address > 4GB of RAM then you would have to start playing =with AWE but <=3D 4GB is addressable with normal windows memory =addressing & therefore normal MSSQL dynamic memory management.
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com Oskar wrote: Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at =my hand. The SQL Server is configured for dynamic memory allocation. The =machine had 2GB of RAM in it when I installed the SQL Server. Now I've installed =two more gigabytes of RAM into the machine and I want to allow the SQL =Server to use a total of 3GB of RAM (by means of turning on the /3GB switch in =Windows boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling =it to use the additional gigabyte of RAM?
--
Many thanks,
Oskar
--=_NextPart_000_004D_01C565EC.8E52DE90--
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
--
Many thanks,
OskarThis is a multi-part message in MIME format.
--060508000204080606090209
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
No. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:
>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machine
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
>more gigabytes of RAM into the machine and I want to allow the SQL Server to
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it to
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>
--060508000204080606090209
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>No. All you have to do is add the /3GB switch to boot.ini and
reboot. If you wanted to address > 4GB of RAM then you would have
to start playing with AWE but <= 4GB is addressable with normal
windows memory addressing & therefore normal MSSQL dynamic memory
management.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Oskar wrote:
<blockquote cite="midDA9DCAEE-A7F3-4E04-986C-97D1E43CDE91@.microsoft.com"
type="cite">
<pre wrap="">Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
--
Many thanks,
Oskar
</pre>
</blockquote>
</body>
</html>
--060508000204080606090209--|||This is a multi-part message in MIME format.
--=_NextPart_000_004D_01C565EC.8E52DE90
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Hi,
This will work out if your SQL server 2000 edition is Enterprise or =Developer. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:OvpsIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. = If you wanted to address > 4GB of RAM then you would have to start =playing with AWE but <=3D 4GB is addressable with normal windows memory =addressing & therefore normal MSSQL dynamic memory management.
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
Oskar wrote: Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at =my hand. The SQL Server is configured for dynamic memory allocation. The =machine had 2GB of RAM in it when I installed the SQL Server. Now I've installed =two more gigabytes of RAM into the machine and I want to allow the SQL =Server to use a total of 3GB of RAM (by means of turning on the /3GB switch in =Windows boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling =it to use the additional gigabyte of RAM?
--
Many thanks,
Oskar
--=_NextPart_000_004D_01C565EC.8E52DE90
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
This will work out if your SQL server =2000 edition is Enterprise or Developer. Standard edition can support a maximum of 2 =GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson"
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com Oskar wrote: Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at =my hand. The SQL Server is configured for dynamic memory allocation. The =machine had 2GB of RAM in it when I installed the SQL Server. Now I've installed =two more gigabytes of RAM into the machine and I want to allow the SQL =Server to use a total of 3GB of RAM (by means of turning on the /3GB switch in =Windows boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling =it to use the additional gigabyte of RAM?
--
Many thanks,
Oskar
--=_NextPart_000_004D_01C565EC.8E52DE90--
Adding more RAM for MS SQL Server 2000
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machin
e
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
OskarNo. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:
>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machi
ne
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed tw
o
>more gigabytes of RAM into the machine and I want to allow the SQL Server t
o
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Window
s
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it t
o
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>|||Hi,
This will work out if your SQL server 2000 edition is Enterprise or Develope
r. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:Ovp
sIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. If yo
u wanted to address > 4GB of RAM then you would have to start playing with A
WE but <= 4GB is addressable with normal windows memory addressing & therefo
re normal MSSQL dynamic memory management.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Oskar wrote:
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machin
e
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machin
e
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
OskarNo. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:
>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machi
ne
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed tw
o
>more gigabytes of RAM into the machine and I want to allow the SQL Server t
o
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Window
s
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it t
o
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>|||Hi,
This will work out if your SQL server 2000 edition is Enterprise or Develope
r. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:Ovp
sIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. If yo
u wanted to address > 4GB of RAM then you would have to start playing with A
WE but <= 4GB is addressable with normal windows memory addressing & therefo
re normal MSSQL dynamic memory management.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Oskar wrote:
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machin
e
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar
Subscribe to:
Posts (Atom)