Dear Parabu,

Thank you for your details.

Your tips are a useful one.

Regards

Mathew

Hi,

Thanks.. Performance improved by 6 second

Before it was 36, now it took only 30 second

Please see the attached file, new execution plan

Regards

Mathew

Hi,

Please see the attached file,

1. execution plan of slow running query in query in production server ( 36 second)

2. execution plan of same query in query in test server...

Yes the query is slow...

hi,

One more thing...

Test PC and server execution plan icons are almost same. But in the row count and No of execution have big differance.Some sql take 1 second in...

Can you please explain, how to do the...

Hi All,

Thanks for your support.

my DB version : SQL : Microsoft SQL Server 2000 - 8.00.2249 (Intel X86)

Device manager processor shows 24 processers.

So can i change the Max Degree...

cfradenburg (6/6/2012)

---

Have you checked for blocking? The issue could be due to concurrency.

Is there anything else running on the server? You could be hitting memory or CPU constraints...

Lowell (6/6/2012)

---

did you rebuild the indexes or update statistics on the new server yet?

Yes.. I did re-index and update statistics with fullscan to all the tables.

Pls note: i...

Hi,

Please see the following details , execution plan of one of the slow sql stmts.

Dear Lowel,

My version is sql server 2000 ENT.edit and i did the following

1.Re-index all tables

2. Update statistics with Full scan.

After that performance are increased.

But still some sql statement working...

Dear All,

Thanks you for all your support and help. I schedule the update statistics with Full scan and now system is working fine.

DB- Auot update the statistics was disabled. Now...

Hi,

I tryed to save as "execution plan", but it is not working in sql server 2000 version.

Regards

mathew

Dear Daxesh Patel,

You are correct. If i run "update statistics table " and check DBCC SHOW_STATISTICS, Row sampled is only 20% of actual rows.

If database "auto update statiscs" enabled,...

Dear

please see the following picture, execution plan ..I am not sure, how to upload full execution plan to this forum.