Benchmark for different edition SQL 2000

We want to select the edition between standard and enterprise. Our usage
1) 10 users/application connect to the server at the same tim
2) 5000 row insert per da
3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000 serve
4) One database will be installe
5) The size of the database around 10G
Because we want to replace the existing SQL6.5 with 400MHz 256MRAM database server
Please advise. ThanksHi,
Based on your configurations and settings I will recommend you to go for SQL
Server standard edition.
Have a look into the below link in choosing the edition of sql server:-
http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
Thanks
Hari
MCDBA
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> We want to select the edition between standard and enterprise. Our usage:
> 1) 10 users/application connect to the server at the same time
> 2) 5000 row insert per day
> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000 server
> 4) One database will be installed
> 5) The size of the database around 10GB
> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
database server.
> Please advise. Thanks|||Hari
Thanks for your advice. However, I have read the page before and without any idea. The point of availability is confused me. In fact, the standard edition and enterprise edition is no different except
--Scalability ( useless to us because we only have 1 CPU machine with 512MRAM
--Availability/uptime (useless to us because we don't have a standby or cluster machine
--Performance (Time is not so critical because we are just using the 6.5 version now with no complain
--Advanced analysis ( Analysis is not so critical because we are just using the 6.5 version now with no complain
I just concern, is it enterprise edition is more stable? or standard edition is easy to down
Wanchu
-- Hari Prasad wrote: --
Hi
Based on your configurations and settings I will recommend you to go for SQ
Server standard edition
Have a look into the below link in choosing the edition of sql server:
http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.as
Thank
Har
MCDB
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com..
> We want to select the edition between standard and enterprise. Our usage
> 1) 10 users/application connect to the server at the same tim
> 2) 5000 row insert per da
> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000 serve
> 4) One database will be installe
> 5) The size of the database around 10G
>> Because we want to replace the existing SQL6.5 with 400MHz 256MRA
database server
> Please advise. Thank|||No edition is any more or less stable than any others. It is mainly
features and capacity. Standard edition will do just fine for your needs.
--
Andrew J. Kelly SQL MVP
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com...
> Hari,
> Thanks for your advice. However, I have read the page before and without
any idea. The point of availability is confused me. In fact, the standard
edition and enterprise edition is no different except?
> --Scalability ( useless to us because we only have 1 CPU machine with
512MRAM)
> --Availability/uptime (useless to us because we don't have a standby or
cluster machine)
> --Performance (Time is not so critical because we are just using the 6.5
version now with no complain)
> --Advanced analysis ( Analysis is not so critical because we are just
using the 6.5 version now with no complain)
> I just concern, is it enterprise edition is more stable? or standard
edition is easy to down?
> Wanchun
>
> -- Hari Prasad wrote: --
> Hi,
> Based on your configurations and settings I will recommend you to go
for SQL
> Server standard edition.
> Have a look into the below link in choosing the edition of sql
server:-
> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> Thanks
> Hari
> MCDBA
>
> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> > We want to select the edition between standard and enterprise. Our
usage:
> > 1) 10 users/application connect to the server at the same time
> > 2) 5000 row insert per day
> > 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000
server
> > 4) One database will be installed
> > 5) The size of the database around 10GB
> >> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
> database server.
> > Please advise. Thanks
>
>|||Andrew
That mean from our requirement, standard edition is enough for us
Also, the memory arrangement is the same between standard and enterprise? I am testing with standard edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After I re-boot the machine, the memory back to 10M..... Is it I need to re-boot the machine every week to prevent the memory to grow' Or enterprise edition can handle it better
Any other Enterprise features that better than Standard
Thank
-- Andrew J. Kelly wrote: --
No edition is any more or less stable than any others. It is mainl
features and capacity. Standard edition will do just fine for your needs
--
Andrew J. Kelly SQL MV
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com..
> Hari
>> Thanks for your advice. However, I have read the page before and withou
any idea. The point of availability is confused me. In fact, the standar
edition and enterprise edition is no different except
>> --Scalability ( useless to us because we only have 1 CPU machine wit
512MRAM
> --Availability/uptime (useless to us because we don't have a standby o
cluster machine
> --Performance (Time is not so critical because we are just using the 6.
version now with no complain
> --Advanced analysis ( Analysis is not so critical because we are jus
using the 6.5 version now with no complain
>> I just concern, is it enterprise edition is more stable? or standar
edition is easy to down
>> Wanchu
>> -- Hari Prasad wrote: --
>> Hi
>> Based on your configurations and settings I will recommend you to g
for SQ
> Server standard edition
>> Have a look into the below link in choosing the edition of sq
server:
>> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.as
>> Thank
> Har
> MCDB
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com..
>> We want to select the edition between standard and enterprise. Ou
usage
>> 1) 10 users/application connect to the server at the same tim
>> 2) 5000 row insert per da
>> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 200
serve
>> 4) One database will be installe
>> 5) The size of the database around 10G
>> Because we want to replace the existing SQL6.5 with 400MHz 256MRA
> database server
>> Please advise. Thank
>>|||Enterprise edition has some distinct features that SE doesn't. You find them at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
As for memory, please read below:
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com...
> Andrew,
> That mean from our requirement, standard edition is enough for us?
> Also, the memory arrangement is the same between standard and enterprise? I am testing with standard
edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After I re-boot the
machine, the memory back to 10M..... Is it I need to re-boot the machine every week to prevent the memory to
grow' Or enterprise edition can handle it better?
> Any other Enterprise features that better than Standard?
> Thanks
>
>
> -- Andrew J. Kelly wrote: --
> No edition is any more or less stable than any others. It is mainly
> features and capacity. Standard edition will do just fine for your needs.
> --
> Andrew J. Kelly SQL MVP
>
> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com...
> > Hari,
> >> Thanks for your advice. However, I have read the page before and without
> any idea. The point of availability is confused me. In fact, the standard
> edition and enterprise edition is no different except?
> >> --Scalability ( useless to us because we only have 1 CPU machine with
> 512MRAM)
> > --Availability/uptime (useless to us because we don't have a standby or
> cluster machine)
> > --Performance (Time is not so critical because we are just using the 6.5
> version now with no complain)
> > --Advanced analysis ( Analysis is not so critical because we are just
> using the 6.5 version now with no complain)
> >> I just concern, is it enterprise edition is more stable? or standard
> edition is easy to down?
> >> Wanchun
> >> -- Hari Prasad wrote: --
> >> Hi,
> >> Based on your configurations and settings I will recommend you to go
> for SQL
> > Server standard edition.
> >> Have a look into the below link in choosing the edition of sql
> server:-
> >> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >> Thanks
> > Hari
> > MCDBA
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> > news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> >> We want to select the edition between standard and enterprise. Our
> usage:
> >> 1) 10 users/application connect to the server at the same time
> >> 2) 5000 row insert per day
> >> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000
> server
> >> 4) One database will be installed
> >> 5) The size of the database around 10GB
> >> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
> > database server.
> >> Please advise. Thanks
> >>|||Tibor
My concern is how to prevent the SQL server that increase the memory usage continuously? Or We need to reboot the machine periodically? Please advise
Wanchu
-- Tibor Karaszi wrote: --
Enterprise edition has some distinct features that SE doesn't. You find them at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.as
As for memory, please read below
INF: SQL Server Memory Usag
http://support.microsoft.com/default.aspx?scid=kb;en-us;q32136
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.as
--
Tibor Karaszi, SQL Server MV
http://www.karaszi.com/sqlserver/default.as
http://www.solidqualitylearning.com
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com..
> Andrew
>> That mean from our requirement, standard edition is enough for us
> Also, the memory arrangement is the same between standard and enterprise? I am testing with standar
edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After I re-boot th
machine, the memory back to 10M..... Is it I need to re-boot the machine every week to prevent the memory t
grow' Or enterprise edition can handle it better
>> Any other Enterprise features that better than Standard
>> Thank
>> -- Andrew J. Kelly wrote: --
>> No edition is any more or less stable than any others. It is mainl
> features and capacity. Standard edition will do just fine for your needs
>> --
> Andrew J. Kelly SQL MV
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
> news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com..
>> Hari
>> Thanks for your advice. However, I have read the page before and withou
> any idea. The point of availability is confused me. In fact, the standar
> edition and enterprise edition is no different except
>> --Scalability ( useless to us because we only have 1 CPU machine wit
> 512MRAM
>> --Availability/uptime (useless to us because we don't have a standby o
> cluster machine
>> --Performance (Time is not so critical because we are just using the 6.
> version now with no complain
>> --Advanced analysis ( Analysis is not so critical because we are jus
> using the 6.5 version now with no complain
>> I just concern, is it enterprise edition is more stable? or standar
> edition is easy to down
>> Wanchu
>> -- Hari Prasad wrote: --
>> Hi
>> Based on your configurations and settings I will recommend you to g
> for SQ
>> Server standard edition
>> Have a look into the below link in choosing the edition of sq
> server:
>> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.as
>> Thank
>> Har
>> MCDB
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
>> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com..
>> We want to select the edition between standard and enterprise. Ou
> usage
>> 1) 10 users/application connect to the server at the same tim
>> 2) 5000 row insert per da
>> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 200
> serve
>> 4) One database will be installe
>> 5) The size of the database around 10G
>> Because we want to replace the existing SQL6.5 with 400MHz 256MRA
>> database server
>> Please advise. Thank
>>|||Please read the links I posted about memory allocation algorithms in SQL Server. This is normal, and no reboot
is necessary.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
news:DF073FD2-4A17-4122-BCEC-E9FB5E5AF5EF@.microsoft.com...
> Tibor,
> My concern is how to prevent the SQL server that increase the memory usage continuously? Or We need to
reboot the machine periodically? Please advise.
> Wanchun
> -- Tibor Karaszi wrote: --
> Enterprise edition has some distinct features that SE doesn't. You find them at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> As for memory, please read below:
> INF: SQL Server Memory Usage
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
> http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com...
> > Andrew,
> >> That mean from our requirement, standard edition is enough for us?
> > Also, the memory arrangement is the same between standard and enterprise? I am testing with standard
> edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After I re-boot
the
> machine, the memory back to 10M..... Is it I need to re-boot the machine every week to prevent the
memory to
> grow' Or enterprise edition can handle it better?
> >> Any other Enterprise features that better than Standard?
> >> Thanks
> >> -- Andrew J. Kelly wrote: --
> >> No edition is any more or less stable than any others. It is mainly
> > features and capacity. Standard edition will do just fine for your needs.
> >> --
> > Andrew J. Kelly SQL MVP
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> > news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com...
> >> Hari,
> >> Thanks for your advice. However, I have read the page before and without
> > any idea. The point of availability is confused me. In fact, the standard
> > edition and enterprise edition is no different except?
> >> --Scalability ( useless to us because we only have 1 CPU machine with
> > 512MRAM)
> >> --Availability/uptime (useless to us because we don't have a standby or
> > cluster machine)
> >> --Performance (Time is not so critical because we are just using the 6.5
> > version now with no complain)
> >> --Advanced analysis ( Analysis is not so critical because we are just
> > using the 6.5 version now with no complain)
> >> I just concern, is it enterprise edition is more stable? or standard
> > edition is easy to down?
> >> Wanchun
> >> -- Hari Prasad wrote: --
> >> Hi,
> >> Based on your configurations and settings I will recommend you to go
> > for SQL
> >> Server standard edition.
> >> Have a look into the below link in choosing the edition of sql
> > server:-
> >> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >> Thanks
> >> Hari
> >> MCDBA
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> >> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> >> We want to select the edition between standard and enterprise. Our
> > usage:
> >> 1) 10 users/application connect to the server at the same time
> >> 2) 5000 row insert per day
> >> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000
> > server
> >> 4) One database will be installed
> >> 5) The size of the database around 10GB
> >> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
> >> database server.
> >> Please advise. Thanks
> >>|||As Tibor points out that is normal behavior and will be the same for both
Std and EE.
Andrew J. Kelly SQL MVP
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
news:DF073FD2-4A17-4122-BCEC-E9FB5E5AF5EF@.microsoft.com...
> Tibor,
> My concern is how to prevent the SQL server that increase the memory
usage continuously? Or We need to reboot the machine periodically? Please
advise.
> Wanchun
> -- Tibor Karaszi wrote: --
> Enterprise edition has some distinct features that SE doesn't. You
find them at:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> As for memory, please read below:
> INF: SQL Server Memory Usage
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
> http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com...
> > Andrew,
> >> That mean from our requirement, standard edition is enough for us?
> > Also, the memory arrangement is the same between standard and
enterprise? I am testing with standard
> edition, the memory continue to grow from 10M to 110M after I
inserted 3000 records. After I re-boot the
> machine, the memory back to 10M..... Is it I need to re-boot the
machine every week to prevent the memory to
> grow' Or enterprise edition can handle it better?
> >> Any other Enterprise features that better than Standard?
> >> Thanks
> >> -- Andrew J. Kelly wrote: --
> >> No edition is any more or less stable than any others. It is
mainly
> > features and capacity. Standard edition will do just fine for
your needs.
> >> --
> > Andrew J. Kelly SQL MVP
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in
message
> > news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com...
> >> Hari,
> >> Thanks for your advice. However, I have read the page before and
without
> > any idea. The point of availability is confused me. In fact,
the standard
> > edition and enterprise edition is no different except?
> >> --Scalability ( useless to us because we only have 1 CPU machine
with
> > 512MRAM)
> >> --Availability/uptime (useless to us because we don't have a
standby or
> > cluster machine)
> >> --Performance (Time is not so critical because we are just using
the 6.5
> > version now with no complain)
> >> --Advanced analysis ( Analysis is not so critical because we are
just
> > using the 6.5 version now with no complain)
> >> I just concern, is it enterprise edition is more stable? or
standard
> > edition is easy to down?
> >> Wanchun
> >> -- Hari Prasad wrote: --
> >> Hi,
> >> Based on your configurations and settings I will recommend
you to go
> > for SQL
> >> Server standard edition.
> >> Have a look into the below link in choosing the edition of
sql
> > server:-
> >>
http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >> Thanks
> >> Hari
> >> MCDBA
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in
message
> >> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> >> We want to select the edition between standard and enterprise.
Our
> > usage:
> >> 1) 10 users/application connect to the server at the same time
> >> 2) 5000 row insert per day
> >> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window
2000
> > server
> >> 4) One database will be installed
> >> 5) The size of the database around 10GB
> >> Because we want to replace the existing SQL6.5 with 400MHz
256MRAM
> >> database server.
> >> Please advise. Thanks
> >>|||Thanks again Tibor, however, if SQL used all the physical memory of the machine, then the SQL can still run smoothly? or better reboot the machine
Wanchu
-- Tibor Karaszi wrote: --
Please read the links I posted about memory allocation algorithms in SQL Server. This is normal, and no reboo
is necessary
--
Tibor Karaszi, SQL Server MV
http://www.karaszi.com/sqlserver/default.as
http://www.solidqualitylearning.com
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
news:DF073FD2-4A17-4122-BCEC-E9FB5E5AF5EF@.microsoft.com..
> Tibor
> My concern is how to prevent the SQL server that increase the memory usage continuously? Or We need t
reboot the machine periodically? Please advise
>> Wanchu
>> -- Tibor Karaszi wrote: --
>> Enterprise edition has some distinct features that SE doesn't. You find them at
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.as
>> As for memory, please read below
>> INF: SQL Server Memory Usag
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q32136
>> http://www.mssqlserver.com/faq/troubleshooting-memoryleak.as
>> --
> Tibor Karaszi, SQL Server MV
> http://www.karaszi.com/sqlserver/default.as
> http://www.solidqualitylearning.com
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
> news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com..
>> Andrew
>> That mean from our requirement, standard edition is enough for us
>> Also, the memory arrangement is the same between standard and enterprise? I am testing with standar
> edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After I re-boo
th
> machine, the memory back to 10M..... Is it I need to re-boot the machine every week to prevent th
memory t
> grow' Or enterprise edition can handle it better
>> Any other Enterprise features that better than Standard
>> Thank
>>> -- Andrew J. Kelly wrote: --
>> No edition is any more or less stable than any others. It is mainl
>> features and capacity. Standard edition will do just fine for your needs
>> --
>> Andrew J. Kelly SQL MV
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
>> news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com..
>> Hari
>> Thanks for your advice. However, I have read the page before and withou
>> any idea. The point of availability is confused me. In fact, the standar
>> edition and enterprise edition is no different except
>> --Scalability ( useless to us because we only have 1 CPU machine wit
>> 512MRAM
>> --Availability/uptime (useless to us because we don't have a standby o
>> cluster machine
>> --Performance (Time is not so critical because we are just using the 6.
>> version now with no complain
>> --Advanced analysis ( Analysis is not so critical because we are jus
>> using the 6.5 version now with no complain
>> I just concern, is it enterprise edition is more stable? or standar
>> edition is easy to down
>> Wanchu
>> -- Hari Prasad wrote: --
>> Hi
>> Based on your configurations and settings I will recommend you to g
>> for SQ
>> Server standard edition
>> Have a look into the below link in choosing the edition of sq
>> server:
>> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.as
>> Thank
>> Har
>> MCDB
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
>> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com..
>> We want to select the edition between standard and enterprise. Our
>> usage:
>> 1) 10 users/application connect to the server at the same time
>> 2) 5000 row insert per day
>> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000
>> server
>> 4) One database will be installed
>> 5) The size of the database around 10GB
>> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
>> database server.
>> Please advise. Thanks
>>|||The purpose if buying memory is for it to be used. SQL Server does just that. Yes, it is normal for a SQL
Server installation to see all memory being used. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wanhcun" <anonymous@.discussions.microsoft.com> wrote in message
news:70CBBAD5-7E54-4EB8-9A9C-3EBDEBF2A674@.microsoft.com...
> Thanks again Tibor, however, if SQL used all the physical memory of the machine, then the SQL can still run
smoothly? or better reboot the machine?
> Wanchun
> -- Tibor Karaszi wrote: --
> Please read the links I posted about memory allocation algorithms in SQL Server. This is normal, and no
reboot
> is necessary.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> news:DF073FD2-4A17-4122-BCEC-E9FB5E5AF5EF@.microsoft.com...
> > Tibor,
> > My concern is how to prevent the SQL server that increase the memory usage continuously? Or We
need to
> reboot the machine periodically? Please advise.
> >> Wanchun
> >> -- Tibor Karaszi wrote: --
> >> Enterprise edition has some distinct features that SE doesn't. You find them at:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> >> As for memory, please read below:
> >> INF: SQL Server Memory Usage
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
> >> http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
> >> --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> > news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com...
> >> Andrew,
> >> That mean from our requirement, standard edition is enough for us?
> >> Also, the memory arrangement is the same between standard and enterprise? I am testing with standard
> > edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After I
re-boot
> the
> > machine, the memory back to 10M..... Is it I need to re-boot the machine every week to prevent
the
> memory to
> > grow' Or enterprise edition can handle it better?
> >> Any other Enterprise features that better than Standard?
> >> Thanks
> >>> -- Andrew J. Kelly wrote: --
> >> No edition is any more or less stable than any others. It is mainly
> >> features and capacity. Standard edition will do just fine for your needs.
> >> --
> >> Andrew J. Kelly SQL MVP
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> >> news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com...
> >> Hari,
> >> Thanks for your advice. However, I have read the page before and without
> >> any idea. The point of availability is confused me. In fact, the standard
> >> edition and enterprise edition is no different except?
> >> --Scalability ( useless to us because we only have 1 CPU machine with
> >> 512MRAM)
> >> --Availability/uptime (useless to us because we don't have a standby or
> >> cluster machine)
> >> --Performance (Time is not so critical because we are just using the 6.5
> >> version now with no complain)
> >> --Advanced analysis ( Analysis is not so critical because we are just
> >> using the 6.5 version now with no complain)
> >> I just concern, is it enterprise edition is more stable? or standard
> >> edition is easy to down?
> >> Wanchun
> >> -- Hari Prasad wrote: --
> >> Hi,
> >> Based on your configurations and settings I will recommend you to go
> >> for SQL
> >> Server standard edition.
> >> Have a look into the below link in choosing the edition of sql
> >> server:-
> >> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >> Thanks
> >> Hari
> >> MCDBA
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> >> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> >> We want to select the edition between standard and enterprise. Our
> >> usage:
> >> 1) 10 users/application connect to the server at the same time
> >> 2) 5000 row insert per day
> >> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000
> >> server
> >> 4) One database will be installed
> >> 5) The size of the database around 10GB
> >> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
> >> database server.
> >> Please advise. Thanks
> >>|||Tibor
This is because my machine only contain 512 MRAM... then we need to set the "maximun memory" of SQL server around 400M and let 100M memory that can be used by the OS? Please advise.Thanks...
Regards
Wanchu
-- Tibor Karaszi wrote: --
The purpose if buying memory is for it to be used. SQL Server does just that. Yes, it is normal for a SQ
Server installation to see all memory being used. :-
--
Tibor Karaszi, SQL Server MV
http://www.karaszi.com/sqlserver/default.as
http://www.solidqualitylearning.com
"Wanhcun" <anonymous@.discussions.microsoft.com> wrote in messag
news:70CBBAD5-7E54-4EB8-9A9C-3EBDEBF2A674@.microsoft.com..
> Thanks again Tibor, however, if SQL used all the physical memory of the machine, then the SQL can still ru
smoothly? or better reboot the machine
>> Wanchu
>> -- Tibor Karaszi wrote: --
>> Please read the links I posted about memory allocation algorithms in SQL Server. This is normal, and n
reboo
> is necessary
>> --
> Tibor Karaszi, SQL Server MV
> http://www.karaszi.com/sqlserver/default.as
> http://www.solidqualitylearning.com
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
> news:DF073FD2-4A17-4122-BCEC-E9FB5E5AF5EF@.microsoft.com..
>> Tibor
>> My concern is how to prevent the SQL server that increase the memory usage continuously? Or W
need t
> reboot the machine periodically? Please advise
>> Wanchu
>> -- Tibor Karaszi wrote: --
>> Enterprise edition has some distinct features that SE doesn't. You find them at
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.as
>> As for memory, please read below
>> INF: SQL Server Memory Usag
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;q32136
>> http://www.mssqlserver.com/faq/troubleshooting-memoryleak.as
>> --
>> Tibor Karaszi, SQL Server MV
>> http://www.karaszi.com/sqlserver/default.as
>> http://www.solidqualitylearning.com
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
>> news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com..
>> Andrew
>> That mean from our requirement, standard edition is enough for us
>> Also, the memory arrangement is the same between standard and enterprise? I am testing with standar
>> edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After
re-boo
> th
>> machine, the memory back to 10M..... Is it I need to re-boot the machine every week to preven
th
> memory t
>> grow' Or enterprise edition can handle it better
>> Any other Enterprise features that better than Standard
>> Thank
>>> -- Andrew J. Kelly wrote: --
>> No edition is any more or less stable than any others. It is mainl
>> features and capacity. Standard edition will do just fine for your needs
>> --
>> Andrew J. Kelly SQL MV
>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in messag
>> news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com..
>> Hari
>> Thanks for your advice. However, I have read the page before and withou
>> any idea. The point of availability is confused me. In fact, the standar
>> edition and enterprise edition is no different except
>> --Scalability ( useless to us because we only have 1 CPU machine wit
>> 512MRAM
>> --Availability/uptime (useless to us because we don't have a standby o
>> cluster machine
>> --Performance (Time is not so critical because we are just using the 6.
>> version now with no complain
>> --Advanced analysis ( Analysis is not so critical because we are just
>> using the 6.5 version now with no complain)
>> I just concern, is it enterprise edition is more stable? or standard
>> edition is easy to down?
>> Wanchun
>> -- Hari Prasad wrote: --
>> Hi,
>> Based on your configurations and settings I will recommend you to go
>> for SQL
>> Server standard edition.
>> Have a look into the below link in choosing the edition of sql
>> server:-
>> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
>> Thanks
>> Hari
>> MCDBA
>>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
>> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
>> We want to select the edition between standard and enterprise. Our
>> usage:
>> 1) 10 users/application connect to the server at the same time
>> 2) 5000 row insert per day
>> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000
>> server
>> 4) One database will be installed
>> 5) The size of the database around 10GB
>> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
>> database server.
>> Please advise. Thanks
>>|||The fact that you only have 512 MB doesn't change the memory allocation algorithms. SQL Server will use the
memory in the machine (but of course leave space for OS and a little bit more). But sure, you can set a max if
you absolutely want to...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
news:3D73FA4A-D85C-40BF-BC30-D2F32E57602B@.microsoft.com...
> Tibor,
> This is because my machine only contain 512 MRAM... then we need to set the "maximun memory" of SQL server
around 400M and let 100M memory that can be used by the OS? Please advise.Thanks....
> Regards,
> Wanchun
> -- Tibor Karaszi wrote: --
> The purpose if buying memory is for it to be used. SQL Server does just that. Yes, it is normal for a
SQL
> Server installation to see all memory being used. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Wanhcun" <anonymous@.discussions.microsoft.com> wrote in message
> news:70CBBAD5-7E54-4EB8-9A9C-3EBDEBF2A674@.microsoft.com...
> > Thanks again Tibor, however, if SQL used all the physical memory of the machine, then the SQL can
still run
> smoothly? or better reboot the machine?
> >> Wanchun
> >> -- Tibor Karaszi wrote: --
> >> Please read the links I posted about memory allocation algorithms in SQL Server. This is
normal, and no
> reboot
> > is necessary.
> >> --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> > news:DF073FD2-4A17-4122-BCEC-E9FB5E5AF5EF@.microsoft.com...
> >> Tibor,
> >> My concern is how to prevent the SQL server that increase the memory usage continuously? Or We
> need to
> > reboot the machine periodically? Please advise.
> >> Wanchun
> >> -- Tibor Karaszi wrote: --
> >> Enterprise edition has some distinct features that SE doesn't. You find them at:
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> >> As for memory, please read below:
> >> INF: SQL Server Memory Usage
> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
> >> http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> >> news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com...
> >> Andrew,
> >> That mean from our requirement, standard edition is enough for us?
> >> Also, the memory arrangement is the same between standard and enterprise? I am testing with
standard
> >> edition, the memory continue to grow from 10M to 110M after I inserted 3000 records. After I
> re-boot
> > the
> >> machine, the memory back to 10M..... Is it I need to re-boot the machine every week to prevent
> the
> > memory to
> >> grow' Or enterprise edition can handle it better?
> >> Any other Enterprise features that better than Standard?
> >> Thanks
> >>> -- Andrew J. Kelly wrote: --
> >> No edition is any more or less stable than any others. It is mainly
> >> features and capacity. Standard edition will do just fine for your needs.
> >> --
> >> Andrew J. Kelly SQL MVP
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> >> news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com...
> >> Hari,
> >> Thanks for your advice. However, I have read the page before and without
> >> any idea. The point of availability is confused me. In fact, the standard
> >> edition and enterprise edition is no different except?
> >> --Scalability ( useless to us because we only have 1 CPU machine with
> >> 512MRAM)
> >> --Availability/uptime (useless to us because we don't have a standby or
> >> cluster machine)
> >> --Performance (Time is not so critical because we are just using the 6.5
> >> version now with no complain)
> >> --Advanced analysis ( Analysis is not so critical because we are just
> >> using the 6.5 version now with no complain)
> >> I just concern, is it enterprise edition is more stable? or standard
> >> edition is easy to down?
> >> Wanchun
> >> -- Hari Prasad wrote: --
> >> Hi,
> >> Based on your configurations and settings I will recommend you to go
> >> for SQL
> >> Server standard edition.
> >> Have a look into the below link in choosing the edition of sql
> >> server:-
> >> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >> Thanks
> >> Hari
> >> MCDBA
> >>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
> >> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> >> We want to select the edition between standard and enterprise. Our
> >> usage:
> >> 1) 10 users/application connect to the server at the same time
> >> 2) 5000 row insert per day
> >> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window 2000
> >> server
> >> 4) One database will be installed
> >> 5) The size of the database around 10GB
> >> Because we want to replace the existing SQL6.5 with 400MHz 256MRAM
> >> database server.
> >> Please advise. Thanks
> >>|||The max memory only sets an upper limit for the memory pool. There is an
area called the mem to leave that gets allocated first. By default it can
use to to 256MB so if you set the max memory to 400 you will most likely
still swap with the OS. While it may be better than not changing anything I
would set it even lower. You stated you only do 5000 inserts a day so you
should not require a lot of memory to operate properly. Try setting it to
300MB and see if that helps. Memory is cheap these days and you might want
to look into adding more later on.
--
Andrew J. Kelly SQL MVP
"Wanchun" <anonymous@.discussions.microsoft.com> wrote in message
news:3D73FA4A-D85C-40BF-BC30-D2F32E57602B@.microsoft.com...
> Tibor,
> This is because my machine only contain 512 MRAM... then we need to set
the "maximun memory" of SQL server around 400M and let 100M memory that can
be used by the OS? Please advise.Thanks....
> Regards,
> Wanchun
> -- Tibor Karaszi wrote: --
> The purpose if buying memory is for it to be used. SQL Server does
just that. Yes, it is normal for a SQL
> Server installation to see all memory being used. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Wanhcun" <anonymous@.discussions.microsoft.com> wrote in message
> news:70CBBAD5-7E54-4EB8-9A9C-3EBDEBF2A674@.microsoft.com...
> > Thanks again Tibor, however, if SQL used all the physical memory of
the machine, then the SQL can still run
> smoothly? or better reboot the machine?
> >> Wanchun
> >> -- Tibor Karaszi wrote: --
> >> Please read the links I posted about memory allocation
algorithms in SQL Server. This is normal, and no
> reboot
> > is necessary.
> >> --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in
message
> > news:DF073FD2-4A17-4122-BCEC-E9FB5E5AF5EF@.microsoft.com...
> >> Tibor,
> >> My concern is how to prevent the SQL server that increase the
memory usage continuously? Or We
> need to
> > reboot the machine periodically? Please advise.
> >> Wanchun
> >> -- Tibor Karaszi wrote: --
> >> Enterprise edition has some distinct features that SE
doesn't. You find them at:
> >>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> >> As for memory, please read below:
> >> INF: SQL Server Memory Usage
> >>
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
> >>
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in
message
> >> news:36E3DDB7-B674-4AFA-8A7C-3B7C1A336E3E@.microsoft.com...
> >> Andrew,
> >> That mean from our requirement, standard edition is enough for
us?
> >> Also, the memory arrangement is the same between standard and
enterprise? I am testing with standard
> >> edition, the memory continue to grow from 10M to 110M after I
inserted 3000 records. After I
> re-boot
> > the
> >> machine, the memory back to 10M..... Is it I need to re-boot
the machine every week to prevent
> the
> > memory to
> >> grow' Or enterprise edition can handle it better?
> >> Any other Enterprise features that better than Standard?
> >> Thanks
> >>> -- Andrew J. Kelly wrote: --
> >> No edition is any more or less stable than any others. It
is mainly
> >> features and capacity. Standard edition will do just fine
for your needs.
> >> --
> >> Andrew J. Kelly SQL MVP
> >> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in
message
> >> news:8E5E6311-B5DF-4D1E-9797-92DD6413C57C@.microsoft.com...
> >> Hari,
> >> Thanks for your advice. However, I have read the page before
and without
> >> any idea. The point of availability is confused me. In fact,
the standard
> >> edition and enterprise edition is no different except?
> >> --Scalability ( useless to us because we only have 1 CPU
machine with
> >> 512MRAM)
> >> --Availability/uptime (useless to us because we don't have a
standby or
> >> cluster machine)
> >> --Performance (Time is not so critical because we are just using
the 6.5
> >> version now with no complain)
> >> --Advanced analysis ( Analysis is not so critical because we are
just
> >> using the 6.5 version now with no complain)
> >> I just concern, is it enterprise edition is more stable? or
standard
> >> edition is easy to down?
> >> Wanchun
> >> -- Hari Prasad wrote: --
> >> Hi,
> >> Based on your configurations and settings I will recommend
you to go
> >> for SQL
> >> Server standard edition.
> >> Have a look into the below link in choosing the edition of
sql
> >> server:-
> >>
http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >> Thanks
> >> Hari
> >> MCDBA
> >>> "Wanchun" <anonymous@.discussions.microsoft.com> wrote in
message
> >> news:08540023-9C99-4569-9A26-F765151912A2@.microsoft.com...
> >> We want to select the edition between standard and enterprise.
Our
> >> usage:
> >> 1) 10 users/application connect to the server at the same time
> >> 2) 5000 row insert per day
> >> 3) Our machine is only 1CPU 2.6GHz and 512 MB RAM with window
2000
> >> server
> >> 4) One database will be installed
> >> 5) The size of the database around 10GB
> >> Because we want to replace the existing SQL6.5 with 400MHz
256MRAM
> >> database server.
> >> Please advise. Thanks
> >>