Problem on parallelism

after running query at first time working all processes

but later 2-3 sec. working only one

SQL 2005

Hewlett Packard DL580 (16 processes)

What is ideas?

Hi Vladmir,

Could you please expand on what you are trying to do and what you are experiencing?

thanks

Jag

|||It's possible that you're seeing the initial disk reads for the query being done in parallel, and then the remainder of the execution carrying on in a single thread, but that's about the best guess I can give from the current information. Not all queries will be executed in multiple parallel threads - there are certain criteria and requirements used by the query optimizer to decide on a degree of parallelism.|||

Thanks for replies!

I have a bank's system (Diasoft 5NT)

It works with SQL Server 2005 (64 bit version). If I run stored procedure in QA - OK! All processes work.

It executing on multiple EC (executing context)

But if I run in programm (Diasoft 5NT) - after few second work only one thread.

P.S. Connect to database over BDE (Borland Database Engine).

|||

davidbrit2 wrote:

It's possible that you're seeing the initial disk reads for the query being done in parallel, and then the remainder of the execution carrying on in a single thread, but that's about the best guess I can give from the current information. Not all queries will be executed in multiple parallel threads - there are certain criteria and requirements used by the query optimizer to decide on a degree of parallelism.

Yes! I think.

But the same query in one case are executing in multiple parallel threads , in other case in single.

|||

Thanks for all!

This problem have been resolved when I turn on "Auto Create Statistic" and "Auto Update Statistic"!

This option had been turned off because we planning run update statistic at night time.