Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query parallelism or NOT!!
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00340652
Message ID:
00340732
Views:
22
>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,

Check out MSKB #Q247500

Direct link:

http://support.microsoft.com/support/kb/articles/Q247/5/00.ASP?LNG=ENG&SA=ALLKB&FR=0
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform