| John Bell 2006-10-24, 6:33 pm |
| Hi Don
This is not really possible, the server will allocate resource as necessary,
you may get more even distibution with two instances of SQL server, but there
would be some reduction of resource to each instance and a reduction in the
maximum possible allocation for each instance.
If this is a poorly written query or database design it may be that it will
not improve even if additional resource is allocated to it, therefore
identifying what is using the resource and where the bottlenecks are is
important, and re-engineering inefficient queries processes (e.g. processing
incrementally rather than in one large go) could help.
Also check for hardware resource and possible bottlenecks.
John
"Don" wrote:
> Two of my clients have their databases setup on one of my Servers ( SQL
> Server 2005). I.e. both Databases are sitting on the one SQL Server.
>
> Queries executed by Client A takes a very long time and hence effects the
> performance for the queries performed by Client B (simply becuase Client A is
> using a lot of the SQL Server resources).
>
> Is it possible to configure SQL Server so that the Databases for Client A
> and Clietn B share the resources of SQL Server equally?
> I.e. the query processing done by Client A should not effect the SQL Server
> (in turn not effect Client B's queries)
>
>
|