Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-01-22 : 11:32:10
|
| I've read several articles about how to avoid having Stored Procs recompile.How would I get statistics on SP's recompiling? Enquiring minds want to know.Sam |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-01-22 : 11:37:23
|
| Performance monitor will give you a recompilations / second metric. You can also use Profiler to capture the event SP:Recompile. That will tell you specifically which procedures are recompiling. Randy Dyess has some great articles on recompiles. I've seen some great performance improvements by eliminating them. Especially on SQL7.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
|
|
|
SP Recompiles