RMS 1.2 database size

Aug 27, 2005 3 Replies

I just checked the database size in my POS (we use MSDE) and found that the size is 41 MB, available 1.74 MB and usage is 96%.



I check the help file and MS customer source if this is a problem but did not find any hits. Is this something that I need to monitor and increase when the usage is this high? Also is there an option to tell SQL how much memory it could/should use (like in SQL server)?



I have enough free disk space and a total of 2GB of memory on my 2.66GHz system.



It just appears that my POS application should be a bit faster on this hardware.


No, they are defaulted to auto-increment by 10%. I added my remote SQL server to my "full SQL server" and was able to see all the database properties and found those auto-increment settings.

Thanks for your reply.

When you create your database, you specified two parameters for auto increment database size... do you have disabled this feature ?

antonio

"Gerd" ha scritto nel messaggio news:%23tf% snipped-for-privacy@TK2MSFTNGP12.phx.gbl...

alter database PIPPO modify file ( FILENAME=pippo, size 0mb, maxsize00mb, FILEGROWTH mb )

size = new size of database maxsize = maxsize filegrowth = autoincrement...

do you have a warning/error message from SQL Server in event log?

Antonio

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required