Post reply

Select that runs out of disk space.

  • May 13, 2010 at 12:30 pm

    #218903

    Hi,

    I have a server with 2 disks: 68Gb (C:) with OS and applications and 205Gb (D:) for data bases.

    I install a SQL Server 2008 in a 68Gb disk and the data bases are in the 205Gb disk.

    When I run a SP with a query to select data from several related tables, the space from disk C is running out fast.

    How can I prevent this? How can I configure my SQL Server 2008 to use the disk space from drive D:?

    Thnx.

  • May 13, 2010 at 12:33 pm

    #1167133

    looks like your log drive and your tempdb drive are on C


    * Noel

  • May 13, 2010 at 12:45 pm

    #1167141

    move your Tempdb to the d: drive. there are several articles on-line on how to move you tempdb.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • May 13, 2010 at 1:17 pm

    #1167163

    - You said that drive C: is 68 GB, but how much disk space was free before running the stored procedure?

    - Have you used Sysinternals FileMon or Process Monitor to log disk i/o events and determine which file(s) are growing?

    - Does the stored procedure contain just select statement, or it is also inserting or updating as well?

    - Is the stored procedure selecting into a temporary table or table variable?

    When installing SQL Server, by default, the master and tempdb databases are located on the same drive as the application.

    For example:

    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

    Also read this article: Troubleshooting Insufficient Disk Space in tempdb

    http://msdn.microsoft.com/en-us/library/ms176029.aspx

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply