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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2006-10-18 : 11:03:33
|
| I have Sql compilations/sec averaging 150 and higher. I've justdiscovered that sp_updatestats runs every night. Could this be causingor contributing to high sql compilations/sec??Thanks |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-10-18 : 11:08:22
|
| Are your SP's coded "with recompile"?are you using ....references to "dbo." for your tables in your SP's...and when calling the SP's? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-18 : 11:09:16
|
| Doubt it.Things might get a new plan the first time they ran the next day but after that should be ok.Probably due to the queries you are running or is something purging the query plans?Try running the profiler to see what is going on.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2006-10-18 : 11:46:07
|
| no with recompile, no references to dboAlso procs use dynamic sql... this must be culpritthanks, |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-10-19 : 10:58:53
|
| "dynamic sql"....pourquoi?you do know there are security implications with D-SQL? references to dbo"..there should be!objects qualified with "dbo." are faster to locate/execute. |
|
|
|
|
|
|
Sql compilations/se