Re: Frustrated :(
From: Tibor Karaszi (tibor.please_reply_to_public_forum.karaszi@cornerstone.se)
Date: 11/21/02
- Next message: Ricardo Palmeira: "Windows Authentication with IIS on separate machines"
- Previous message: Jacky: "Need some security suggest"
- In reply to: Steven Burns: "Re: Frustrated :("
- Next in thread: Eric: "Re: Frustrated :("
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> Date: Thu, 21 Nov 2002 08:04:45 +0100
> nevermind, I got it....the proc cache is not persistent, it goes away when
> the server is restarted.
...and not only that (although that is enough). A plan is aged out as with any caching
algorithms. Also, SQL Server invalidates plans after a certain amount of data has been modified
in underlying tables. So, to answer your previous question, I guess one could say "Every now and
then...".
-- Tibor Karaszi, SQL Server MVP Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver"Steven Burns" <royalstream@hotmail.com> wrote in message news:eTb5VFNkCHA.1488@tkmsftngp11... > nevermind, I got it....the proc cache is not persistent, it goes away when > the server is restarted. > > Thanks. > > "Steven Burns" <royalstream@hotmail.com> wrote in message > news:#JtDMhLkCHA.2236@tkmsftngp10... > > Thanks, let me see if I get it... I cannot delete the text since sql2k > will > > need it to recompile. > > However...under what circumstances will sql2k need to repeat compilation? > I > > mean, does the proc cache gets emptied now and then? > > I ask because from the example it seems I would be able to delete the text > > as long as nobody calls 'dbcc freeproccache'. > > > > Steven. > >
- Next message: Ricardo Palmeira: "Windows Authentication with IIS on separate machines"
- Previous message: Jacky: "Need some security suggest"
- In reply to: Steven Burns: "Re: Frustrated :("
- Next in thread: Eric: "Re: Frustrated :("
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
