Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow storeproc on SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00935580
Message ID:
00935727
Views:
19
Marc,

Do they have like 100 connections banging the box while you only have one? What do the CPU loads look like?

>Yes, the server is dedicated to SQL only... I think it's enought powerfull. Specs are an IBM X-Series 445, with Quad proc XEON 3 Ghz 4Mo Cache, 8Go RAM, 6HD 15000rpm Raid-5. I was alone connected on the DB with the Query Analyser, directly on the server to make tests.
>
>but I don't understand why many SP are faster than here, and other are slower (it's not logical)
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform