How can I use more than one processor for SQL-Server

[Hubert Endl]

I am having a powerfull Server (DELL - PowerEdge 6100/200) with 4 processors, 1 GB Ram, 6 Discs a 9 GB.

But the SQL-Server runs only on 1 processor. That means when I look at the Windows NT Task Manager it shows only 25 % used.

Can anybody give me a hint or and has anybody an idea how to modify the SQL-Server or the DELL-Server to use all 4 processors.

thank you Hubert

[Jim]

On 1/1/99 11:40:03 AM, Hubert Endl wrote:
> I am having a powerfull Server (DELL - PowerEdge 6100/200) with 4
> processors, 1 GB Ram, 6 Discs a 9 GB.

But the SQL-Server runs only on 1
> processor. That means when I look at the Windows NT Task Manager it shows
> only 25 % used.

Can anybody give me a hint or and has anybody an idea
> how to modify the SQL-Server or the DELL-Server to use all 4
> processors.

thank you Hubert

Check out the following items that fall under sp_configure (or you can use the Enterprise Manager).

SMP Concurrency ... -1 ... tells MS SQL to use all available CPU's

Also if the server is a dedicated MS SQL Server, look at tuning it away from
Windows NT towards MS SQL Server.