Configuration Of Memory For SQL 2000

Apr 16, 2003

I am looking for recommandations regarding the memory distribution for SQL 2000 server. In the memory tab of the server properties you can define use a fixed memory size or dynamically configure SQL server or even reserve physical memory for SQL server.
Are there any hints available or must it be handled according trial and error?

Thanks for any info

mipo

View 2 Replies


ADVERTISEMENT

SQL/NT Memory Configuration Parameters

Dec 13, 2001

Can someone tell me if this sounds OK?:

NT4 SP5 running SQL6.5

Physical Memory - 512mb
Virtual Memory - 1024mb

Allocated to SQL - 256mb

The largest database is 7gb and tempdb (in ram) is 150mb

Do as a rough guide these figures seem OK?

View 4 Replies View Related

Calculate The Memory In The Configuration In SQL6.5

Apr 19, 2000

hi
I want to ask the method to calculate the memory in the configuration in SQL6.5.
If I have 256MB memory installed in the server, how many memory needed in the configuration of SQL6.5.

View 1 Replies View Related

Sql Server 2000 Using Less Memory After More Memory Added

Aug 22, 2007

sql server 2000 is running on windows server 2003 ... 4gb of memory on server .... 2003 was allocated 2.3gb nd sql server was allocated (and using all of it) 1.6gb for total of approx 4gb based on idera monitor software ... all memory allocated betweeen the OS and sql server .... then 4 more gb of memory added for total now of 8g ... now idera monitor shows 1.7gb for OS and 1.0 gb for sql server ..... 'system' info shows 8gb memory with PAE ... so I assume that the full 8gb can now be addressed .... why are less resources being used now with more total memory .... especially sql server ..... i thought about specifying a minimum memmry for sql server but i amnot convinced that would even work since it seems that this 1gb limit is artificial .... it it used 1.6 gb before why would it not use at least that much now ??

thank you

View 4 Replies View Related

Setting SQL Configuration Parameters ( Memory & Locks)

Oct 27, 1998

hi, here is the situation, my system has the following specks
hard drive = 45GB
memory = 1152 mb
Opsystem = win NT 4.0
application on the NT is ftp server and SQL server 6.5


I am having a tough time retrieving a simple query from a 11 million records.some of the feed back from the newsgroup is that I do not have enought memory. Is there a formula to use to figure out how much memory should allocate to the sql server? what if I allocated too much memory, does that affect the sql performance in a negative way?
Please help......
I can be reach at a.alhussein@mci.com

thanks alot

regards
Ali

View 4 Replies View Related

SQL Server Memory Configuration Share Nicely With COM

Jun 5, 2006

Hello,

So we have a clustered environment on Windows 2003.

We have 12GB ram, and are running with /3GB and /PAE.

We do not currently have AWE enabled.

SQL is currently using 2.799GB

This leaves only 200MB or so free for my COM+ component, and if/when it raises to that level, application users get 'Out of Memory' error.

How can we get these two products to share memory better, and more importantly utilize more of the free memory on the system.

Should we have AWE enabled? Are there any negatives to this? If AWE is enabled and SQL Uses say 6GB, Will the COM+ application have 0 available?

View 3 Replies View Related

SQL 2012 :: Determining MAXDOP And Memory Configuration For Multiple Instances?

Sep 18, 2014

We are just finishing our migration to SQL 2012. In our old environment, the instance which held our SharePoint databases also served other applications. We did not experience any performance related issues in the past due to this.

SharePoint basically requires MAXDOP to be 1, which is correct on the old server. Since this configuration may not be ideal for other applications that may be put within our environment, we our entertaining the idea of isolating SharePoint into its own instance, probably on the same box.

My manager wants me to come up with performance trace data to better prove that we need to go this route since we apparently have had issues in the past by blindly following Microsoft's best practices.

1.MAXDOP configuration - I understand this may be a 2 pronged approach that would require looking at various execution plans and CPU related counters in Perfmon. SharePoint likely requires a maxdop of 1 due to the nature of the application (lots of concurrent processes). What is the best way to show this need graphically?

2. Memory configuration for multiple instances - Does the Total Server Memory reveal all the memory that a given SQL instance is utilizing? Should I use this counter to identify appropriate min/max memory configurations for multiple instances on a single cluster?

The problem with the perfmon approach is that it's scope is limited to just the server. Since our SharePoint environment is currently being shared with other applications, I understand that I may have to utilize DMV statistics to narrow down my analysis.

View 3 Replies View Related

Sql 2000 Setup And Configuration

Jul 10, 2006

I am in charge of redoing a SQL 2000 box and was wondering what would be the best setup configuration? Should it be setup like an Exchange server, where the log files are on one drive the database files another, and the OS another? I have looked for some kind of documentation thought I had found one but can't find it again. Thanks in advance for your help.

View 4 Replies View Related

SQL 2000 Set Fails During Configuration Stage

Mar 15, 2002

Hello,

I did not know how to search the archives here yet, so sorry if this is a repeat question.

I am installing SQL Server 2000 Developer edition on my XP Pro workstation and it is failing at the stage of the setup where it attempts to configure the database and run scripts.

sqlstp.log give me this error set:

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=KGB;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

driver={sql server};server=KGB;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

driver={sql server};server=KGB;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

SQL Server configuration failed.

################################################## #############################

17:13:42 Process Exit Code: (-1)
17:13:46 Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information.
17:13:46 Action CleanUpInstall:
17:13:46 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
17:13:46 Process Exit Code: (1060) The specified service does not exist as an installed service.

17:13:46 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
17:13:46 Process Exit Code: (0)
17:13:46 StatsGenerate returned: 2
17:13:46 StatsGenerate (0x0,0x1,0xf000000,0x0,1033,303,0x0,0x1,0,0,0
17:13:46 StatsGenerate -1,kgood)
17:13:46 Installation Failed.


Any help would be appreciated.

Thanks.

Kel

View 2 Replies View Related

SQL Server 2000 Password Configuration

Sep 26, 2006

Is there any way in SQL Server 2000 to configure password rules for SQL server logins, e.g. minimum password length, complexity etc?

Thanks!

View 1 Replies View Related

Is This Cluster Configuration Possible In SQL Server 2000?

Jan 29, 2008

Hi, could someone tell me if this configuration is possible?

Machine A: Instance 1 (ACTIVE) + Instance 2 (passive) + Instance 3 (pasive)
Machine B: Instance 1 (passive) + Instance 2 (ACTIVE) + Instance 3 (pasive)
Machine C: Instance 1 (passive) + Instance 2 (passive) + Instance 3 (ACTIVE)

I know that it is possible with 2 machines with the clasical solution of Machine1: active-passive, Machine2: passive-active, this way if one of the machines goes down the other one will take the job of both instances, but I dont know if this solution is possible in SQL server 2000 with 3 instances at the same time.

Help please? thanks

View 3 Replies View Related

SQL 2000 Memory Adjust

Oct 3, 2007

Does anyone know how or where to adjust Ram Memory usage for SQL 2000.
      I've just added Changed the 512 MB Ram that came with the Server and Exchanged it with 4 GIG Ram . Is it a good Idea to allow only 2GiG for SQL . I 've heard that SQL will take/use all Ram that you install if you let. If this is true
Can anyone advise on how/where to make adjustments. Thank You...

View 2 Replies View Related

Memory In Sqlserver 2000

Aug 16, 2004

Running sqlserver 2000 on a w2k server with 1gb of memory. After a reboot the memory usage is around 500m but quickly climbs. At 1 point it was up to 1.5gb so it must have been swapping. Are there any good docs about this or any recommendations on how to limit sqlserver from using all the memory. It is the only application on the server so it isn't affecting anything else so maybe it isn't a problem. I just wanted to get people's inpit on this.

View 2 Replies View Related

Memory Upgrade And SQL 2000

May 3, 2004

We have a SQL server that has a failover cluster on our network. We are looking to updrade the memory by adding a couple gigs of ram.

We don't need to upgrade the failover cluster to have the exact amount of memory as the primary do we?

DotNetJunkie

View 3 Replies View Related

Memory Allocation In SQL 2000

Sep 13, 2007

I would like to ask regarding the memory allocation fo SQL Server 2000. For example if my Data Server have 8GB physical memory installed how much memory can SQL Server 2000 utilize? Based on my research and understing SQL 2000 Server can only utilize 3GB memory? But using the AWE you can set the memory to a maximum server memory?

View 8 Replies View Related

SQL 2000 SP4 EE 32 Bit - SQL Is Not Using All Of The Memory Allocated To It.

May 17, 2007

I recently changed the max. memory option in SQL from 24 GB to 30GB but the perfmon counters still only show 24 GB. Any ideas on why it is not recognizing the change? The server has Win 2003 EE and 32 GB of RAM.

View 5 Replies View Related

SQL Server 2000 Std Memory

Feb 12, 2007

I have SQL Server 2000 STD installed on a Windows Server 2003 STD machine. It's essentially the only app on this box. I have 4GB of RAM installed. SQL is configured to dynamically allocate memory. I run a batch file daily to restart the SQL services as SQL does not seem to release memory once it's got it. I don't think this is a problem because, like I said, it's basically the only app. But I want to make sure my OS memory settings and SQL's memory settings are optimized. Will adding the /3gb switch to the boot.ini file make a difference? Also, can someone educate me a little on PAE and AWE?
Thanks

View 1 Replies View Related

SQL Server Windows 2000 Event Log Configuration

Mar 23, 2004

Hi ,
Do you know what is the registry key / parameter that can be change in order to configure SQL 2000 to report on warning / Error event only ( just dismiss all the information messages)


Thanks,
Eyal

View 1 Replies View Related

SQL Server 2000 Memory Issues

Aug 23, 2007

Every day or two I have to restart my SQL Server because users are receiving timeouts and very slow page loads.  My mem usage in Task Manager show that SQL Server is at 1,200,000k compared to 400,000k when I restart it.  Performance Monitor also shows that Buffer Manager/Target Pages and Total pages are maxed out.  Any advice?  Thanks!
 
 

View 1 Replies View Related

SQL Server 2000 And Memory Consumption

Sep 14, 2005

Hello!


We have a SQL Server 2000 that has been working nice
without any issues. Lately we noticed the fact that the amount of memory that
it is using has increased and once it took down the web server as the total
amount of memory used was 2G. Due to this fact I have set Memory Max to 500MB.
Now as I look in Task Manager the Memory usage is at 530396k which is 518MB.
Any reason why would it exceed the 500MB?

What we did before was to stop the SQL Server and restart it, and it takes about
2 days until it gets back to +500MB.

What can I do to stop this behavior?

Thanks.

View 3 Replies View Related

SQL Server 2000 Memory Issues

Jun 13, 2006

Dear All,

We have a Windows 2003 Enterprise server with SQL Server 2000 Enterprise on it. This has the AWE settings for 'max memory setting' to 5120MB. This server has 6GB of memory, or rather about 5.8GB due to PAE. From yesterday morning the server has become almost unresponsive when the SQL service is running, and pretty much all the memory, ie < 1MB on average is listed as being free.

The database has been growing constantly and is now 46GB, with database file size of 67GB.

We moved the database onto a new box which was being prepared for another service, and this has 8GB or ram and no AWE settings. It is running fantastic.

We are going to rebuild the original box and the SAN structure, but I want to do some fiddling before we do. I was going to set awe-enabled to 0 to see if that setting was allowing the OS to have no memory, but from reading http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx it says If AWE is enabled and is taking too much memory, SQL Server must be shut down to reconfigure it, causing downtime (which makes a high availability option such as failover clustering less available). Because the memory pages used by the instance of SQL Server are taken from the nonpageable pool of Windows memory, none of the memory can be exchanged. This means that if the physical memory is filled up, SQL Server cannot use the page file set up on a physical disk to account for the surplus in memory usage. How do you reconfigure AWE settings if the SQL service is shutdown?

Also, how can I figure out whether the server is deficient in physical RAM, or it is just a 'max memory' setting we need to tweak, or is it just trial and error?

Incase it might help, we have ~3 meaningful DB's on the server apart from 'master'. One is an archive DB ~80GB, one is ~5MB and the live DB which is the size mentioned above. Unfortunately I don't know table sizes.

Pax

View 3 Replies View Related

MSSQL 2000 SP4 Memory Leak

Oct 5, 2005

Greetings all!

On one of our intranet SQL servers running under Windows 2000 SP 3,
MSsql 2000 SP4 seems to gradually "eat" away all available memory (with no obvious reason for it) until a certain limit is reached, forcing the server to slow down substantially since the OS has to SWAP continuously.

I would appreciate any suggestions at this point on how to tackle this problem :)

Thank you!
VincentJS

View 2 Replies View Related

MSSQL 2000 Memory Leaks

May 16, 2006

Hi,
I have one application in two different companies with MSSQL2000 running on Windows2000 Server and Windows2003 Server.
It seems that memory needed for MSSQL2000 as displayed in task manager is increased every day.
Does anybody knows anything regarding memory leaks in MSSQL2000?

How can I find what version of service pack have I installed in a MSSQL2000 server machine?

Regards,
Manolis

View 3 Replies View Related

SQL Server 2000 Not Using All Memory Allocated To It.

Aug 1, 2007

One of our servers has 20GB of memory and SQL server has been allocated 18.5 GB out of it, however SQL Server only uses about 9GB or so.

OS: Windows 2003 Server
MS SQL Server 2000 SP4
awe enabled
min & max server memory (run values) are: 18432
/PAE switch in boot.ini

any help why SQL server is not using 18.5 GB allocated to it, would be greatly appreciated?

View 8 Replies View Related

SQL 2000 Cluster Memory Settings

Jan 31, 2008

I have an Active/Active/Passive cluster with 64GB RAM on each node running SQL 2000 EE, AWE is enabled as well as the PAE switch, all is dandy with that.

Question:
Should I configure each SQL Instance to have only a max mem usage of 32GB in the event both failover to the same node ? or will the memory allocation be handled without any issue if each node is configured to use 64GB ?

Thanks.

View 3 Replies View Related

