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?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@.microsoft.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@.microsoft.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?
>
>
No comments:
Post a Comment