by Hi ,
I too wanted to know about the stored procedure size.This mail
was helpful.It would be great if U could
let me know,if it the size is in KB or pages.
Thanks in advance
Sangeetha
>
> Hi,
>
> How can the size of the SP & trigger be computed ?
>
> We checked with sp_spaceused <obj_name>, the response was
>
> 'object stored in "sysprocedures" and no space is allocated
directly
> " '
>
> Is there any freeware available to compute the size of the sp,
trigger
> & table?
>
> - Bhanu
From the Sybooks Performance and Tuning Guide:
To get a rough estimate of the size of a single stored procedure,
view,
or trigger, use:
select(count(*) / 8) +1
from sysprocedures
where id = object_id(" procedure_name")
For example, to find the size of the titleid_proc in pubs2:
select(count(*) / 8) +1
from sysprocedures
where id = object_id("titleid_proc")
-----------
3
--
-----------------------
Shawn Enderlin, DBA
Holiday Companies