SQL Server Performance

Error on Index Creation

Discussion in 'General DBA Questions' started by alimmia, Mar 17, 2006.

  1. alimmia New Member

    Hello,<br />I was trying to create 14 indexes on a table that has around 80 millions records. But got the following error message:<br /><br />Name: I/O error detected <br />Description: Error: 823, Severity: 24, State: 2<br />I/O error 1450(Insufficient system resources exist to complete the requested service.) detected during read at offset <br /><br />Please give me some hints for the index creation [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br />Thanks,<br />Alim
  2. satya Moderator

  3. alimmia New Member

  4. alimmia New Member

    To resolve the issue, I think I need to run one index at a time since they are large. <br /><br />If I submit all 15 index at the same time, SQL server will try to run all 15 indexes in parallel. Is the concept correct?<br /><br />Thanks[<img src='/community/emoticons/emotion-1.gif' alt=':)' />],<br />Alim
  5. Twan New Member

    Hi ya,

    If you submit them all in one sql script then they would be created one at a time, but could be within one transaction if you don't have any go statements in between them,

    If you submit them from multiple scripts then they are likely to block each other at row or page level locks, I'd suspect

    If you want to create a clustered index, then it is wise to create that before you create any non-clustered indexes...

    Cheers
    Twan
  6. alimmia New Member

    Thanks[<img src='/community/emoticons/emotion-1.gif' alt=':)' />].

Share This Page