Memory Usage For SQL SERVER 2000

Mar 23, 2006

Good day to all of you
I am faced SQL SERVER 2000 Memory usage problem. I am using Windows 2000 Server SP4 and SQL SERVER 2000 SP4. When User running some in-house application software, the memory for sqlservr.exe was increased . But, when user logout from the software. The sqlservr.exe did not decrease the memory. I have around 100 Users in my company. SQL Memory will countinues increase till max memory usage in CPU.

May i know how to order SQL SERVER need to purge memory when USER was log off from the Program? Or my SQL SERVER was corrupted /missing file?

Please advice

Many thanks!
Melvin

View 4 Replies View Related

SQL Server 2000 2GB Memory Limit?

Jul 23, 2005

SQL Server 2000 SP3 on a Dell dual 2.4GHz Xeon box 3GB RAM Windows 2KSP4. Two aplication dbs, each less than 2GB in size.Had a problem where we would run Solomon queries and what not againstthe box. It had 2GB RAM, and sqlserv.exe would take up to 1.85GB ofRAM, exhausting the physical RAM on the box. SQL would choke and theSolomon users would have problems, and I would have to restart the SQLservice.I added another GB of RAM, bringing the box to 3GB, and increased thepaging file. The OS sees it, and SQL sees it. I check EnterpriseManager, and tell SQL to dynamically configure memory, and it offers anupper limit of 3071MB, so it "sees" the 3GB.I can stress the box with queries to the point that sqlserv.exe takes1.99GB of memory (as viewed through Task Manager) and then SQL serverchokes. It never goes past 2GB, and the OS and box continue runningfine.Does SQL server 2000 have some upper limit, or do I just need to changesome setting through EM?Thanks.

View 2 Replies View Related

Memory Allocation In MS-SQL 2000 Instances

Mar 17, 2006

Hi,From a previous sys-admin I inherited a a MS-SQL (2000) machine with 3instances. It is a nice machine with 4 Gb of memory but the memory allocationis very weird:Instance A: 1400MbInstance B: 1000MbInstance C: 80Mb (!)Instance C is performing badly under a bit of pressure which seems not strangeconsidering these allocations.With that in mind, is there a way to check and re-allocate memory? I'd like tosee if the instances really need these amounts of memory and if not, to movesome over to other instances.Thanks!Dries Bessels

View 1 Replies View Related

SQL Server 2000 Memory Reclaim

Jul 20, 2005

Hi,I guess SQL server does not release claimed memory even if it is notused. Is there anyway to free the unused memory?Thanks,John Jayaseelan*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

SQL 2000 X32 OnWin2003 X64 Memory Config

Apr 1, 2008



We have a new server (4 dual-core CPUs and 8GB ram) with Windows 2003 x64 installed. We need to put SQL 2000 on the system and want to maximize it for sql performance (will be dedicate to SQL). Do we enable awe in SQL? Are there any 3GB switches we need to put in the boot.ini for the 32-bit subsystem? Should we use the 32bit version of Windows and just use awe and pae?

Thanks
Steve

View 7 Replies View Related

SQL Server 2000 - MSDN - AWE Memory

Aug 16, 2007

We use MSDN SQL 2000 , the enterprise edition for our development servers,
which have always had 2GB RAM.
Now they are bringing in a Win 2003 Enterprise with > 12GB RAM .
They want SQL SERVER 2000 to use AWE memory up to 12GB . Is there any limitation
on MSDN Ent. Edition using more memory.?

View 2 Replies View Related

SQL Server 2000 -- Taking Over My Memory

Feb 3, 2006



I am running SQL Server 2000 on a desktop PC. Just recently upgraded my PC to 2gig of ram from 1 gig, in part, to try and fix the problem below. Didn't work. Have SP3 installed but not SP4 at this point.

When I open up query analyzer and edit some code, regardless of whether I actually execute the code, SQL server eventually sucks up available and cached memory to the point that my system comes to an effective halt --takes forever to do anything either in SQL server or other applications. In the task manager PF Usage climbs to just over the 2gig memory limit.

I conceptually understand the dynamic memory operation of SQL server ... but why is it sucking up most available memory when nothing is executing?

Is there a way I can release/clear the memory? Ideally, code that coould be run under a stored procedure would best meet my needs. Right now, I am "fixing" by shutting down and then restarting SQL server.



Thanks,

View 8 Replies View Related

SQL 2000 Not Listening On Shared Memory. Why Not?

Apr 18, 2007

One of my production SQL Server 2000 systems is listening on TCP and Named Pipes, but not on Shared Memory.



This server has a lot of scheduled jobs that are internal to this box. I assume these jobs would benefit from using shared memory instead of TCP/IP, but I can't figure out why it doesn't use shared memory already and how to correct that.



Thanks in advance for all assistance.

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved