Select that runs out of disk space.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Select that runs out of disk space.

Select that runs out of disk space.

Rate Topic

Display Mode

Topic Options

Author

Message

alfredoapereira

Posted Thursday, May 13, 2010 12:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 18, 2013 2:11 AM
Points: 7, Visits: 36

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.

Post #921554

noeld

Posted Thursday, May 13, 2010 12:33 PM

SSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260, Visits: 1,977

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

* Noel

Post #921556

Dan.Humphries

Posted Thursday, May 13, 2010 12:45 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, November 15, 2012 8:38 AM
Points: 802, Visits: 1,169

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.

Post #921565

Eric M Russell

Posted Thursday, May 13, 2010 1:17 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 1,164, Visits: 3,340

- 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

"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47

Post #921589

« Prev Topic | Next Topic »

Permissions