• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • 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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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