January 31, 2010 at 10:09 pm
Hi,
we are using two instances of sql server (production) on one windows box using the sql edition
8.00.2039SP4Personal Edition
one of our Dbase is 2525.51 MB
we are using the O/s version
Microsoft windows server 2003
statdard Edition SP2 v.4354
computer :
Intel(R) xeon(R) cpu
5120@ 1.86Ghz
1.87Ghz, 2.00GB of RAM
under processes it shows
sqlservr.exe :1,516,620K
sqlservr.exe :26,812k
If i increase the RAM size will it increase the performence of the system
Please send the best solution to increase the performence of SYSTEM & Database
As a DBA what are the considerations need to be take to increase the performence.
Thanks in advance
January 31, 2010 at 10:14 pm
Personally I think 2gb RAM for SQL and an OS is a bit too little.
Did you specify the amount of RAM available to SQL?
You'll have to do a series of checks to make sure SQL is running optimal.
http://www.sql-server-performance.com/tips/gen_tips_p1.aspx
Also search "performance" in SSC for related posts.
How many connections are on average hitting your database?
Can you see any blocks occuring?
Have you run the MS BPA yet?
Please let us know..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 1, 2010 at 12:43 am
Hi,
Please provide how to check this
How many connections are on average hitting your database?
Can you see any blocks occuring?
Have you run the MS BPA yet
February 1, 2010 at 2:46 am
Check the performance monitor or profiler. Basing on the result you can decide
February 1, 2010 at 4:12 pm
Can SQL 2000 Personal Edition even recognize more than 2GB or RAM?
Joie Andrew
"Since 1982"
February 1, 2010 at 6:49 pm
Max memory supported by SQL server 2000 personal edition on any O.S. is 2 GB
February 2, 2010 at 2:28 am
Hi, all thanks for u r valuble replies.
IF i need to upgrade the current version
(8.00.2039SP4Personal Edition)(Microsoft SQL Server 2000 - 8.00.2039
(Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.4354) )
to next or heigher versions what are the steps i need to take
wether i need to upgrade windows 2003 server o/s or sql server 2000 personal edition?
Please suggest
Thanks in advance
February 2, 2010 at 1:02 pm
Well, since Windows Server 2003 is going on 7 years old now and SQL Server 2000 is not even supported without an extended support contract, I would suggest upgrade whatever your organization will let you upgrade to. If you can upgrade to Windows Server 2008 for the OS that will add a lot of benefits, especially in terms of network performance. But you would need to make sure that any other software/hardware on the machine is supported by the OS.
As for SQL, I would recommend going to a newer version and getting away from 2000. 2005 would be okay, but 2008 would be better, as it would put you more inline with support that is coming from Microsoft. The database/application would need to be tested and verified to work with that version first though, and then a migration/upgrade plan would need to be designed and tested before being implemented.
That would be my recommendation.
Joie Andrew
"Since 1982"
February 25, 2010 at 5:34 am
thanks for u r replys
we increase the RAM to another 4GB Now the total RAM size is 6 GB
my question is
Now My dbase is 6gb
2Gb Ram Can support to how much gb DB
how this dbase size will effect the RAM
or what is the rel between RAM size and DB size increasing
Please clarify
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply