April 26, 2005 at 12:55 pm
Hi!
There are some way to indicate from t-sql code wich processor will use an application?
I know that the SQL server administrate the resources (memory and processors) but a friend tell me that its possible to use a processor for a particular application and other for other application, and both applications living on the same database. It is possible that? If yes, how?
I appeciate very much your advice
Thank you
Abraham Pichardo
April 26, 2005 at 1:19 pm
OS administrates system resources and assign the resources to applications like SQL Server which uses and manages the resources assigned to it by OS.
Windows System Resource Manager (WSRM) is available for use with Windows Server 2003, Enterprise Edition and Datacenter Edition. WSRM provides resource management and enables the allocation of resources, including processor and memory resources, among multiple applications based on business priorities.
April 26, 2005 at 4:30 pm
Abraham, are you thinking of configuring SQL Server to only use some processors on a multi-proc box? If so, see affinity mask in Books Online for some information.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply