|
Home > Archive > MS SQL Server OLAP > November 2005 > What to do about too many partitions in 2005 Standard ed?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What to do about too many partitions in 2005 Standard ed?
|
|
| Kaisa M. Lindahl 2005-11-28, 11:24 am |
| Today I discovered that in SQL Server 2005 Standard Edition, you can have
maximum 3 Partitions in a cube. Unfortunately, I'm trying to migrate a cube
made for SQL Server 2000 to 2005. On my local developer box, I'm running SQL
Server 2005 Developer edition, and didn't know the partitions would cause a
problem on Standard edition.
The original cube has 4 partitions. When trying to run this cube (copied
from my 2005 developer edition), I get errors saying it can't have more than
3 partitions.
Seems my options are 1) Go for enterprise edition or 2) Redesign the cube.
Are there other options? And are there any tricks for redesigning
partitions?
All help appreciated!
Kaisa M. Lindahl
| |
| Deepak Puri 2005-11-28, 11:24 am |
| Hi Kaisa,
There was a limit on partitions in AS 2000 Standard Edition as well, so
this doesn't seem strictly like a 2000 -> 2005 migration issue. But how
many fact rows are there in the cube, and what dimension is the cube
partitioned by - maybe it can work in AS 2005 withou partitioning.
Another option with AS 2005 Standard Edition is that you can use 64-bit
servers (which will give you more memory).
http://sqljunkies.com/WebLog/mosha/.../2005/3/19.aspx[color=darkred]
Analysis Services 2005 Editions differentiation
...[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
| |
| Peter Kenyon 2005-11-28, 8:25 pm |
|
"Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message
news:eZN2SXD9FHA.4008@TK2MSFTNGP10.phx.gbl...
> Today I discovered that in SQL Server 2005 Standard Edition, you can have
> maximum 3 Partitions in a cube. Unfortunately, I'm trying to migrate a
> cube made for SQL Server 2000 to 2005. On my local developer box, I'm
> running SQL Server 2005 Developer edition, and didn't know the partitions
> would cause a problem on Standard edition.
>
> The original cube has 4 partitions. When trying to run this cube (copied
> from my 2005 developer edition), I get errors saying it can't have more
> than 3 partitions.
>
> Seems my options are 1) Go for enterprise edition or 2) Redesign the cube.
> Are there other options? And are there any tricks for redesigning
> partitions?
You could try writing a union query which combines 2 or more fact tables,
and use that as the data source for one of your partitions.
Peter
| |
| Dave Wickert [MSFT] 2005-11-29, 3:23 am |
| BTW: Partitioning is *not* supported in Standard Edition. Yes, as you've
discovered, you can work around it for one or two partitions, but you will
be blocking yourself with other features. For example, when you do an
incremental process of a partition, what the system does behind your back is
to create a temporary partition, process it and then merge the temporary
partition back to the original partition. That is why we limit it to three
partitions. The built-in functions in AS will not use more than three, so we
limit it there.
So what you will see happening is that if you do implement partitioning with
standard edition, you may start to notice that some features will no longer
work because they use partitioning under the covers and by you implementing
by-hand, the feature may no longer work.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message
news:eZN2SXD9FHA.4008@TK2MSFTNGP10.phx.gbl...
> Today I discovered that in SQL Server 2005 Standard Edition, you can have
> maximum 3 Partitions in a cube. Unfortunately, I'm trying to migrate a
> cube made for SQL Server 2000 to 2005. On my local developer box, I'm
> running SQL Server 2005 Developer edition, and didn't know the partitions
> would cause a problem on Standard edition.
>
> The original cube has 4 partitions. When trying to run this cube (copied
> from my 2005 developer edition), I get errors saying it can't have more
> than 3 partitions.
>
> Seems my options are 1) Go for enterprise edition or 2) Redesign the cube.
> Are there other options? And are there any tricks for redesigning
> partitions?
>
> All help appreciated!
>
> Kaisa M. Lindahl
>
>
| |
| Kaisa M. Lindahl 2005-11-29, 3:23 am |
| Thanks all for replying!
Seems we'll have to rebuild the cube then.
Kaisa M. Lindahl
"Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
news:OxvV4EJ9FHA.740@TK2MSFTNGP11.phx.gbl...
> BTW: Partitioning is *not* supported in Standard Edition. Yes, as you've
> discovered, you can work around it for one or two partitions, but you will
> be blocking yourself with other features. For example, when you do an
> incremental process of a partition, what the system does behind your back
> is to create a temporary partition, process it and then merge the
> temporary partition back to the original partition. That is why we limit
> it to three partitions. The built-in functions in AS will not use more
> than three, so we limit it there.
>
> So what you will see happening is that if you do implement partitioning
> with standard edition, you may start to notice that some features will no
> longer work because they use partitioning under the covers and by you
> implementing by-hand, the feature may no longer work.
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> "Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message
> news:eZN2SXD9FHA.4008@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|
|