dedicated CPU for a certain task.

Question

dedicated CPU for a certain task.

tvu4251

Mr or Mrs. 500

Points: 560
More actions
August 14, 2007 at 3:57 pm

#73352

Dear SQL gurus,
IS there a way to assign a CPU to specifically run a heavy duty task (such as a job, or a procedure....)?
Thank you.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

By short the answer should be NO.

There's no posibility to assign certain tasks to a dedicated CPU. The one exception I know about is if your running SQL Server Enterprise on a Windows 2000 or 2003 Datacenter Edition. There you have options to assign certai processes to a specific CPU. But since I dont have any machines with Datacenter on it, I can't give you the details.

Markus

[font="Verdana"]Markus Bohse[/font]

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Some of this changes in SQL Server 2008 with resource governers that can limit work in other areas, but I don't think you can specify affinity for a specific process within SQL Server.

Markus,

I wasn't aware that you could specify certain processes to specific CPUs inside SQL Server. Do you have a reference for that?

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

Sorry Steve,

but i don't have a reference for this. Some time ago I visited a session at Unisiys where they did some benchmark test on a ES7000 with Datacentr installed. They told me that it was possible to assign certain processes to specific CPU's even inside SQL server.

But since none o my customers uses Datacenter I never tried it in real live and forgot the details.

Markus

[font="Verdana"]Markus Bohse[/font]

philcart SSC-Forever Points: 47794 More actions · Answer 4

Markus, I recall something along those lines as well. From memory, it was something like allocating specific threads to a cpu, but I think this was after the thread had begun executing and was managed outside of SQL.

--------------------
Colt 45 - the original point and click interface

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

Thanks and I'll have to look around. AFAIK you can't manage processes inside SQL Server (yet). The resource governer is SS2K8 is very exciting for me. I've been asking for something like this since I saw it in IIS.