i calling stored proc doing insert on table. table has primary key defined. works fine in development environment. after application has been published production server , users complaining freezes occasionally. tried replicated issue using same data, works fine. assuming freezes many users hitting same table. cannot use 'with nolock' statement on insert. recommend fix issue?
note: mention requests go through production servers, alias sent ip load balancer, depending upon our web farm (4 individual production web servers) direct users 1 of 4 web servers session reside.
Comments
Post a Comment