•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,548 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,482 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 2733 | Replies: 2
 |
•
•
Join Date: Apr 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
MS-SQL Standard Memory Cap Hi Guys!
I am newbie to MS-SQL Server and I’ve run into a very very serious trouble.
My company/organization that I am currently with is running MS-SQL Server 2000 Standard and our problem is:
MEMORY
Out of my stupidity I upgraded our server’s memory to 4 GIG and to our realization (since we are a bunch of open source guys) the memory limit of MS-SQL standard is 2GIG.
Now….. is there anyway to tweak this? configuration (we already set windows to prioritize SQL) without upgrading to enterprise which cost a lot of MOOOOHLAH or without messing with the application that is accessing it (no way on earth coz the application is already made and the coz of the memory consumption is the thousands of users accessing it.). just plain tweaking? Is there anyway to surpass that 2 GIG memory cap on MS-SQL Server 2000 Standard?
Tnx in advance! :o
I am newbie to MS-SQL Server and I’ve run into a very very serious trouble.
My company/organization that I am currently with is running MS-SQL Server 2000 Standard and our problem is:
MEMORY
Out of my stupidity I upgraded our server’s memory to 4 GIG and to our realization (since we are a bunch of open source guys) the memory limit of MS-SQL standard is 2GIG.
Now….. is there anyway to tweak this? configuration (we already set windows to prioritize SQL) without upgrading to enterprise which cost a lot of MOOOOHLAH or without messing with the application that is accessing it (no way on earth coz the application is already made and the coz of the memory consumption is the thousands of users accessing it.). just plain tweaking? Is there anyway to surpass that 2 GIG memory cap on MS-SQL Server 2000 Standard?
Tnx in advance! :o
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
I don't think so. Also, you might want to check your stored procedures and make sure they are all as efficient as possible. Profiler is a great tool for locating queries that are causing problems.
•
•
Join Date: Apr 2006
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by campkev
I don't think so. Also, you might want to check your stored procedures and make sure they are all as efficient as possible. Profiler is a great tool for locating queries that are causing problems.
yes sir.. :cheesy: its only 2GIG for MS-SQL 2000 Standard. (ahmm.. thats what i read and thats what i have been encountering.. i cant go thru the 2GIG limit..)
do you have a production SQL 2000 Standard that can go more than 2GIG of ram? if so.. do you have a monitoring tool installed on that server? (MRTG)
yes sir.. i know about profiler...
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- How to insert data into database? (JSP)
- memory management in wndows 2000 (Windows NT / 2000 / XP / 2003)
- Database not being populated.... (Java)
- Adding RAM to HP Pavillion 8776C - odd problems? (Motherboards, CPUs and RAM)
- ASP and SQL ? (MS SQL)
- MySQL vs. PostgreSQL (MySQL)
Other Threads in the MS SQL Forum
- Previous Thread: Field Constraint (don't want negative numbers)
- Next Thread: finding feild type/table layout
