Re: SQL2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The box has 8 processers and I would like to assigin # of Proc to each DB
can I do that?

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:%23prt4%23$vHHA.4592@xxxxxxxxxxxxxxxxxxxxxxx
What do you mean by processes?

--
Andrew J. Kelly SQL MVP

<msnews.microsoft.com> wrote in message
news:OSc0r0$vHHA.736@xxxxxxxxxxxxxxxxxxxxxxx
Is there a setting somewhere that tells SQL how many processes to provide
to each database?






.

Relevant Pages

  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: disk I/O tool
    ... Andrew J. Kelly SQL MVP ... "Jay" wrote in message ... I guess he really doesn't understand SAN's very well either because SAN's are notoriously slow for writing small but frequent I/O's and direct attached drives will often outperform them hands down. ...
    (microsoft.public.sqlserver.server)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Procedure execution problem - Clients performances
    ... Again check the parameters and plan with a trace. ... Andrew J. Kelly SQL MVP ... Dim conn As New SqlConnection ...
    (microsoft.public.sqlserver.clients)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the ... Server already restarted several times (MSSQLSERVER, ...
    (microsoft.public.sqlserver.clients)