On May 29, 12:30=A0pm, Bum...@[EMAIL PROTECTED]
wrote:
> When I run sp_configure "procedure cache size" I got a table about
> procedure cash (parameter name, default, ...). How can i get config
> value of procedure cache size using sql query?
you can grab the sql from sp_configure or directly query sysconfigures
and syscurconfigs tables in master database where name like
"%procedure cache%" , here is the sample..
select "Parameter Name" =3D convert(char(30), name),
"Default" =3D convert(char(11), space(11-char_length(
convert(varchar(11), defvalue)))+
convert(varchar(11), defvalue)),
Memory Used" =3D convert(char(11), space(11-char_length(
convert(varchar(11), b.comment)))+
convert(varchar(11), b.comment)),
"Config Value" =3Dconvert(char(11), space(11-char_length(
isnull(a.value2, convert(char(32), a.value)))) +
isnull(a.value2, convert(char(32), a.value))),
"Run Value" =3D convert(char(11), space(11-char_length(
isnull(b.value2, convert(char(32), b.value)))) +
isnull(b.value2, convert(char(32), b.value))),
"Unit" =3D convert(char(20), b.unit),
"Type" =3D convert(char(10), b.type)
from master.dbo.sysconfigures a,
master.dbo.syscurconfigs b
where
a.config *=3D b.config
and name like "%" + "procedure cache" + "%"
and parent !=3D 19
and a.config !=3D 19
order by name
-HTH
Manish Negandhi
[TeamSybase]
|
