Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Low Disk Problem

Author  Topic 

Sharon_Jean
Starting Member

4 Posts

Posted - 2009-06-26 : 15:32:42
I have created a View in SQL Server 2005 when I execute the View I am receiving a message "Low Disk Space". Which is the C drive - 12GB only 1.35GB available prior to running the View. The C Drive only has the OS all databases including the tempdb is on another drive with 190GB available. The swap file is on the C drive and may be the problem. Can the swap file be directed to a different drive without any consquences? If anyone has any recommendations for other possible causes I would be eager to hear. I am an extreme newbie to SQL and learning by trial & error.
Thanks in advance,
-S

jrsansom
Starting Member

4 Posts

Posted - 2009-06-28 : 15:58:10
Hi Sharon,

Is the query you run against the view returning all data and if so how much data is being returned?

You can indeed place the Windows pagefile on another drive or have multiple pagefiles setup, it is actually quite a common practice on production servers. You may find the following article interesting reading:

http://www.windowsnetworking.com/kbase/WindowsTips/Windows2003/AdminTips/Miscellaneous/EnhancePerformancebyMovingthePagefile.html



John Sansom | www.johnsansom.com |
Go to Top of Page
   

- Advertisement -