SQL Queries running differently on Dual Processor Server
From: Ted Bogucki (ted_at_sma-promail.com)
Date: 10/19/04
- Next message: Aaron [SQL Server MVP]: "Re: UDF to obfuscate strings?"
- Previous message: Scott Elgram: "Re: DB Backup problem"
- Next in thread: Aaron [SQL Server MVP]: "Re: SQL Queries running differently on Dual Processor Server"
- Reply: Aaron [SQL Server MVP]: "Re: SQL Queries running differently on Dual Processor Server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 14:32:40 -0400
I have SQL commands that work differently on a single processor sql server
from a dual processor SQL server.
Does anyone know why?
The same SQL command will run many times faster on the single processor
server then it will run on the dual processor server. One command ran in
3 seconds on the single processor server when the Dual processor server took
1 minute. The SQL command had several left outer joins. I re-arranged
the sql statement and changing one of the left outer joins to an inner join
and the SQL statement worked on both the single and dual processor servers
at the same speed. The statements were run against the exact same
database on each server.
- Next message: Aaron [SQL Server MVP]: "Re: UDF to obfuscate strings?"
- Previous message: Scott Elgram: "Re: DB Backup problem"
- Next in thread: Aaron [SQL Server MVP]: "Re: SQL Queries running differently on Dual Processor Server"
- Reply: Aaron [SQL Server MVP]: "Re: SQL Queries running differently on Dual Processor Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
