SQL Server Performance

C Drive out of Space

Discussion in 'General DBA Questions' started by rohit2900, Oct 3, 2009.

  1. rohit2900 Member

    Hi,
    C Drive in one of our prod db server running on SQL Server 2000 EE on Win Server 2003 EE SP2 is fill up aroung 95%. When I tried to move some of the big files to other drives. I found that below folder
    C:Documents and SettingsAll UsersApplication DataMicrosoftSearchDataApplicationsWindows
    is more than 7.5 GB. and by doing some google I found that its beacuse of indexing option is enable.
    Now my question is.
    1. If I disable the indexing option will this folder size will be reduced?
    2. What will the impact of disabling this option on a dedicated production box?
    An help will be greatly appreciated.
    Thanks,
    rohit2900, Oct 3, 2009
    #2

  2. Luis Martin Moderator

    1) Not sure but I suppose you can delete it after disable.
    2) In my opinion, none.
    Luis Martin, Oct 4, 2009
    #3

  3. Adriaan New Member

    If it is connected to the Indexing Service, then by all means switch it off. Indexing at the disk level is only relevant for Word documents etc.
    On a database server, you wouldn't (shouldn't) be storing those types of documents, plus Indexing Service is usually bad for performance due to its impact on read/write operations against database files.
    Adriaan, Oct 5, 2009
    #4

Share This Page