Re: Table variables

microsoft.public.sqlserver.misc
Date: 11/03/04 

Date: Wed, 3 Nov 2004 15:11:15 -0000

Thanks for your help
<microsoft.public.sqlserver.misc> wrote in message
news:ubaaHpZwEHA.3976@TK2MSFTNGP09.phx.gbl...
> I am working with a system that uses quite a lot of stored procedures
> that make use of table variables extensively. The ram used by the
> database server quickly rises to close to 2 Gb. The amount of memory
> used by sql server is limted but as soon as the memory reaches the
> limit, the performance of the system is reduced greatly. It seems to
> me that the table variables when used are of no use outside the
> procedure in which they were created, however, the memory used doesn't
> seem to be de-allocated. Is there any way of de-allocating the memory
> used by a table variable once finished with within a sp.
>
>

Relevant Pages

  • Re: So, anyone asked about Win64 at Borcon?
    ... Since scalability and large memory access ... CLR stored procedures. ... will be slightly faster in extended stored procedures than CLR stored ... procedures for each processor type you want to run your SQL server on. ...
    (borland.public.delphi.non-technical)
  • high Compilations/sec value
    ... Would someone please explain what causes a high "Compilations/sec" count? ... Is still caued by stored procedures not being cached and not enough memory ... alloacted to SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Performance degrading over time
    ... If you have lots of other things than SQL Server on the same box you might ... leave enough memory for them to operate properly minus about 200MB. ... > performance happens across different stored procedures, ...
    (microsoft.public.sqlserver.clustering)
  • Table variables
    ... I am working with a system that uses quite a lot of stored procedures ... database server quickly rises to close to 2 Gb. ... The amount of memory ... Is there any way of de-allocating the memory ...
    (microsoft.public.sqlserver.server)
  • Performance degrading over time
    ... physical CPU, 2 gigs of memory ... Active/Passive failover clustering ... performance happens across different stored procedures, ... CPU, memory, physical disk i/o and network utilization are all at ...
    (microsoft.public.sqlserver.clustering)