Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 2005 cluster on VMWARE
- Thread starter holdahl
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
What would be the point? If you have a single VMWare host then you simply have two OSs on the same piece of hardware.
If you have more than one host just use the buildin DR and HA solutions to move the database server from one host to another.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
If you have more than one host just use the buildin DR and HA solutions to move the database server from one host to another.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Thread starter
- #3
mrdenny
Programmer
- May 27, 2002
- 11,595
The only additional load that a Windows cluster has over a single host is the heartbeat which is minimal at most.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Thread starter
- #5
Thanks for the information....
We are planning to install a SQL Cluster on vmware for our sharepoint 3.0 solution.
Any recommendations on how much resources should be used for this cluster? CPU, RAM and disk... Where is the database file placed when having the cluster on vmware?
-holdahl-
We are planning to install a SQL Cluster on vmware for our sharepoint 3.0 solution.
Any recommendations on how much resources should be used for this cluster? CPU, RAM and disk... Where is the database file placed when having the cluster on vmware?
-holdahl-
mrdenny
Programmer
- May 27, 2002
- 11,595
Sizing a virtual SQL Server is just like sizing a physical SQL Server.
The CPU and RAM requirements will be dictated by how large the database will be. If it's a small database then a Gig or two should be fine. If your sharepoint database will be larger then you will need several Gigs for SQL Server.
The same goes for disks. The busier the sharepoint site will be the higher end and larger the disks will need to be. Data files, logs and tempdb should be split between physical devices just like if it was a physical cluster.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
The CPU and RAM requirements will be dictated by how large the database will be. If it's a small database then a Gig or two should be fine. If your sharepoint database will be larger then you will need several Gigs for SQL Server.
The same goes for disks. The busier the sharepoint site will be the higher end and larger the disks will need to be. Data files, logs and tempdb should be split between physical devices just like if it was a physical cluster.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question