SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:25 PM
| ||||
| ||||
 Re: odbcint.dll and smsrp70.dll eating up all my servers memory within SQL7.0 sp2 In Enterprise Manager, you can configure SQL to use a certain memory range (you'll have to stop and restart SQL for it to take effect). Try that. You should allocate at least 1/3 - 1/2 of your server's memory to SQL, sorry not sure if there is an actual formula out there (like there is for a pagefile) -- ************************************************** ***************** Andy S. MCSE NT/2000, MCDBA SQL 7/2000 andy_mcdba@yahoo.com Always keep your antivirus and Microsoft software up to date with the latest definitions and product updates. Be suspicious of every email attachment, I will never send or post anything other than the text of a http:// link nor post the link directly to a file for downloading. Andy_mcdba@yahoo.com gets filled up to the account limit with spam every couple of hours now so replies may not be possible. I will remove this disclaimer once every ISP involved with relaying the spam can help me out. ************************************************** ***************** "jobi" <jobi@reply2.group> wrote in message news:bkumaj$chg$1@reader08.wxs.nl... > Hi, > odbcint.dll and smsrp70.dll are eating up all my servers memory within > sqlservr.exe (SQL7.0 sp2). > > Any Idea what's causing this ? > > jobi > >      |
|
02-27-2008, 07:25 PM
| ||||
| ||||
| Re: odbcint.dll and smsrp70.dll eating up all my servers memory within SQL7.0 sp2 Thanks for the reply. I'll first need to explain why this occurs. I'ts got to have something to do with the new vb-applications they have installed, because this server has been running without any problems for 3 years. If I find the reason(s) for this problem and it is related to the way the new apps are written, then I can give the developers better guidelines to write better apps or have them reviewing their apps designwize. jobi "Andy Svendsen" <andy_mcdba@yahoo.com> wrote in message news:eFCihb4gDHA.1668@TK2MSFTNGP12.phx.gbl... > In Enterprise Manager, you can configure SQL to use a certain memory range > (you'll have to stop and restart SQL for it to take effect). Try that. You > should allocate at least 1/3 - 1/2 of your server's memory to SQL, sorry not > sure if there is an actual formula out there (like there is for a pagefile) > > -- > ************************************************** ***************** > Andy S. > MCSE NT/2000, MCDBA SQL 7/2000 > andy_mcdba@yahoo.com > > Always keep your antivirus and Microsoft software > up to date with the latest definitions and product updates. > Be suspicious of every email attachment, I will never send > or post anything other than the text of a http:// link nor > post the link directly to a file for downloading. > > Andy_mcdba@yahoo.com gets filled up to the account > limit with spam every couple of hours now so replies may > not be possible. I will remove this disclaimer once every > ISP involved with relaying the spam can help me out. > > ************************************************** ***************** > "jobi" <jobi@reply2.group> wrote in message > news:bkumaj$chg$1@reader08.wxs.nl... > > Hi, > > odbcint.dll and smsrp70.dll are eating up all my servers memory within > > sqlservr.exe (SQL7.0 sp2). > > > > Any Idea what's causing this ? > > > > jobi > > > > > > |
Linear Mode
