Thanks for your reply.

Yes i tried sir, but it didn't worked.

Even i tried using dtexecUI but i don't where i should pass my parameters ?? if i use...

Hi Gali,

I am having an issue in setting up Mirroring in my laptop. Currently i'm using sql server standard edition 2005 sp3. When i'm trying to set up the...

Any suggestions please

@Gale

Ya lower edition of SQL on Server 1 which is slow and Enterprise edition on Server2 which is fast and coming to system configurations:

Server 1: its a very beefy...

Ya I found that we are using SQL STANDARD edition sp2 on Server 1 and Enterprise edition sp2 on Server2 and I can a lot of data load on...

@Gail

In order to test the performance i took a backup from server 2 where everything was working very fast and i restored that in my server 1 as a...

@dave-3

If you don't mind can you please tell me what you mean by slowly strip the query down? and how to do it?

Thanks.

For a reference i have executed sp_who2 on my server and below is the cpu time and disk i/p but i heard that even if i restart the server they...

Hi @Gila I have modified my stored procedure with the code which you have given me but still it took like 13+ mins to execute the stored procedure.

@dave-3

...

Shall i update the stats with no recomplie ? or just update stats?

Both view and stored procedure is slow. Exec plans with AX are slow and J or Jasom are fast. As i said this view has called in that stored procedure....

Ya I updated the stats and i guess everything is same? Here are execution plans for procedure and view on both servers.

Hi Lowell,

Thanks for your information. Just to let you know I am running the same function and same procedure on other system and getting the results in 30 secs....

This is the procedure which was written by other developers. iam thinking to change Let me know your ideas...

Thanks.

Hi,

Can you please explain me clearly what you did?after you done with this problem. It may help me later.

thanks,

sam