Yes, all blocked processes were trying to execute the same stored procedure. The stored procedure is very simple and it doesn't take long time to compile it. I was thinking...
Chris, thanks for you hint regarding sysindexes table. I am monitoring rowmodctr where indid=1 (clustered index).You are right, table is big (27 million rows). All procedure calls qualify it with an...
I am also puzzled why this is happening every 3-4 days. Base table is modified every hour. I think SQL Server is forcing recompilation of all procedures referencing base,mail,...
You seem to be right on number 4. According to our developer, there are changes happening in base,mail, table:' table gets purged of rows belonging to inactive accounts on...