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
ERIC CRUDELI
SSCommitted
Points: 1786
More actions
March 6, 2014 at 12:20 am
#1694552
Do you do Index Maintenance and index rebuilds ? Yes, I do just before issue.
Also see if you can find any missing indexes. No missing indexes
Is this 32 bit or 64 bit ? 64bits
What are your memory settings ? Max memory setting fo SQL 50000 Mo