Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ann_29
Starting Member
5 Posts |
 Posted - 2009-08-04 : 04:18:20
|
what can i do in this problem? Can you give me a solution in this kind of problem?  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-04 : 04:33:03
|
Not really. We have to see the query giving you a hard time.As a rule of thumb better index strategy can help to avoid blocking.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
ann_29
Starting Member
5 Posts |
Posted - 2009-08-04 : 04:47:14
|
quote:
Originally posted by Peso
Not really. We have to see the query giving you a hard time.As a rule of thumb better index strategy can help to avoid blocking.
N 56°04'39.26"E 12°55'05.63"
so what is the strategy can you give me? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-04 : 04:49:35
|
Without seeing your query giving you the blocking, I would give the advice to use a better index strategy than you have today.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
ann_29
Starting Member
5 Posts |
Posted - 2009-08-04 : 05:14:01
|
quote:
Originally posted by Peso
Without seeing your query giving you the blocking, I would give the advice to use a better index strategy than you have today.
N 56°04'39.26"E 12°55'05.63"
so how about on synchronization? |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-04 : 05:23:03
|
| Peso is saying:1) All situations are different2) You haven't given any information about your *EXACT* situation.3) We can't advise you unless you provide more information.The problem is most likely a bad query that is holding locks for too long because it is not coded in an efficient way. OR it could be that your indexes are not suitable for the query.If you want more help stop asking general questions and post the query that is causing the problem. Also post the current indexes you have on the effected tables.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
How to optimized the blocked processes of data?