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 |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2008-05-20 : 11:36:48
|
| hi guys,over the last week I have noticed an increased amount of locking on one of my servers.This is a reporting server so only Select statements are being run.Would there be locking due to an increased activity on the server or could it be that some settings have been changed ?where do I need to start looking to try and fix this ? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-05-20 : 11:40:39
|
| this is not a direct answer to your question but...Since it is a reporting sever have you considered using read uncommitted trans isol levels? (ie: nolock)Be One with the OptimizerTG |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2008-05-20 : 11:46:32
|
| hi TG,I have actually started to use with (nolock) on the tables , but unsure why I have had to start doing this. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-05-20 : 12:40:34
|
| an increase in locking could be due to a lot of things. Are you by any chance logging execution durations? If you are having some performance problems then obviously that will result in longer running SELECTs which will increase locking. And as you mentioned, increased user activity will also do it. What specific symptoms are you seeing?Be One with the OptimizerTG |
|
|
|
|
|
|
locking issues