July 21, 2005 at 8:40 am
We have a 4 processors servers & SQL SERVER ED 2000 & W2003 server.
Sometimes I see that one processor is full used.
Questions :
- SQLSRVR.EXE contains with tasks ? (indexing, full text indexing, )...
- this process use multi processors ?
- HAve to manage the using of processors by sqlserver ? (anywhere else than sql server properties / processors)
thanks
Tom
July 21, 2005 at 9:10 am
Assuming you've not assigned SQL Server to use specific processors, SQL Server will use multiple processors as the need arises. If the cost to manage the process using multiple processors is more than the performance gain for a given query, it won't. Also, Full Text Indexing is the Microsoft Search (mssearch.exe) service which SQL Server interfaces with.
Normally you don't have to manage to processor utilization by SQL Server. Are you running into performance issues and that's why you're asking the question?
K. Brian Kelley
@kbriankelley
July 21, 2005 at 9:27 am
Some collegues informs me about this point and users about prb of performances.
But the latch wait time , lock wait are good, network for the server too and transaction pretty low. I think it a network prob and not a DB prb.
so the question is more for more for me !
Tom
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply