Measure CAL Usage on Win 2000 and SQL Server 7

Posted on 2007-08-10
Last Modified: 2013-11-05
Is there any way with in windows 2000 or a third party tool to measure SQL server 7 CAL usage ??

I have a Win 2000 Prof Box with SQL 7 and a 20 CAL package, I'm Upgrading but the service has changed so I need to know if I need these many cals for the new SQL server 2005 set up ??
Question by:itimes
    LVL 6

    Accepted Solution

    I think what you will need to do is setup a job that runs and inserts sp_who2 data into a table daily to determine how many concurrent connections you may possibly have. If you are using the database for a web/internet i would recommend going with a processor based license instead of CALs.

    Author Comment

    Can I just ask .... what do you mean by 'sp_who2' .... ?? Test Data ???
    LVL 6

    Expert Comment

    If you go into SQL query analyzer and type sp_who2  it will provide you the connections/host and date time. This is basically a procedure that is built into SQL.  

    Author Comment

    Thanks !

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Title # Comments Views Activity
    T-SQL To Select PiD In Two Hobbies 3 32
    count vs exists 9 33
    Dataset not reading table data 12 36
    sql help 5 42
    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now