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 |
|
SQLPradeep
Starting Member
3 Posts |
 Posted - 2010-06-09 : 16:55:16
|
| Hello guys,I noticed a High SQL Compilations/sec on my production instance...On further investigation i concluded this is due to, not having any Actual plan(I m assuminng since there is no plan everytime i execute the statement it is compiling)...So there is lot of CPU usage on my production instance....How do i solve this issue???Pradeep |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-06-10 : 05:54:45
|
| 1. are you using Stored Procedures?2. are you using a table qualifier of "dbo." within those SP's?Can you post sample code? |
 |
|
|
|
|
|
High SQL Compilations/sec