Hello,
In SQL Server 2005 Enterprise, I can change the CPU affinity via
Management Studio. Is there a way that I can change these settings via
t-sql?
I wish to use all my cpu's at night when my data warehouse builds and
then durning the day reduce the number of cpus for SQL so that the
application can get more time.
TIA
Rob

See the system procedure sp_configure in SQL Server Books Online.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9f38eba6-39b1-4f1d-ba24-ee4f7e2bc969.htm

--
Anith

Let us know if this helps at all. I would think (though I really don't
know) that you are changing something more like a "niceness" or
priority than anything else. That is, if the server is more idle at
night anyway, then the db can have all the resources it wants, without
specifically requesting it. If this is accurate, I would expect that
changing the cpu settings would have little effect.

Like I said, though, I'm not familiar with this setting.

Thanks,
Michael

On Nov 7, 9:16 am, "rcamarda" <robc... (AT) hotmail (DOT) com> wrote: