Compilations/sec vs recompilations/sec

Trying to understand what would trigger compilations vs recompilations . I
see quite a few of them for both events in Perfmon..
ThanksThis article might help.
HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/defaul...kb;en-us;243588
Adrian
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uZzCX5OTFHA.3840@.tk2msftngp13.phx.gbl...
> Trying to understand what would trigger compilations vs recompilations . I
> see quite a few of them for both events in Perfmon..
> Thanks
>|||This one as well:
on_1wl0.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
on_1wl0.asp
"Adrian Zajkeskovic" <azajkeskovic@.hotmail.com> wrote in message news:...
> This article might help.
> HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
> http://support.microsoft.com/defaul...kb;en-us;243588
> Adrian
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uZzCX5OTFHA.3840@.tk2msftngp13.phx.gbl...
>|||Here is another good article you might want to read. Even though it is
referring to 2005 most of the principles are true for 2000 as well.
http://www.microsoft.com/technet/pr...005/recomp.mspx
Andrew J. Kelly SQL MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uZzCX5OTFHA.3840@.tk2msftngp13.phx.gbl...
> Trying to understand what would trigger compilations vs recompilations . I
> see quite a few of them for both events in Perfmon..
> Thanks
>