Viewing 4 posts - 76 through 79 (of 79 total)
Chris,
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...
May 18, 2005 at 11:47 am
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...
May 17, 2005 at 6:32 pm
Chris,
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,...
May 17, 2005 at 10:48 am
Petmani,
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...
May 17, 2005 at 10:42 am
Viewing 4 posts - 76 through 79 (of 79 total)