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
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
We are running SQL2000 on Compaq 8500, want to upgrade the RAM from 4GB to 6GB. What do I need to change in SQL in order to see the more memory?
We want to leave only 1GB for the OS and the rest for SQL2K.
Thanks
My server has 3G memory, I use FileLib.linkclr_u_file_textcontent to load a 1M file, which just read a return, but sometime I get this error
Msg 6532, Level 16, State 49, Procedure chg_import_gateway, Line 7
.NET Framework execution was aborted by escalation policy because of out of memory.
System.Threading.ThreadAbortException: Thread was being aborted.
System.Threading.ThreadAbortException:
at FileLib.linkclr_u_file_textcontent(String fileName)
any idea? how to check and set memory for CLR and how does it reuse the memory?
thanks
We are currently running a server with standard edition Windows Server 2003 R2 with standard edition SQL Server 2005 SP2.
The server has 4GB of memory of which 3GB is dedicated to SQL and 1GB to the OS via the use of the /3GB switch.
If we were to increase the physical memory to 12GB (and carve out 2GB for the OS and 10GB for SQL) would we have to upgrade the OS to Enterprise version to access the additional 8GB of memory we plan to add?
Thanks ALL!
We have a SQL enterprise server 2014 with two installed instance.
First instance for SharePoint 2013 DBs and second instance Dynamics AX 2012 R3 DBs.
The server has 32 GB of RAM, currently the process usage for first instance is 26 GB and second instance is 700 MB.
Which mean that SharePoint DBs in the first instance is consuming most of the RAM.
My question is there any way to assign a fixed RAM usage for a specific instance without affecting the other instance?
for example 16 GB only first instance and 16 GB to second instance.
Hello!I would like to change the SQL server 2000 from Standard version toDevelopment edition. I have two database running on this server, bothreplicated, with few jobs, etc ... Can you recommend the easiest way to dothis? I heard, it would be as easy as, detaching the databases, deletingcurrent SQL software, installing different one, and attaching the olddatabases back. I doubt that is true, so that's why I'm asking here for anyreal-life instructions.Thanks for your input!Kind regards,Dejan--
View 1 Replies View RelatedI don't need 2005
obulay@hotmail.com
There must be many various ways to upgrade a dual processor server from SQL 7 to SQL 2000.
Do you think I am better off to simply run the upgrade CDs?
Would it be better to de-install SQL 7 and then install SQL 2000?
Better still to Rebuild from scratch? (OS & setup)?
This particular server has seen little use actually.
Who has experience and suggestions?
Thanks,
Mark Blackburn
CA Dept of Parks
Hi.
I have two scenerio.
One:
Two servers (SQL 7.0), transaction replication
Two:
Four servers (SQL 7.0), transactional replication one publisher, one distributor and 2 subsribers.
I need to upgrade these two scenerio to 2000.
Please advice me with suggestions and your experience.
-MAK
I am planning on upgrading my existing SQL Server 7 to 2000. I plan on starting out just upgrading the SQL first, then upgrading to Win2k Server later on.
I have read some posts here with some of you having issues, etc. Based on your experiences, do you suggest, I do both upgrades together? I think it would be best to do this on a new server, and keeping everything live on the other server until I feel comfortable in moving over the data.
What files besides the database files, should I restore, if any? Are there any significant application performance issues or bugs? Should I wait to apply the first sql patch that was just released last week? What about any code that needs to be rewritten?I will do it as a test first, but any advice would be great.
I have several SQL 7.0 SQL servers that I need to upgrade to SQL 2000.
I have been tasked with finding out what the risks are in upgrading and where I may run into problems when upgrading.
So far I have'nt been able to find any info of how to prepare for the upgrade.
Does anyone know of potential problems I should look for or documents/kb articles on the web that I can refer to plan correctly.
Thanks.
We are trying to do an upgrade in place and are getting errors that it can't activate model database files. We believe it's because we move all log files to another drive and think Microsoft failed once again to recognize this in their upgrades. They made this mistake in 7.0 SP2 (the SP failed if you moved log files to alternate location) but they fixed it in SP3.
Has anyeone experieinced this problem? Is there a workaround (other than the obvious.)
Replies are appreciated!
Colleen:confused:
We are about do an upgrade from 6.5 to 2000. Does anyone know of any material that would be of assistance to me. If you have any pointers that would also be appreciated.
View 1 Replies View RelatedTry to upgrade SQL 7 on a NT4 system to SQL 2000. Also like to upgrade NT4 to Win2K. Anyone know what's the best sequence for doing so? Thanks on advance.
View 1 Replies View RelatedWhat is the best way of brining a SQL Server 6.5 database to a Consolidated SQL Server 2000 environment? I tried using the SQL Server 2K upgrade wizard and it failed to import some data, which made me uncomfortable in using this tool?
Is this a safe approach:
Create a database on SQL 2K and script out all the objects like tables, Indexes, views and run it against SQL 2K.
Then run the DTS to populate all the tables and you are done?
Hi,
I'm looking to upgrade our old 6.5 server (running NT4) to 2000 and go to Windows Server 2003 at the same time. There are 10 or so small to medium sized DBs on here.
Can anyone provide some decent links to blogs, FAQs or documentation relating to this?
Many thanks,
Matt
Hi,I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db to2000. I am only choosing to update a single database, not system objects.The Upgrade wizard connects to SQL 6.5, checks the db, creates the db on SQL2000 with all tables and imports users from SQL 6.5. The problem comes whenit tries to bring over the actual data. I get an error:"Couldn't connection to the export machine!" in the out log file.The in log file reports login failed.Both SQL services were running at this point, the login via SA must beworking since it copies over the 6.5 db structure and users.The SQL 6.5 machine is NT 4. The 2000 machine is Windows Server 2003. Iwas logged in as domain admin when running this. I tried playing with the"SQLUpgrade" DSN that was created on the SQL 2000 machine to use SA orwindows authentication, both fail.Any ideas?Thanks.
View 1 Replies View RelatedHi! If doing online version upgrade from SQL 7.0 to SQl 2000, (1) do Ineed to shut down server? (2) after upgrading, is all login and dbuser, group information, scheduled Jobs, maintenance paln... stillthere? or I have to save the info before upgrading and recreate afterupgrading? (3) any other tips I need to know? I'm doign that for thefirst time.Thanks!Saiyou
View 2 Replies View Related
This is want happen. We have upgraded from sql 2000 sp3 to sql 2000 sp4 on an window 2003 server with sp1. Now we are getting this error. ERROR: 17805, SEVERITY: 20, STATE: 3 INVALID BUFFER RECEIVED FROM CLIENT..
Any ideas.
Mark
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...
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
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 RelatedI 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 RelatedI 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 RelatedI 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
Hello,
I have a project where I have to upgrade SQL 2000 to 2005. When we are upgrading we are going to move to new server so server name will change. Most of our applications have a hard coded connection string. Applications are developed with Classic ASP, .NET 1.1 and 2.0 as well.
Now the question is what is the best way to do this? Changing all the connection string will be a very painful task as we have many applications.
Can anyone suggest a way where we can achieve this without changing all the connection strings?
Thanks in advance.
Tareq
Do I have to upgrade to 7.0 before installing the beta SQL 2000 or can I go straight from 6.5?
View 1 Replies View RelatedI am upgrading a SQL7 std to SQL2000 std
The upgrade process fails in the upgrade.sql step. With no meaningful error messages. All services that may use the db are stopped, the net is disabled so this server is stand alone, nothing can be accessing the db !
I cannot find any log output, from the upgrade so I dont know whats causing this. Has anyone any ideas ?
Thanks
Tom
Hi all:-
How do I upgrade my local sql server 7 to sql 2000 ? Do I just put in the sql server 2000 CD and run it or is there an upgrade CD ? I have lots of stuff on my sql 7 and don't want to lose it.
Thanks in advance!
Hi,
We have a VB application, which extracts data from SQL Server 6.5 database. Recently we upgraded our database from 6.5 to 2000.
One of the report which used to give results in Sorted order in 6.5 database, is not producing the same report in sorted order. We didn't do any change at database/application level.
As we have not made any changes at application level, I am presuming that the problem is at database level, due to this upgradation.
Can any one guide me how to rectify this problem.
As I don't have source code for this application; Is it possible for me to extract the query running for this report from database?
Thanks.
Hi guys.
I have two scenerio.
One:
Two servers (SQL 7.0), transaction replication
Two:
Four servers (SQL 7.0), transactional replication one publisher, one distributor and 2 subsribers.
I need to upgrade these two scenerio to 2000.
Please advice me with suggestions and your experience.
Is Online replication possible?
-MAK
Hello List,
I've couple of questions about Sql Server 2000 and would greatly appreciate, If somebody out there, please answer to it.
Questions:
I've a SQL 7 server dump file and I was wondering, If I can directly load this file into SQL Server 2000? If yes, Would this call a Upgrade of sql 7.0 database to SQl Server 2000? Or this is just a backward compatability support in 2000?
Well the main objective of this is, We are planning to upgrade one of our production SQL 7.0 server and I was wondering, If we can just take the SQL 7.0 dump file and load it into the SQL 2000 Server? If yes, What are the downgrades of this and if no, Should we upgrade the sql 7.0 server itself and along with it all the databases sitting on it? Please shed some light here.
Many thanks.