SQL Server Performance

SP compiles

Discussion in 'Performance Tuning for DBAs' started by colinrees, Nov 23, 2003.

  1. colinrees New Member

    we are running some sp's at very high volume (about 160 / sec) on a clustered SQL server 2000 solution. The problem is that we are seeing very high levels of compiles (0 recompiles but about 300 compiles per second). I cant seem to get any info on this from profiles, any ideas ?

  2. Luis Martin Moderator

    Kindly don´t duplicate post.

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. colinrees New Member

    I didnt realise it had posted.

Share This Page