In Execution plan diffrence between the seek predicate,& seek predicates

Question

In Execution plan diffrence between the seek predicate,& seek predicates

SAT_SQL

Default port

Points: 1465
More actions
June 16, 2009 at 7:07 am

#222619

Hi all
especially to gail
I am going through ur artical 1,2, in the sql profilers,
Question :in ur example view threads , u have shown that , in execution plan index predicat, then the statements is looking like
[webforums].[dbo].[posts].[threadid]=[@threadID]
Then u added
CREATE NONCLUSTERED INDEX idx_Posts_ThreadID
ON Posts (ThreadID)
In my Executionplan it look like predicates
[Worksampl].[dbo].[tblleaddetails].leadID=[@leadID]
similarly i also want to add any index,i need clarfication.
sat

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Post the execution plan please

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SAT_SQL Default port Points: 1465 More actions · Answer 2

sorry Gile,

i will send it today.

gile and all . i have one more dout in trace

Question : i want to no what are the events are columns

that trace is running for , for suppose i am having one procedure name called

EXEC PrRunMarginReport '4/1/2008', '3/31/2009'

for this particular procedure i want to get the trace id , how can i no.

when i worked for some examples, i can not understanding, can u please,

regards

sat

SAT_SQL Default port Points: 1465 More actions · Answer 3

sorry Gile,

i will send it today.

gile and all . i have one more dout in trace

Question : i want to no what are the events are columns

that trace is running for , for suppose i am having one procedure name called

EXEC PrRunMarginReport '4/1/2008', '3/31/2009'

for this particular procedure i want to get the trace id , how can i no.

when i worked for some examples, i can not understanding, can u please,

regards

sat

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

SAT_SQL (6/17/2009)
Question : i want to no what are the events are columns
that trace is running for , for suppose i am having one procedure name called
EXEC PrRunMarginReport '4/1/2008', '3/31/2009'
for this particular procedure i want to get the trace id , how can i no.
when i worked for some examples, i can not understanding, can u please,

Sorry, I don't understand what you're asking. Can you be a bit clearer please?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

digitalox SSCommitted Points: 1830 More actions · Answer 5

To get the running traces:

SELECT

*

FROM

fn_trace_getinfo(default)

WHERE

property = 5 and value = 1

There's a tutorial here on how to analyze the default trace:

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

It may be a good starting point to walk through and might answer some of your questions.

--

Scott

SAT_SQL Default port Points: 1465 More actions · Answer 6

Hi

i want to send exe plan , but is not permiting the .sql , can u please send what type i can

Regards

sat

SAT_SQL Default port Points: 1465 More actions · Answer 7

hi

here is my execution plan

Please sendthe detals

regards

sat