Tracking License Usage

[JTechMan]

Hi All,

I was hoping someone could tell me how to identify how many user cals are being used on our SQL 2008 installation! I am also wondering if a DSN connection (with Windows auth) combined with an ODBC connection with Windows auth could potentially double the license usage.

Thanks!!

 

[mrdenny]

The SQL Server doesn't track user CAL usage. You simply have to count the users that use the SQL Server, no matter how they connect.

As easy way (if you are using Windows Auth, or a separate SQL login for each user) would be to setup a job to scrape the sys.sysprocesses DMV and capture the username of the people logging in. Then after a few days do a SELECT count(DISTINCT UserName) from the table you are logging the data into.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[JTechMan]

Thanks! I was hoping that this might explain a connect call failed error, but it sounds like connections are pretty unlimited.

 

[mrdenny]

They should be wide open. In older versions of SQL Server you told it how many CALs you had, and it would only allow that many people to connect. That shouldn't be an issue any more.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog