Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Partitioning & SQL Server Partitioning Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 5:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 3:30 AM
Points: 3, Visits: 30
Just wanted to clarify if these 2 are treated the same in terms of licensing.

SQL Server Standard Edition does not include partitioning and enterprise edition does.

Is that to say the partitioning facility in SSAS is not available on the standard edition ?

I have always worked in enterprise environments and my understanding was that the partitioning facility in SSAS was dependent on you being licensed to have partitioning on SQL Server.

Therefore if you were a standard edition user you couldn't use the partitioning facility in SSAS standard edition.
Post #1386867
Posted Tuesday, November 20, 2012 6:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 10:54 AM
Points: 1,163, Visits: 1,184
imran 60091 (11/20/2012)
Just wanted to clarify if these 2 are treated the same in terms of licensing.

SQL Server Standard Edition does not include partitioning and enterprise edition does.

Is that to say the partitioning facility in SSAS is not available on the standard edition ?

I have always worked in enterprise environments and my understanding was that the partitioning facility in SSAS was dependent on you being licensed to have partitioning on SQL Server.

Therefore if you were a standard edition user you couldn't use the partitioning facility in SSAS standard edition.

You can have a limited number (3?) of partitions in SSAS using Standard edition; but you cannot process these in parallel. Most everything says you cannot have SSAS partitions with Standard edition -- but this isn't the case.

Rob
Post #1386886
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse