|
Home > Archive > MS SQL Server > February 2006 > High Number of lock requests
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
High Number of lock requests
|
|
|
| We're running SQL2K over 2K server, there server just has one main database
besides the system' ones for our administration system
Recently we got a tool for monitoring the server and it's registered up to
5.500.000 lock requests/min, my point is, is that normal?
| |
| Andrew J. Kelly 2006-02-10, 9:23 am |
| It really depends on what you are doing but it sounds like you have a lot of
scans happening. Basically sounds like you are missing proper indexes and
reading too many rows when you select or modify.
--
Andrew J. Kelly SQL MVP
"FJC" <FJC@discussions.microsoft.com> wrote in message
news:0F0E10B5-9D70-4EB1-AD64- 0CA9480910DB@microso
ft.com...
> We're running SQL2K over 2K server, there server just has one main
> database
> besides the system' ones for our administration system
> Recently we got a tool for monitoring the server and it's registered up to
> 5.500.000 lock requests/min, my point is, is that normal?
| |
|
| Thanks Andrew
I had a look at some of the tables and as you said it seems the developers
did not index the tables properly; I just set a couple of indexes and the
reads went down straight away.
Thanks
"Andrew J. Kelly" wrote:
> It really depends on what you are doing but it sounds like you have a lot of
> scans happening. Basically sounds like you are missing proper indexes and
> reading too many rows when you select or modify.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "FJC" <FJC@discussions.microsoft.com> wrote in message
> news:0F0E10B5-9D70-4EB1-AD64- 0CA9480910DB@microso
ft.com...
>
>
>
|
|
|
|
|