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 |
|
Lady
Starting Member
32 Posts |
 Posted - 2002-09-18 : 05:50:30
|
| Could anybody explain me how shell I understand percent cost in execution plan? Where 100%? I have Items with diferent costs (38,75...), but this cost are part of WHAT? |
|
|
Crespo
85 Posts |
Posted - 2002-09-18 : 06:10:17
|
quote:
Could anybody explain me how shell I understand percent cost in execution plan? Where 100%? I have Items with diferent costs (38,75...), but this cost are part of WHAT?
As I understand it, SQL server has memory used to store execution plans and data. The percentage given is the amount of memory allocated to that particular process.Does that make any sense?Good Luck!Crespo.Hewitt Bacon & WoodrowEpsomSurreyUnited Kingdom |
 |
|
|
Lady
Starting Member
32 Posts |
Posted - 2002-09-18 : 08:03:15
|
| thanks, it's clear now.But why QA stoped to show costs after running sp some times?at all items cost = 0%it's connect with cash and recompile sp?how shell I see real costs? |
|
|
|
Crespo
85 Posts |
Posted - 2002-09-18 : 10:49:20
|
Sorry I did not reply earlier as I have been REALLY busy with this damn migration!  Anyhow, the answer to your question is as follows :When any SQL statement is executed in SQL Server, the database looks through the procedure cache to verify that an existing execution plan for the same SQL statement exists. SQL Server would then reuse any existing plan if it finds one. This obviously results in saving resources and thus the overhead of recompiling the SQL statement. If no existing execution plan exists, SQL Server generates a new execution plan for the query.I hope this answers your question as my knowledge regarding this topic is quite limited.  Good Luck!Crespo.Hewitt Bacon & WoodrowEpsomSurreyUnited Kingdom |
|
|
|
|
|
|
execution plan