Jonathan, are you suspecting index is fragmented?

Thank you Jeff.

Thanks Andrew.

okay. I get it.

Hi John,

It could be 55,126 rows matching with that parameter value and so it has executed that many times. correct me if I am wrong.

Is there any other ways, to...

Table size is almost 1GB. i.e. 842.07 MB

Row count = 64750

no triggers on the table .

table script

============

CREATE TABLE [dbo].[tname](

[PARENT_PUB_KEY] [bigint] IDENTITY(1,1) NOT NULL,

[CREATE_DATE] [datetime] NULL,

[CREATED_BY] [nvarchar](100) NULL,

[SOURCE_SYSTEM] [nvarchar](100) NULL,

[INTERFACE] [nvarchar](50)...

• This reply was modified 6 years, 2 months ago by vsamantha35. Reason: add more details
• This reply was modified 6 years, 2 months ago by vsamantha35. Reason: add details
• This reply was modified 6 years, 2 months ago by vsamantha35. Reason: edit for more details

thanks all for the valuable suggestions.

Thank you Steve.

Thank you very much Sir. Great information.

Only need to capture qry and its response time so that tomorrow they should come back and complain old or new server.

Hi Sir,

Thanks for the valuable inputs provided.

Couple of follow up questions?

1. Why we need to consider rpc_completed and why I can't I just go with sql_batch_completed? want to understand why...

Okay. thanks Thom.

Thanks for the pointers for dynamic sql . it has to come from FROM clause.

Thanks for all the inputs.

Thanks Thom for valuable inputs. I will try to see If I can get the ddl scripts and actual execution plan.

Thanks a lot Sir. Got it.