• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Howto identify the end of a MS SQL Server 2000 trial time

Hello,

we are using the MS SQL Server 2000 trial version for a test.

Now I need to know when it will timeout to start further actions on time. Is there a time bomb or do we "just" have a license issue after the 3 months trial time?

Tolomir
0
Tolomir
Asked:
Tolomir
  • 3
  • 3
2 Solutions
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
You can use MSDE free version (no trial) if your db does not exceed 4Go.
0
 
patriktCommented:
All MS trials are blocked when period expires. If your CD reads ..."120 day trial" it is sure that it will expire.
But regardless of time period each trial is licenced only for testing and preview. If you run production application on it you are already out of licence :)
0
 
TolomirAdministratorAuthor Commented:
The 2000 MSDE edition is not able to handle a concurrent access for more than 3 users.

We got up to 6 users working on that Database.

I already tried to upgrade it to MS SQL server 2005 express edition but the update adviser claims that some system tables are not supported.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
patriktCommented:
I don't know who says this about MSDE. It is completely not true. MSDE can support any number of users, only existing limit is on simultaneous query exution when its internal block will start to slow down execution.
It is completely normal runing 20 users applications on MSDE.

Never beleave what someone says. Test it yourself. :)

For upgrade to 2005 just read carefully upgrade whitepaper and suggestions in upgrade advisor. it will explain what to do.
0
 
TolomirAdministratorAuthor Commented:
...only existing limit is on simultaneous query execution...

The application depends highly on queries and foreignkeys.  So what is the bottleneck precisely or better under what conditions will the database be slow?

0
 
patriktCommented:
There are several measurements on web but nothing is clear. MSDE contains part which will reduce performance when more than 6 (? also not known exactly ?) concurent queries is running.
One theory is that it will put 6th request in queue and let it wait until some of previous finishes.
Second theory is that it will run 6th request in reduced performance mode.
Third theory is that it will reduce performance of all queries running.

What is sure:
No disconnection or error will happend. Application will know nothing about this problem and it will not harm it.
It is per-query and has nothing to do with number connections or users. You have to have more queries running in same time which is very hard to achive with as litle as 20 users.
0
 
TolomirAdministratorAuthor Commented:
ok, I will forward this to my collegues.

Regarding the left time, I've installed the server on the 8th of August so I suppose it will run until Dec, 6th 2007.

Thank you for your advice.

Tolomir
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now