Groups | Blog | Home
all groups > sql server programming > september 2004 >

sql server programming : configuration parameter "locks"


rschiller NO[at]SPAM utanet.at
9/1/2004 11:54:38 PM
Hi,
does anybody know what the number in parameter "locks" mean? I
believed it is a number of locks, but if I set it to 5000 (minimum),
it would be then 5000*96/1024 = 468Kb, but SQL Server 2000 allocates
at start 480Kb, as sysperfinfo tells me. How is it possible? Or does
the number mean 5000Kb? Anybody knows?

Thanks

Andres Taylor
9/2/2004 9:08:16 AM
Hiya Richard,

I'm guessing here, but could it be that they are counting with 1 KB = 1000
B? It would make sense, since that would make your formula work, right?

Let us know if you find anything else about this.

/andrés

[quoted text, click to view]

Tibor Karaszi
9/2/2004 9:27:56 AM
Also, why touch this config parameter in the first place?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


[quoted text, click to view]

Andres Taylor
9/2/2004 2:10:14 PM
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:%23SO$d5LkEHA.704@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

Because you can?

/andrés

Tibor Karaszi
9/2/2004 2:17:00 PM
[quoted text, click to view]

LOL

Yes, I see a lot of this with sp_configure "out there". ;-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


[quoted text, click to view]

AddThis Social Bookmark Button