January 31, 2006 at 3:37 pm
We attached pretty big database (~4 TB) from server 2000 to Sql Server 2005 (compatibility level 80). As a result we have high CPU (average >90% for couple days) as 2K5 server does not use execution plan- every (or almost every) stored procedure is recompiled every call. What can be the reason or how to find it? Any help is really appreciated. Thanks
February 1, 2006 at 8:48 am
Use profiler to capture recompile events and look in the EVENTSUBCLASS column for the reason. For more information on interpreting these codes see the microsoft article:
A video of someone doing this can be found at:
see http://www.novicksoftware.com/Video_Recompile_Profiler.htm
Francis
February 1, 2006 at 2:24 pm
Thanks, Francis. I'll try it- hope this is working for Sql Server 2005 also
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply