Re: Processor usage



To get more CPU usage, use the Parallel Process Utility (PPU) at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=a2eef773-6df7-4688-8211-e02cf13cbdb4&DisplayLang=en

On a 4X you should be able to do 3 or 4 requests in parallel.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Nigel Pendse" <nigelp.nospam@xxxxxxxxxxxxxx> wrote in message
news:%23AuXYpAWFHA.1200@xxxxxxxxxxxxxxxxxxxxxxx
>I suspect you may have hyper-threading turned on, so it looks like a quad
>box. In that case, exactly 25% equates to 100% of one virtual processor.
>
> "Joppe" <No@xxxxxxxxxx> wrote in message
> news:OomOMUgVFHA.2984@xxxxxxxxxxxxxxxxxxxx
>> Hi!
>>
>> I have an OLAP server running on a DLL 2850 2 proc 3,0 GHZ.
>>
>> When I use OLAP for statistics it only uses 25% (EXACTLY) of the
>> processor. If I start 2 it uses 50% (EXACTLY) and so on. Is there any
>> way of letting OLAP use as much as it want or set a fixed value
>> somewhere?
>> Setup:
>> Win 2K, SQL Std 2K
>>
>> REG
>>
>> Jörgen Persson
>
>


.



Relevant Pages

  • Re: ANNOUNCEMENT: 3 SQLServer security tools and download site
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >>>> SQL Scan: ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Accelerator for Business Intelligence
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Anyone know how can I obtain "SQL Server Accelerator for Business Intelligence"? ...
    (microsoft.public.sqlserver.olap)
  • RE: WinXP authentication fails after an hour
    ... Typically this is the result of an Active Directory issue but you may be ... Connect to SQL using Named Pipes rather than TCP/IP. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.clients)
  • RE: SQL server connection lost on win2003
    ... What version of SQL are you running? ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windows.server.setup)
  • Re: ADO to ADO.NET 2.0
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... It walks through the issues faced by developers with the same ... SQL Express is far more mature (it's based on the SQL Server binaries ... ADO.NET datasets is better than binding to joined tables for updates. ...
    (microsoft.public.dotnet.framework.adonet)