SQL Server 6.5 (max users)

[Guest_imported]

How do I get the maximum concurrent users connecting to one database per day?
I need this information so I can order the required amount of licenses.

 

[tlbroadbent]

I believe you can count connections using performance monitor. I don't recall the details because we have been using SQL 7 for some time now. Just look at the available SQL Server counters in Performance Monitor.

For per server licensing in SQL 6.5, you'll really want to count the number of unique clients connecting to the Server. Although, you limit the number of connections in SQL Server, licensing is by client. A client can open multiple connections at one time. You don't need to license every connection.

Are you sure you'll even be able to purchase more licenses for SQL 6.5? Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin