How many users will a single CPU handle? (relates to licensing)  
Author Message
WCM





PostPosted: Wed Sep 29 15:52:30 CDT 2004 Top

SQL Server >> How many users will a single CPU handle? (relates to licensing)

To figure out which licensing option for SQL to recommend to our customers,
we need to know how many processors we need. On MSDN I ran through a couple
of capacity planning tools, but it keeps saying I need 2 CPUs, which costs
40K if you go with the Processor license (versus Server with User CALs). If i
could figure out how many users require one CPU, this would help me. You know
of any tools or capacity planning logic to help me?

SQL Server113  
 
 
Vessel





PostPosted: Wed Sep 29 15:52:30 CDT 2004 Top

SQL Server >> How many users will a single CPU handle? (relates to licensing)


> To figure out which licensing option for SQL to recommend to our customers,
> we need to know how many processors we need. On MSDN I ran through a couple
> of capacity planning tools, but it keeps saying I need 2 CPUs, which costs
> 40K if you go with the Processor license (versus Server with User CALs). If i
> could figure out how many users require one CPU, this would help me. You know
> of any tools or capacity planning logic to help me?

This is what I used:

http://www.microsoft.com/sql/howtobuy/faq.asp

--
Vessel
 
 
EmmaNelson





PostPosted: Wed Sep 29 16:29:02 CDT 2004 Top

SQL Server >> How many users will a single CPU handle? (relates to licensing) I have read through this Web site and called MS Sales reps. Question still
remains... thanks for responding though.





>
> > To figure out which licensing option for SQL to recommend to our customers,
> > we need to know how many processors we need. On MSDN I ran through a couple
> > of capacity planning tools, but it keeps saying I need 2 CPUs, which costs
> > 40K if you go with the Processor license (versus Server with User CALs). If i
> > could figure out how many users require one CPU, this would help me. You know
> > of any tools or capacity planning logic to help me?
>
> This is what I used:
>
> http://www.microsoft.com/sql/howtobuy/faq.asp
>
> --
> Vessel
>
 
 
Greg





PostPosted: Wed Sep 29 22:22:33 CDT 2004 Top

SQL Server >> How many users will a single CPU handle? (relates to licensing)


> To figure out which licensing option for SQL to recommend to our
customers,
> we need to know how many processors we need. On MSDN I ran through a
couple
> of capacity planning tools, but it keeps saying I need 2 CPUs, which costs
> 40K if you go with the Processor license (versus Server with User CALs).

Note, that's if you require Enterprise Server. Standard Server is only
$5K/cpu last I checked.

> If i
> could figure out how many users require one CPU, this would help me. You
know
> of any tools or capacity planning logic to help me?

Well, sounds like you've already done the capacity planning. Not sure what
you're looking for differently.

Perhaps there's tuning in your app you can do to be less CPU intensive?