Please support our MS SQL advertiser: Programming Forums
Views: 3021 | 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
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode