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..
Thanks
This article might help.
HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/default...b;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:
http://msdn.microsoft.com/library/de...rfmon_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/default...b;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/pro...05/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
>