Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Query Cost Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2013 3:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:09 AM
Points: 227, Visits: 715
Hi Team,


As per my knowledge "Query Cost is a measure of the CPU and input-output resources used by the query"

but when am using a small query "select * from student where stud_id=1050"

in "Execution plan" window query cost is showing as 100%,

Reason please.....
Post #1422005
Posted Wednesday, February 20, 2013 3:27 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:08 AM
Points: 617, Visits: 1,273
The percentage you are seeing is the percentage relative to the batch.
Since there is only one query in batch it shows 100 percent.

If you had more than one statement for a eg if it was a stored proc, you would see this spread across the queries.


-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1422011
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse