| Author |
VLDB nearing 85% space utilization on underlying drives.
|
|
| gottaknow 2006-10-25, 6:00 am |
| 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?
| |
| susiedba@hotmail.com 2006-10-25, 6:00 am |
| 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?
| |
| gottaknow 2006-10-25, 6:00 am |
| 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@hotmail.com" 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:
>
>
| |
| Tomasz Borawski 2006-10-25, 6:01 am |
| 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:
[color=darkred]
> 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@hotmail.com" wrote:
>
| |
| susiedba@hotmail.com 2006-10-25, 6:01 am |
| 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:[color=darkred
]
> 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:
>
| |
| Tomasz Borawski 2006-10-25, 6:01 am |
| Can you send me the link (KB)?
"susiedba@hotmail.com" wrote:
> 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:
>
>
|
|
|
|