MSDE RelA using all memory

Six months ago I rework our application to use MSDE as a desktop DB. It was
used to replace Paradox. I develop in Delphi with ADO.
I realized tremendous performance gains and the ability to use stored procs
and computed columns made many tasks far eaiser. But we seemed to have shot
outselves in the foot. Because to the significant performance gains, we
added additional features that involved complex queries.
Our application, which supports the automation of chicken processing, is
very DB intensive. We write a record to the database every 80 ms or so.
Lately some of our bigger clients have complained of application freeze-ups.
Upon further investigation, it turns out to be due to the consumption of
available memory by sqlsevr.exe. The executable goes consistantly and not at
a slow rate.
We have wittnessed it growing from 8 mb to over 700 mb in six hours. I
found some info via google and have tried setting the memory throttle but I
don't think it is working. The sqlsevr seems to blow right by the setting.
Presently we are advising out clients to install loads of ram and that does
help but we need a real resolution.
Our clients run on Win2000Pro
I am deparately looking for some advise to either limit the rate of the
executable or it's max size.
Thanks
Run sp_configure to check what's the value for "max server memory
(MB)". Probably it will be 2147483647 which means SQL server can use
all of the available memory. While this is good for the performance of
SQL server, it might cause problems for other apps on the server.
So if the machine is not a dedicated database server (and usually MSDE
instances are not), limit the max server memeory to a more convenient
number.
M
|||hi,
DelphiDeveloper wrote:
> Six months ago I rework our application to use MSDE as a desktop DB.
> It was used to replace Paradox. I develop in Delphi with ADO.
> I realized tremendous performance gains and the ability to use stored
> procs and computed columns made many tasks far eaiser. But we seemed
> to have shot outselves in the foot. Because to the significant
> performance gains, we added additional features that involved complex
> queries.
> Our application, which supports the automation of chicken processing,
> is very DB intensive. We write a record to the database every 80 ms
> or so.
> Lately some of our bigger clients have complained of application
> freeze-ups. Upon further investigation, it turns out to be due to the
> consumption of available memory by sqlsevr.exe. The executable goes
> consistantly and not at a slow rate.
> We have wittnessed it growing from 8 mb to over 700 mb in six hours.
> I found some info via google and have tried setting the memory
> throttle but I don't think it is working. The sqlsevr seems to blow
> right by the setting.
> Presently we are advising out clients to install loads of ram and
> that does help but we need a real resolution.
> Our clients run on Win2000Pro
> I am deparately looking for some advise to either limit the rate of
> the executable or it's max size.
> Thanks
in order to better understand memory management in SQL Server/MSDE you can
have a look at
http://www.windowsitpro.com/Article/...908/37908.html and
http://www.windowsitpro.com/Article/...908/37908.html by Notre Dame
SQL Server Kalen Delany or, at a lower level at
http://msdn.microsoft.com/library/de...v_03252004.asp
by Ken Henderson...
SQL Server/MSDE manages memory at it's best without human intervention, but
even if concerned about OS/other application pressures and really doing it's
best to as gentleman as possible and freing unused (and even used memory
discarding query plans and cache) it works best if there's not much
concurrency for resources on the pc it is istalled on..
limitg it's max memomory setting will decrease it's responseness (is this
english? :D) and fewer query plans, cached objects and so on will be
available, requiring mor I/O activities (among the other)... If I corectly
understand your scenario, you are working quiet real-time, and forcing MSDE
into lower memory barriers can causes troubles..
actually 700 mb for SQL Server are not that much, but you know your
customers...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE on a local computer (not into a LAN)

I try to develop an installer that should install MSDE and an app that needs an MSDE database. But the problem is, that the ODBC (and my installer too) see no MSDE installation if the computer is no part of a network. If i plug the network cable, i can find the MSDE (SQL Server) without a problem. If i unplug it, my installer (and ODBC too) find no MSDE/SQL installation.

Can anyone help me? Maybe should i set another option when i install MSDE to make it work on a local computer that is no part of a network? Any advice would be a bid help.

Thank you,
IulianI don't know why i cannot work with MSDE when my computer is no more in network.. pls ..some help would be so needed|||So? Anyone any idea?|||I've got a .CAB and Setup.exe that installs for clients :

- MSDE
- Minimum SQL Server with the db Master, tempdb,... (free part)

Plus a little free Entreprise-Manager-Look-A-Like program

does this interast you ?|||and functions and when the client have a local computer (that isn't in a network)?

Many thanks for your time and help!!!|||the file .Cab is too big to be sent by here
email me your e-mail so that i can send you the package|||i have send u my email adress.

I wait your file.

Tnks again|||i didn't receive your email

MSDE newbie question

Hey All -
I need to develop a database that will be approximately 100 MB in size
and will have approx 15 concurrent users. I am attempting to
understand what my Microsoft database options are. Clearly Access is
one. What about MSDE? Do I need to purchase a copy of SQL Server to
utilize the MSDE technology? If so, which edition/CALs do I need?
Thanks for helping this DB rookie out.
Dave
It sounds like MSDE would work fine for your needs, depending on how often
the 15 user hit the server. Here is a link to some information about the
appropriate uses for MSDE:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
For a multi-user network client server application with a low number of
users MSDE is a very good choice. Purchasing a copy of SQL Server is not
necessary, although I would recommend buying the Developers Edition of SQL
Server ($50) for the development tools it provides and the ability to test
your application on SQL Server.
Personally, I wouldn't bother with Access as a backend data store.
Jim
"dave" <thorung@.mailcity.com> wrote in message
news:f9e0449e.0404201837.5eefeade@.posting.google.c om...
> Hey All -
> I need to develop a database that will be approximately 100 MB in size
> and will have approx 15 concurrent users. I am attempting to
> understand what my Microsoft database options are. Clearly Access is
> one. What about MSDE? Do I need to purchase a copy of SQL Server to
> utilize the MSDE technology? If so, which edition/CALs do I need?
> Thanks for helping this DB rookie out.
> Dave

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CAL
MSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
David Portas
SQL Server MVP

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CALMSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
David Portas
SQL Server MVP
--

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CALMSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
--
David Portas
SQL Server MVP
--