469,632 Members | 1,666 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

Regarding to MS SQL Processing speed


I have a database and a query both 100% (with specific index) identical and install and run in my laptop and server but resulting slightly different time frame to complete.

Run a query in my laptop 1GB RAM, INTEL 1.66GHz Core 2 took me 1 minute 38 seconds.

Run the same query in server 4GB RAM, ZEON 3.0GHz took me 1 minute 36 seconds.

Both using MS SQL 2000, windows server 2003.

The different is my laptop took around 50-60% of cpu resource to process the query but server only took 10-12% to process the same query.

My question is do mssql have a maximum process speed? Can this be increase? for example to let the server took more resource to process on order to produce better speed.

Jul 13 '07 #1
0 1025

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Alexander Muylaert | last post: by
reply views Thread by Claire | last post: by
5 posts views Thread by Joe Reazor | last post: by
77 posts views Thread by M.B | last post: by
4 posts views Thread by Alexis Gallagher | last post: by
reply views Thread by K.S.Sreeram | last post: by
10 posts views Thread by Enrique Cruiz | last post: by
2 posts views Thread by vectorizor | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.