What exactly is defined by "number of locks"

[parbhani]

Hi all ,

I have landed in a slight confusion over the value of "number of locks", we get in sp_configure.

What does that indicate ?

Does it give the number of locks, which can be made in that data server ( at any given point of time for all possible objects in the data server ) ?

Or it gives us the number of concurrent locks which can be made on one single unit ( page, segment or table ) at one point in time ?

Means, if number of locks=10000 , I can have total 10000 number of locks at given point in time, for all possible objects in the data server.
OR
I can have 10000 locks on one unit ( page, segment or table ) at one time, which looks a pretty illogical and wrong statement to me.

Please explain.

Regards

 

[parbhani]

Hi Guys,

I need help ... come ooooon ....