Re: 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?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Assuming 2005:

See the sys.dm_exec_cached_plans view. Note that this has the size of the cached plan. This does not include whatever data is read when executing the proc (like reading pages from a table).

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


"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message news:unSq2GQ6HHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • Re: Poor performance when executing stored procedure
    ... If SQL Server ... has to re-compile the SP, it takes shorter time to compile a smaller stored ... Poor performance when executing stored procedure ...
    (microsoft.public.sqlserver.programming)
  • Stored procedure does not complete until result set is retrieved from ODBC
    ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL/ASP - Timout Problem w/ Particular Statement
    ... inside the stored proc and i was executing one query or the other based ... > My asp page calls a stored procedure passing many parameters. ... > I used the SQL profiler to get the exact stored procedure with all ... > After executing 2-3 times the stored procedure in the Query Analyzer, ...
    (comp.databases.ms-sqlserver)
  • RE: Login failed for user foo but the SQL executed correctly
    ... Could you post the detailed error message when executing the stored ... and see under which user the stored procedure is executed. ... Is the error thrown by the stored procedure or the SQL Server 2000? ... | for user 'foo' error. ...
    (microsoft.public.sqlserver.security)
  • Re: sp_execresultset and ANSI_NULLS
    ... You can find the source code of sp_execresultset here. ... Create another sp using the source With ANSI_NULLS ON and try executing ... The problem is that no matter what I try, it creates the proc> with ANSI_NULLS OFF. ... These original>> settings are used when the stored procedure is executed. ...
    (microsoft.public.sqlserver.programming)