| Author |
Topic |
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
 Posted - 2007-09-26 : 07:12:57
|
| I understand that we can have failover clustering for analysis services and dabase engine in SQL 2K5 . I also understand that in such failover clustering I can configure both on different nodes so that my OLTP and OLAP applications run technically on different nodes thus providing some sort of load balancing .Please confirm if my understanding is right or not . |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-26 : 14:10:14
|
| yes--------------------keeping it simple... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-26 : 22:56:05
|
| Each of them needs own disk resources. |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-09-28 : 00:49:53
|
| Thanks both of u for the help . I have another set of questions related this .I am planning to have 2 quad-core 2.66 Ghz CPU with 8 GB RAM to run an OLTP application for 125 concurrent users which can go upto 250 in 3 years time with a Failover clustering on Win2k3 enterprise edition and SQL2k5 standard edition.1. How many CPU SQL license will i require .2. Does sizing look familiar to what some of u may have with an OLTP / ERP . I already have sizing guide from OLTP vendor . But still some sort of confirmation is good to have from others .3. Will the licensing requirement be different if I use the database engine and analysi server in same machine in FOC .4. Is there a way I can attach only 1 CPU for database and buy only 1 CPU (quad core ) license . Are there any multiplication factors for quad cores . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 01:24:18
|
| 1. 2 licenses per instance.2. what kind of sizing? Server spec? You can use sizing tool on server vendor's web.3. no.4. possible but don't make sense to leave another cpu idle. |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-09-28 : 02:22:28
|
| Thanks for the reply. Some clarifications 1. Just to confirm , Oracle gives CPU licese per core and applies a multiplication factor based on hardware . For intel hardware, they have 0.50 multiplication factor for per core . So for a quad core actualliy they are asking for 2 CPU license . I think this is not the case in SQL 2k5. 3.To elaborate this , if I have active/passive for database as well as AS (different from the original question), still I have the same licensing requrement.4.I dont want to keep the CPU idle , it will be used for the application . I have to confirm from the application vendor , if it can work that way. But how about SQL 2k5 possibility . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 22:26:46
|
| 1. no, Microsoft doesn't do that.3. AS comes with sql engine, license of one sql engine plus one AS is same as one sql engine's.4. possible. |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-09-29 : 00:34:17
|
| Thanks again . Re point 3 - Ya , I know about license for AS and DB engine being one . But is it that if we do FOC , we need license per server/node . How about db mirroring scenario, do i need license per node . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-29 : 00:50:32
|
| Microsoft count license per instance, not the machine. If you have one instance on active/passive cluster, need license for one instance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-29 : 00:58:47
|
quote:
Originally posted by rmiao
Microsoft count license per instance, not the machine.
Not if you use CPU licensing like we do.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
clustering for database engines