Re: Use all available processors ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I may have my wires crossed, MAXDOP and processor affinity are not the same
thing.

I believe MAXDOP is telling queries to only use x processors, but it does
not say which and differnt queries can use different ones.

The MCDBA study materials actually point out that on certain systems (more
than 4 cpus, more functions than SQL Server), you might want to NOT use
processor 0 (I/O requests go here), or the last CPUS (NIC requests go
through these...one per nic). This may or may not be relevant to Win2K3 or
SQL 2005

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"Manoj Kumar" <ManojKumar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05E814D8-454E-4F61-A36D-E60DFD29BCAE@xxxxxxxxxxxxxxxx
Thanks for the reply.

I notice that the processor utilization is almost uniform[across all 4
processors, via Perfmon and Task manager] even though the "max degree of
parallelism", "config_value and run_value are set to "1".

All of the available processors are selected in the "Processor" tab. It
appears that this overrides the "max degree of parallelism" values and
uses
all of the available processors.


--
Manoj Kumar


"Linchi Shea" wrote:

We always use all the processors. No issues there whatsoever.

Linchi

"Manoj Kumar" wrote:

Hi There,

Any known issues in using all available processors in the DB server?
[SQL
2000 Enterprize+sp4]

Right now it is configured to use just 1 processor.

TIA

--
Manoj Kumar


.

Relevant Pages

  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server 2000 and Latching problem
    ... While the way we indexed our tables and the way we wrote the queries etc ... "chances are you are getting latches because you are ... query on the results the query .. ... SQL Server 2000 and Latching problem ...
    (microsoft.public.sqlserver.connect)
  • Re: Sql server as back end
    ... There is an option in the Tools menu, Database Utilities, for Upsize to SQL Server. ... But after that, the queries should generally work, shouldn't they? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Server (?) performance issues
    ... it's usually that those queries are being blocked by something else. ... Columnist, SQL Server Professional ... exact counters are being watched, but we are being told that all the ... all is fine and there is plenty of spare capacity. ...
    (microsoft.public.sqlserver.server)