February 6, 2002 at 11:01 am
I am using MSDE on Server NT4 (256 Mo of memory). When sqlserver memory reaches 128 Mo, there are troubles on PC clients (using access2000). Clients must shut down Access and I must relaunch sqlserver to free memory each day...
How to solve the problem ?
February 6, 2002 at 11:12 am
Not sure if you have a problem. Maybe its just keeping data cached? You could try dumping the data cache to see. Or set a max mem usage for MSDE?
Andy
February 6, 2002 at 11:36 am
A precision on my bug, at 128 Mo reached by the server, the 3 PC clients often disconnect from the server whatever the type of transaction.
Sometimes also some data of one client PC appears on another PC as if MSDE can't manage with 3 clients.
February 6, 2002 at 12:04 pm
Maybe you're opening more than one connection per client, exceeding the limit?
Andy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply