| Author |
Compilations/sec vs recompilations/sec
|
|
| Hassan 2005-04-29, 8:23 pm |
| Trying to understand what would trigger compilations vs recompilations . I
see quite a few of them for both events in Perfmon..
Thanks
| |
| Adrian Zajkeskovic 2005-04-29, 8:23 pm |
| 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...
> Trying to understand what would trigger compilations vs recompilations . I
> see quite a few of them for both events in Perfmon..
>
> Thanks
>
>
| |
|
|
| Andrew J. Kelly 2005-04-29, 8:23 pm |
| 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
>
>
|
|
|
|