strange Problem
- From: "DaveL" <dvs_bis@xxxxxxxxxxxxx>
- Date: Fri, 30 May 2008 07:46:07 -0700
Hello, hope u can help or point me in the right direction
I have 2 Services on our production System
1 Service is Vb6 (not the problem)
2 nd service is on another maching c# (not the problem)
these service insert and update a common Table
that links 2 separate databases (and there tables)
database1 and associated tables
database2 and associated tables
main database table PK
ive set up local running the services 30,000 files both services on separate
machings hitting the same table
this takes place in a Stored Proc
but in Production it locks up the system with a blocking
so web site is usless and internal processing is Useless
In the c#side and proc that i uses ive removed all begin trans, and on the
updates and selects i use (nolock)
and updates use (rowlocks)
still the same problem in production
any ideas would be greatly helpful
thanks
Dave
.
- Follow-Ups:
- Re: strange Problem
- From: Erland Sommarskog
- Re: strange Problem
- Prev by Date: Re: Need Help With an Update Script
- Next by Date: Re: Modeling/Constraint question
- Previous by thread: SQL Server 2000 UDF Intermittent Slow Execution
- Next by thread: Re: strange Problem
- Index(es):
Relevant Pages
|
