RSS

Re: MS-SQL Standard Memory Cap

Please support our MS SQL advertiser: Programming Forums

MS-SQL Standard Memory Cap

•

Join Date: Apr 2006

Posts: 2

Reputation: mrwilsondg is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

mrwilsondg mrwilsondg is offline

Offline

Newbie Poster

Re: MS-SQL Standard Memory Cap

Apr 16th, 2006

•

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...

DaniWeb Home > Forums > Web Development > Databases > MS SQL > MS-SQL Standard Memory...

Re: MS-SQL Standard Memory Cap

MS-SQL Standard Memory Cap

Re: MS-SQL Standard Memory Cap