May 7, 2002 at 5:17 am
We have a server running an App which via about 6 stored procs updates a few tables. There are constantly 2/3 people entering data. While they are doing this, they are experiencing locking and waiting when one does an update of their data. The app didn`t used to do this on a dual processor machine, but it seems to now on a single proc machine. I`ve made some server configs, i.e. increased the mem available to the server, and the number of available threads, but that doesn`t seem to have helped. Has anyone got anymore ideas, it`s doing my head in!!!
Andy.
May 7, 2002 at 3:51 pm
v6.5 does have some locking issues in places, especially if you make use of temporary tables.
I'd need more testing, but this doesn't surprise me.
Steve Jones
May 8, 2002 at 4:32 am
Have alleviated the problem a bit, increased the RAM the server ca use to nearly a GIG. Application seesm to run faster. Have a feeling the locks are still there but not as noticable as they are shorter. Although have run a SQL Perf Mon and can`t see the locks anymore where I could before?!?
Andy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply