 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Data Warehousing / October 2006VLDB nearing 85% space utilization on underlying drives.
I need help tracking down some information regarding SQL Server 2000. I have a VLDB that is at approixmately 85% space utilization on all of its drives. Is there a recommended threshold where not enough free space is available for SQL Server to maintain it's performance levels? yeah just about 80% how much space you got? i think that you should stick it on IDE / SATA drives and then use SQL Server Analysis Services to get the data out. Anything else is cost prohibitive -Susie > I need help tracking down some information regarding SQL Server 2000. I have > a VLDB that is at approixmately 85% space utilization on all of its drives. > Is there a recommended threshold where not enough free space is available for > SQL Server to maintain it's performance levels? We are a one terabyte DW which uses BO to retrieve the data for customer queries. The use of BO tool is imposed by the customer. We are currently at 83% disk utilization with about 50 gigs left before we cross 85% utilization. So far we have not seen any performance degradation. We are monitoring currently and will do a baseline test for about 3 days next week. We are hoping this gives us a better indication of when we may be getting closer to hitting the wall. > yeah just about 80% > [quoted text clipped - 10 lines] > > Is there a recommended threshold where not enough free space is available for > > SQL Server to maintain it's performance levels? There is no relation between percentage of space utilization and database performance. However there is a relation between how much data are accessed and database performance. > We are a one terabyte DW which uses BO to retrieve the data for customer > queries. The use of BO tool is imposed by the customer. We are currently at [quoted text clipped - 18 lines] > > > Is there a recommended threshold where not enough free space is available for > > > SQL Server to maintain it's performance levels? I disagree with you; I have seen Microsoft knowledge base articles that claim that you should NEVER go under 15% for both performance and longevity reasons -Susie > There is no relation between percentage of space utilization and database > performance. However there is a relation between how much data are accessed [quoted text clipped - 22 lines] > > > > Is there a recommended threshold where not enough free space is available for > > > > SQL Server to maintain it's performance levels? Can you send me the link (KB)? > I disagree with you; I have seen Microsoft knowledge base articles that > claim that you should NEVER go under 15% for both performance and [quoted text clipped - 28 lines] > > > > > Is there a recommended threshold where not enough free space is available for > > > > > SQL Server to maintain it's performance levels? I dont have it but it's fact I'll look for it.. sorry -Aaron > Can you send me the link (KB)? > [quoted text clipped - 30 lines] > > > > > > Is there a recommended threshold where not enough free space is available for > > > > > > SQL Server to maintain it's performance levels? I dont have it but it's fact I'll look for it.. sorry -Susie > Can you send me the link (KB)? > [quoted text clipped - 30 lines] > > > > > > Is there a recommended threshold where not enough free space is available for > > > > > > SQL Server to maintain it's performance levels? I dont have it but it's fact I'll look for it.. sorry -Aaron > Can you send me the link (KB)? > [quoted text clipped - 30 lines] > > > > > > Is there a recommended threshold where not enough free space is available for > > > > > > SQL Server to maintain it's performance levels? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.