I/O and CPU Cost in Query Analyzer

I am re-posting. I neglected to put in my email address in my newsgroup
settings. My apologies.
Is there somewhere in the BOL that I can find out what are acceptable
numbers when looking at I/O and CPU cost when running the estimated
execution plan in Query Analyzer.
Thanks,
`BenThere is no correct answer to your question... except to say, if performance
is good enough... and generally speaking smaller is better...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Ben M" <"Ben M"> wrote in message
news:uAHrFtWxDHA.1088@.tk2msftngp13.phx.gbl...
> I am re-posting. I neglected to put in my email address in my newsgroup
> settings. My apologies.
> Is there somewhere in the BOL that I can find out what are acceptable
> numbers when looking at I/O and CPU cost when running the estimated
> execution plan in Query Analyzer.
> Thanks,
> `Ben
>|||bol doesn't really talk about this, i have some info on
this subject:
http://www.sql-server-performance.com/
jc_sql_server_quantative_analysis1.asp
as to what cost is acceptable, it depends on your app,
if you need to support 1000 users, then your queries need
to be efficient, if 10 users, you can have more complex
queries
if you are running an app for many users, i would watch
out for any query that exceeds the parallel execution
default of 5, but you can change that, in general your
queries should be much less than 5
>--Original Message--
>I am re-posting. I neglected to put in my email address
in my newsgroup
>settings. My apologies.
>Is there somewhere in the BOL that I can find out what
are acceptable
>numbers when looking at I/O and CPU cost when running the
estimated
>execution plan in Query Analyzer.
>Thanks,
>`Ben
>.
>|||I try to focus on Sub-Tree Cost.
If the Total subtree cost of the query gets up to double digits, you got
problems.
Here, we have a standard to push for subtree of 5.0 or less before a sproc
gets released to production.
(Obviously we make exceptions when necessary)
Cheers
Greg Jackson
PDX, OR