Re: VLDB nearing 85% space utilization on underlying drives.
- From: "susiedba@xxxxxxxxxxx" <susiedba@xxxxxxxxxxx>
- Date: 20 Oct 2006 16:06:14 -0700
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
Tomasz Borawski wrote:
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.
"gottaknow" wrote:
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.
"susiedba@xxxxxxxxxxx" wrote:
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
gottaknow wrote:
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?
.
- References:
- Re: VLDB nearing 85% space utilization on underlying drives.
- From: susiedba@xxxxxxxxxxx
- Re: VLDB nearing 85% space utilization on underlying drives.
- Prev by Date: ActiveX InputBox and global variables
- Next by Date: Re: Advice on database volume
- Previous by thread: Re: VLDB nearing 85% space utilization on underlying drives.
- Next by thread: Re: VLDB nearing 85% space utilization on underlying drives.
- Index(es):
Relevant Pages
|
