here is an article which might give you some clue
On Mon, 27 Aug 2007 16:26:19 -0700, Daniel
> in sql server is it possible to get the amount of memory used by a stored
> procedure? e.g. memory usage statistics per stored procedure?
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/