Difference between revisions of "Editions - MS SQL"

From Hostek.com Wiki
Jump to: navigation, search
m (Briana moved page MS SQL to Editions - MS SQL)
(→‎MS SQL Databases)
Line 1: Line 1:
 
=== MS SQL Databases ===
 
=== MS SQL Databases ===
  
−
==== What Version of MS SQL should be used? ====
+
===Shared Hosting Considerations===
−
MS SQL Express can be used in most cases. However, there are a couple of limits to be aware of related to the Express edition.
+
Microsoft SQL Server Web edition is used for serving our customers shared accounts. We also offer MyLittleAdmin and MyLittleBackup to our shared customers through the WCP.
  
−
The Express edition can handle databases up to 4 GB in size.  If you need a database larger than 4 GB you will need the Web Edition of MS SQL Server.
+
===VPS Hosting Considerations===
−
 
+
For access to MyLittleAdmin and MyLittleBackup for VPS customers additional licensing is required, please contact support.
−
The Express edition can only utilize up to 1 GB Ram.  If you have a busy database or will have several databases with normal traffic, you will notice a performance improvement with more than 1 GB Ram, in which case you would want the Web Edition.
+
  
 +
====Express Edition Limitations====
 +
*Max Database size 4 GB in size
 +
*Full-text indexing is not installed by default, request should be made to support for installing with full-text indexing.
 +
*Max RAM utilization 1 GB Ram, for supporting a busy database or several databases with normal usage we recommend the Web edition with available RAM over 1GB.
  
 +
====Web Edition Limitations====
 +
*Full-text indexing is not installed by default, request should be made to support for installing with full-text indexing.
 +
*Cannot be a Publisher for SQL Replication, for supporting SQL Replication and publishing we recommend the Standard Edition
  
  
 
[[Category:Databases-MSSQL]]
 
[[Category:Databases-MSSQL]]
 +
[[Category:Databases-VPS]]

Revision as of 19:25, 9 July 2012

MS SQL Databases

Shared Hosting Considerations

Microsoft SQL Server Web edition is used for serving our customers shared accounts. We also offer MyLittleAdmin and MyLittleBackup to our shared customers through the WCP.

VPS Hosting Considerations

For access to MyLittleAdmin and MyLittleBackup for VPS customers additional licensing is required, please contact support.

Express Edition Limitations

  • Max Database size 4 GB in size
  • Full-text indexing is not installed by default, request should be made to support for installing with full-text indexing.
  • Max RAM utilization 1 GB Ram, for supporting a busy database or several databases with normal usage we recommend the Web edition with available RAM over 1GB.

Web Edition Limitations

  • Full-text indexing is not installed by default, request should be made to support for installing with full-text indexing.
  • Cannot be a Publisher for SQL Replication, for supporting SQL Replication and publishing we recommend the Standard Edition
Retrieved from "https://wiki.hostek.com/index.php?title=Editions_-_MS_SQL&oldid=433"