MSDE memory Usage

It seems that the MSDE running SP3a is eating up about 100MB every few days
on my system. Once I reboot it settles down but starts it up again. Is
there a memory leak? Is there a way to calm down the SQLSERVER.EXE memory
usuage?
Thanks
The SQL Server 2000 database engine is designed to take advantage of as much
memory as it can without impacting other applications. If other applications
start running on the computer the database engine will dynamically release
memory for their use. You can also tailor how much memory the database
engine uses by setting configuration options.
For more information, see:
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

MSDE Intstallation Problem

Hallo!

When installing MSDE (run setup) the process starts; when it is nearly at the end (progbar rigth), then suddenly the progbar goes very quick to the left side and the installtion is over.
There ist no error msg or something like that. The only event code is 11708(information) from the msi installer.

I have an XP pro System (not SP2).

Thx in advance for helpsry double post|||I'm also having this same problem, except I'm running XP Home.

I'm using the MSDE that comes with the [b]SAMS Teach Yourself ASP.NET In 24 Hours[/b] book, and after I've typed in the command line:

setup SAPWD=password SECURITYMODE=sql

it begins to install. Then after the green bar goes back to left the dialog box closes and then nothing happens. According to the book I should be promted to resart my computer, but I'm not. And the MSDE icon doesn't appear in the system tray.

I've tried restarting my cmputer manually and also downloading MSDE from http://asp.net/msde but the same thing happens.|||Please refer to my post in this section under the subject: "Overcoming MSDE Setup Problems".
Link: http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=739042|||Here is the log file

RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
MSI (s) (A0:D0): QueryPathOfRegTypeLib returned -2147319779 in local context. Path is ''
MSI (s) (A0:D0): CMsiServices::ProcessTypeLibrary runs in local context, not impersonated.
MSI (s) (A0:D0): ProcessTypeLibraryCore returns: 0. (0 means OK)
MSI (s) (A0:D0): Executing op: ActionStart(Name=InstallServices,Description=Installing new services,Template=Service: )
Action 20:21:56: InstallServices. Installing new services
MSI (s) (A0:D0): Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000)
MSI (s) (A0:D0): Executing op: ServiceInstall(Name=SQLAgent$MATRIXDB,DisplayName=SQLAgent$MATRIXDB,ImagePath=D:\programme\Microsoft SQL Server\MSSQL$MATRIXDB\Binn\sqlagent.EXE -i MATRIXDB,ServiceType=16,StartType=3,ErrorControl=1,,Dependencies=MSSQL$MATRI
XDB
MSI (s) (A0:D0): Executing op: ServiceInstall(Name=MSSQL$MATRIXDB,DisplayName=MSSQL$MATRIXDB,ImagePath=D:\programme\Microsoft SQL Server\MSSQL$MATRIXDB\Binn\sqlservr.exe -sMATRIXDB,ServiceType=16,StartType=2,ErrorControl=1,,,,,,)
MSI (s) (A0:D0): Executing op: ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
Action 20:21:57: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (s) (A0:D0): Executing op: CustomActionSchedule(Action=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Source=BinaryData,Target=InstallPerfMon,)
MSI (s) (A0:D0): Creating MSIHANDLE (676) of type 790536 for thread 1744
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOKUME~1\Ifoko\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOKUME~1\Ifoko\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 20:21:57: InstallFinalize. Return value 3.
MSI (s) (A0:D0): User policy value 'DisableRollback' is 0
MSI (s) (A0:D0): Machine policy value 'DisableRollback' is 0
MSI (s) (A0:D0): Executing op: Header(Signature=1397708873,Version=200,Timestamp=829465254,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (A0:D0): Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (A0:D0): Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (A0:D0): Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=,CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: )
Action 20:21:57: Rollback. Rolling back action:

I have XP Pro; tried it with msde2000a too -> same phenomen, rollback before finishing;

Maybay I should delete everything from MSDE out of the registry, because I think there are some keys from old installations, which make trouble.

Anyone an idea ?
espezially: MSI (s) (A0:D0): Creating MSIHANDLE (676) of type 790536 for thread 1744
What does this mean ?
thx|||No one an idea ?

I think the problem is the are bad keys in the registry from old installations. There are still MSSQL$... keys by the legacy settings. But I cant delete them.

plz help|||These MSDE installation errors are frustrating, and there are so many different causes that it can be difficult to help you troubleshoot.

The area to focus on there is "PerfmonLoad routine returned error code 6". See if something in this KB article helps you:A SQL Server Desktop Engine 2000 installation fails when it tries to register Performance Monitor counters.

Terri|||Thx a lot!

I think this is the rigth way.
So next Problem: I think the error comes that I have no permission to update the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009 keys
Its mentioned in the article to have permission to the keys.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\007 (german) I got full permission and I can change the key with regedit.

I run XP Pro (german) and I am the only user (administratror group).

So how could I manage to update the 009 key ?|||Please help :P

So i tried some other things without succsess:
* regional settings to englisch ;(
* deleting everything from reg with "mssql"
* using msizap to remove

Still the problem when installing the performance counters for MSDE.

I looked with regedit at the permissions at the key and I should have full. But I still can not change the key.

lg|||I don't have anything to offer other than what was in the article. Did you follow it step by step from the top down -- including making sure all of the indicated services were turned off?

Sorry not to be more help.

Terri|||"Please help :P

So i tried some other things without succsess:
* regional settings to englisch ;(
* deleting everything from reg with "mssql"
* using msizap to remove

Still the problem when installing the performance counters for MSDE.

I looked with regedit at the permissions at the key and I should have full. But I still can not change the key.

lg "

Have you tried my solution? Use DISABLEROLLBACK=1 and restart. Then delete the installed files and install again. It worked for me. I also tried to delete stuff from the registry with no success. Then I tried the DISABLEROLLBACK route and it worked.

Auf Deutch:

Haben Sie meine Lösung versucht? Verwenden Sie DISABLEROLLBACK=1 und beginnen Sie wieder. Dann löschen Sie die angebrachten Akten und bringen Sie wieder an. Es funktionierte für mich. Ich versuchte auch, Material aus dem Registry ohne Erfolg zu löschen. Dann versuchte ich den DISABLEROLLBACK Weg und es funktionierte.

Now back to English:

I hope this helps. I see you already have posted on my "Overcoming MSDE Setup Problems" thread. Link: http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=750253

MSDE installation problem in Windows XP

Dear All,
We have been facing problems in installing MSDE 2000 in machines having
Windows XP. The installation starts and then after sometime it retraces back.
The error seems to be because of something related to SQLAgentSecurity.
I am attaching the error log details ( the portion which mentions about the
error) below.
Has anyone faced any similar issues? Can anyone help?
Regards,
Ani
Error log details
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 17:11:59: WriteEnvironmentStrings. Updating environment strings
WriteEnvironmentStrings: Name: PATH, Value: c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\, Action 1610612738
Action 17:11:59: RegisterTypeLibraries. Registering type libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
Action 17:12:03: InstallServices. Installing new services
Action 17:12:04: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
Action 17:12:05: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action CallSQLAdHlp
c:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
Action 17:12:06: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
Action 17:12:06: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
Action ended 17:12:07: InstallFinalize. Return value 3.
Action 17:12:07: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
Rollback: Installing new services
Rollback: Registering type libraries
Rollback: Updating environment strings
Rollback: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B
Rollback: Writing system registry values
Rollback: Unregistering program identifiers
Rollback: Registering Class servers
Rollback: Creating shortcuts
Rollback: Creating duplicate files
Rollback: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: NoRebootReplace.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: RollbackNoRebootReplace.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\SqlSetup\Temp
Rollback: InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Rollback: Copying new files
Rollback: Creating folders
Rollback: Removing ODBC components
Rollback: Deleting services
Rollback: Stopping services
Rollback: Updating component registration
Rollback: RollbackStreamSupportFiles.2D02443E_7002_4C0B_ABC9 _EAB2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
Rollback: RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
Action ended 17:12:14: INSTALL. Return value 3.
Action ended 17:12:14: INSTALL. Return value 3.
=== Logging stopped: 4/28/2005 17:12:14 ===
MSI (c) (94:24): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
hi,
Aniruddha wrote:
> Dear All,
> We have been facing problems in installing MSDE 2000 in machines
> having Windows XP. The installation starts and then after sometime it
> retraces back. The error seems to be because of something related to
> SQLAgentSecurity.

> InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
> Action ended 17:12:07: InstallFinalize. Return value 3.
you probably do not have File & Printer Sharing Services turned on.
please chek the control panel, Admin Tools - Services and (eventually) set
it to on.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation

Hi!

I have a big problem installing msde on an XP Pro. When I try to install (run setup), the process starts and when its nearly finished the progess bar goes quickly down.
There is no error msg or something like that. The event no is 11708 (msi information).

I tried setup with many differnt parameters SAPWD=... Always the same: When quite finished installing, it ends.

I looked now for many hours in the forum and did not find any help.
Does anyone have a good solution ?

thxTry fully removing the current installation, if it's in Add/Remove programs - then, try following this tutorial:
http://aspnet101.com/aspnet101/tutorials.aspx?id=44

If this doesn't work, I'd say, offhand, that you might have some computer problems/issues. If you have Norton's - try running their utilities on your computer to see if anything turns up.