In Sql Server 7.0, you could tell it to only use 1 processor out of 4 on a server. Can you do the same thing in Sql Server 2005?Yes. This mechanism hasn't changed since 7.0 except the option is dynamic now. See "affinity mask" option in the sp_configure system sp topic in Books Online.
No comments:
Post a Comment