Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query parallelism or Not!!!
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Query parallelism or Not!!!
Miscellaneous
Thread ID:
00340568
Message ID:
00340568
Views:
58
I have a machine in our office Win Nt SP4 with Sql server 7.0.
Single Processor

Clients Site
Server with dual processors.

I have a Query that takes 7 minuts at my office but the same query takes 51 minutes at clients end.

Under the execution plan it shows the server using parallelism and at my office it doesn't use parallelism.

should i increase the time to the maximum for parallelism for this one stored procedure and then chnage it back to the default at the end of procedure...

or can any one help with making it run faster.

TIA
Shawn
Shawn Dorion
Geo Sektor Dot Com
Website: http://www.geosektor.com

Web Hosting Plans
Visit : http://WebHosting.Applications4u.com/
Next
Reply
Map
View

Click here to load this message in the networking platform