Re: Database partitioning - licensing issues

<jatin.grover@xxxxxxxxx> wrote in message
news:1142886787.823146.99620@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi:

We're a small company and have SQL Server 2005 EE regularly crunch 100
Gigs of data. We plan to spread this load on multiple servers, using
table partitioning, a feature SQL Server 2005 EE provides, to speeden
the process up. But to do this, is it possible to have a master SQL
Server 2005 EE controller on one PC, and standard editions, or some SQL
Server EE stubs, on other servers to get the table partitioning to
work. This would save us tremendous costs on licensing, as Standard
Editions cost 1/5th than EEs, and having 5 EE per processor licenses
maybe too prohibitive for us.

Any other cheaper solution will be highly appreciated.

Thanks,
Jatin


I'm not sure what you are referring to here. Table partitioning won't help
you spread the load across multiple servers. The purpose of a partition
scheme is to partition a table across multiple file groups. All file groups
have to exist on the same server.

Maybe you mean replication. All Editions of SQL Server support some form of
replication. See:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

You haven't given much information about your actual problem apart from
"regularly crunch 100Gigs". 100GB isn't exceptional these days and even a
database 100 times that size shouldn't be any problem to implement on a
single server (with suitable hardware of course). I suppose it depends what
you mean by "regularly". 100GB per day isn't too much trouble. 100GB per
minute is a slightly bigger problem - but again the right hardware is more
important than how many server boxes you throw at it.

Hope this helps.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--


.

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)