SQL Server Performance

2005 Express CPU wont exceed 50%

Discussion in 'SQL Server 2005 General DBA Questions' started by Peter Edmondson, Nov 4, 2011.

  1. Peter Edmondson New Member

    Does SQL server 2005 Express restrict CPU usage for sqlsrvr.exe?

    We have a Staff clocking system (timeware) running on SQL server 2005 Express. The server gets pushed when doing recalculations but the CPU usage for sqlsrvr.exe wont exceed 50% despite the rest of the CPU sitting idle. Is the server process restricted by a quota?
    Peter Edmondson, Nov 4, 2011
    #1

  2. Luis Martin Moderator

    Luis Martin, Nov 4, 2011
    #2

  3. Peter Edmondson New Member

    Thats gota be whats causing it. Its got 2 and each is working 50%
    Peter Edmondson, Nov 4, 2011
    #3

Share This Page