join the MSSQLTips community

MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

 
Reclaim Memory After FullText Catalog Execution On SQL Server 2008 - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Reclaim Memory After FullText Catalog Execution On SQL Server 2008

Last post 06-24-2009 4:45 AM by Sheeraz. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 06-24-2009 4:45 AM

    Reclaim Memory After FullText Catalog Execution On SQL Server 2008

     

     I have a server that has 16 Gigs RAM and having Windows 2003 Enterprise Server with SQL Server 2008 Enterprise Edition Sp2.

    Now I have 6 FullText Catalogs each approx. size of 2 GB, and I use them separately from different stored procedures and I am not executing stored procedures simultaneously.

    Now I want to know that is there any way i reclaim the memory which is occupied by Fulltext Catalog before executing second stored procedure?

Page 1 of 1 (1 items)