Should SQL Server 6.5 be doing this???

  • 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.

  • 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

    steve@dkranch.net

  • 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