March 29, 2004 at 10:26 am
I have 2 questions hope someone can help me.
1. What is the minimum permission required to run Profiler (trace). I try to grant the trace SP and does not seems work. Someone told me it need SA permission ?
2. I plan to run active/active on a cluster server (8cpu. 4GB RAM). If I only allocate 4 CPU to each SQL instance, how many SQL lic. (per processor lic.) do I need ? Someone told me 8 and others say 16. I'm just trying to maxmize RAM utilzation.
March 29, 2004 at 11:30 am
1. SA/sysadmin permission
2. Is this 8cpu per node? Then you need 16. You have to license each CPU in an active cluster node.
March 29, 2004 at 11:49 am
Thanks for the first one. Though, I don't think 'SA' permission is required on SQL 7.0
For second one, if I only assign 4 cpu to each instance why I need pay 8 cpu (yes, it is 8 cpu per node)? I know this is not something we can decide.
March 29, 2004 at 12:37 pm
Due to the fact that you could be using potentially all 8 cpus on either machine in an active/active cluster you would need to licence for 16. If you were allowing sql to use all 8 cpus on each you would need to licence 32. (8 cpus * 2 instances * 2 servers(a/a) = 32) (4 cpus * 2 inst * 2 srv = 16)
March 29, 2004 at 2:41 pm
Not sure about SQL 7. Have to check BOL on that one.
For licensing, I've asked this ? of MS before and they say you have to license all physical processes. For clustering, you need enterprise edition I believe, which is only single license regardless of instance count. So you'd license 16.
March 29, 2004 at 2:49 pm
From MS website
If you have made a processor inaccessible to all operating system copies on which the SQL Server software is set up to run, you do not need a software license for that processor.
And a nice little footnote on the choosing page http://www.microsoft.com/sql/evaluation/features/choosing.asp
"Is possible, but each instance must be licensed". refers to using instances with standard edition.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
March 29, 2004 at 2:51 pm
The processor statement allows for the use of Virtual server where the OS that SQL is running in will only have access to x processors of the y processors available.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply