Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Compile lock problems on a specific SP RE: Compile lock problems on a specific SP

  • March 3, 2014 at 11:15 am

    #1693651

    Do you do Index Maintenance and index rebuilds ? Also see if you can find any missing indexes.

    Is this 32 bit or 64 bit ? What are your memory settings

    --

    SQLBuddy