The answer is yes. This is an exercpt from a white paper on parallel queries
on multiple processors.
Factors Affecting Parallelism
The automatic decision whether to employ parallel query processing in SQL
Server 7.0 depends on the answers to these questions:
Is SQL Server running on a computer with more than one processor (an
SMP machine)? Only computers with more than one
processor can take advantage of parallel queries.
Are you running SQL Server 7.0 desktop, standard, or enterprise
edition? SQL Server desktop edition can support up
to two processors, standard edition can support up to four
processors, and enterprise edition can support up to
eight processors.
What is the number of concurrent users active on SQL Server?
SQL Server monitors CPU usage and adjusts the degree of
parallelism at query startup time. Lower degrees of parallelism
are chosen if the CPUs are busy.
Is there sufficient memory available for parallel query execution? Each
query requires a certain amount of memory to execute.
Parallel queries require more memory than nonparallel queries. The
amount of memory required for executing a parallel
query increases with the degree of parallelism. If the memory
requirement of the parallel plan for a given degree of
parallelism cannot be satisfied, SQL Server automatically
decreases the degree of parallelism or completely abandons the
parallel plan for the query in the given workload context and
executes the serial plan.
This is the link to the paper.
http://www.microsoft.com/sql/techinfo/query.htm
-----Original Message-----
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 7:13 PM
To: CF-Talk
Subject: OT SQl7 and multi Proc
Cannot seem to find this answer anywhere....Does MSSQL7 Standard support
multi processors?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
