473,702 Members | 2,325 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 200 Developer vs Enterprise versions

I am having some problems in the process of moving an Access back-end
to an SQL Server back-end. Everything works but there are severe
problems of response times when the number of users builds up.

At present we are using the Developer version before committing to the
Enterprise version. BOL (quoted below) seems to suggest that, apart
from licensing, they are the same.

Can anyone please confirm that this is so. If not, what is the
difference?

I may explain in another topic the problems I am facing but I first
wish to be clear on this particular question.

---------------------------------------------------------------------------------------------------------------
Quote from BOL

Microsoft® SQL Server™ 2000 is available in these editions:

SQL Server 2000 Enterprise Edition
Used as a production database server. Supports all features available
in SQL Server 2000, and scales to the performance levels required to
support the largest Web sites and enterprise online transaction
processing (OLTP) and data warehousing systems.

SQL Server 2000 Developer Edition
Used by programmers developing applications that use SQL Server 2000 as
their data store. Although the Developer Edition supports all the
features of the Enterprise Edition that allow developers to write and
test applications that can use the features, the Developer Edition is
licensed for use only as a development and test system, not a
production server.

Aug 11 '06 #1
5 12923
On 11 Aug 2006 12:25:19 -0700, "Jim Devenish"
<in************ ***@foobox.comw rote:
>I am having some problems in the process of moving an Access back-end
to an SQL Server back-end. Everything works but there are severe
problems of response times when the number of users builds up.

At present we are using the Developer version before committing to the
Enterprise version. BOL (quoted below) seems to suggest that, apart
from licensing, they are the same.

Can anyone please confirm that this is so. If not, what is the
difference?
I believe that's correct.

What do your RAM, HD, CPU, and network bandwidth look like?

You have to do some non-obvious tweaks to let SQL Server use more than
2 GB of RAM.
Aug 11 '06 #2
Jim Devenish (in************ ***@foobox.com) writes:
I am having some problems in the process of moving an Access back-end
to an SQL Server back-end. Everything works but there are severe
problems of response times when the number of users builds up.

At present we are using the Developer version before committing to the
Enterprise version. BOL (quoted below) seems to suggest that, apart
from licensing, they are the same.

Can anyone please confirm that this is so. If not, what is the
difference?
The difference is exactly in the license. And when you mention users
building up, I get a little vervous that you are violating it...

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 11 '06 #3
We are trying to evaluate the use of SQL Server as a back-end and
although the system works with a very small number of users we are
encountering difficulties when the number rises to about 8-10. If we
cannot overcome these we will revert to Access back-end.

If we are successful, the licenses will be acquired for Enterprise
edition. There is no intention of violating licences. We do however
wish to test the system fully before advancing.

As I said in my original post, I am happy to explore the problem in
another post. I just wanted to eliminate the possibility that the use
of the Developer version was contributing to the problem.
Erland Sommarskog wrote:
Jim Devenish (in************ ***@foobox.com) writes:
I am having some problems in the process of moving an Access back-end
to an SQL Server back-end. Everything works but there are severe
problems of response times when the number of users builds up.

At present we are using the Developer version before committing to the
Enterprise version. BOL (quoted below) seems to suggest that, apart
from licensing, they are the same.

Can anyone please confirm that this is so. If not, what is the
difference?

The difference is exactly in the license. And when you mention users
building up, I get a little vervous that you are violating it...

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 11 '06 #4
Jim Devenish wrote:
We are trying to evaluate the use of SQL Server as a back-end and
although the system works with a very small number of users we are
encountering difficulties when the number rises to about 8-10. If we
cannot overcome these we will revert to Access back-end.

If we are successful, the licenses will be acquired for Enterprise
edition. There is no intention of violating licences. We do however
wish to test the system fully before advancing.

As I said in my original post, I am happy to explore the problem in
another post. I just wanted to eliminate the possibility that the use
of the Developer version was contributing to the problem.
SQL Server can easily handle thousands of simultaneous users. But it's
equally true that poor design and implementation can kill performance
even in a small database with a handful of users.

Did you review and redesign the logical and physical data model when
you ported to SQL Server? Did you rewrite your data access code to run
as server-side T-SQL stored procedures? If you did not do those things
or if you are still binding tables to Access forms then you are not
taking good advantage of SQL Server and N-tier architecture. Do not
expect SQL Server to be a supercharged version of Jet - it just isn't.

Assuming you have put in the effort to re-architect for SQL Server then
take a look at the following article for suggestions on troubleshooting
performance issues. These are primarily tuning and troubleshooting
suggestions. They are not a substitute for effective design up-front.

http://support.microsoft.com/?id=298475

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

Aug 12 '06 #5
Jim Devenish (in************ ***@foobox.com) writes:
We are trying to evaluate the use of SQL Server as a back-end and
although the system works with a very small number of users we are
encountering difficulties when the number rises to about 8-10. If we
cannot overcome these we will revert to Access back-end.
Certainly one woujld expect SQL Server be a lot better on handling many
users than Access. But with poor indexing etc, you can make things to
really slow on SQL Server as well. And if you just migrated the Access
database with the up-sizing wizard, you most likely have a non-optimal
database.
If we are successful, the licenses will be acquired for Enterprise
edition. There is no intention of violating licences. We do however
wish to test the system fully before advancing.
When I think of it, moving from Access to Enterprise for a back-end is
quite a step, not the leasr financially. Are there any special feature
in Enterprise you are yearning for? Else, Standard or even Workgroup
Edition may work just as well.

For evaluation purposes, you should probably use Evaluation Edition, but
I'm not the license police. :-)

By the way, your post says SQL 200, I suppose that means SQL 2000. Why
not SQL 2005?

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 12 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1710
by: Jason | last post by:
Hello All, two quick questions ok what is the major difference between .net Pro and .net Enterprise Developer Version 2003 (other than cost)? And I am looking to upgrade from MSVS v6.0 Pro to a .net version, but I need crystal reports and Visual SourceSafe, is Enterprise Developer Version 2003 the one I want? Thanks in advance
6
3117
by: Martin Meyer im Hagen | last post by:
Hello, I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a server machine. It works almost fine, except the application which uses the SQL Server. The main part of the application runs (since the last update) fine, but other tools of that application (database import and the database manager for check and rebuild) doesn't. They hang up or kill the database. Our software developer says that these problems are in...
0
4543
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
32
2522
by: dreadnought8 | last post by:
I have a client who wishes to upsize an A97 system from Jet backend to SQL Server 2000. They have up to 4 users. Will they need to buy the minimal 5-seat SQL Server product, or would it be cheaper to upsize the front end to A2K, A2K2 or A2K3 and use the version of SQL Server provided with that? The system uses local tables extensively and I would not want to disturb this. Enterprise manager would be a requirement. TIA
3
1362
by: Mark | last post by:
Anyone know of a list of features lacking in Web Developer 2005 Express that are already in VS.NET 2003? I realize they take a slightly different approach due to the new ASP.NET 2.0, but I'm trying to envision the compelling reasons why people will want to buy VS.NET 2005 with the availability of Web Developer 2005 Express. I tend to avoid any and all wizards, so I was just happy to see that Intellisense was included. Thanks in...
22
3295
by: EP | last post by:
When running my asp.net hosting service (asp.net without IIS), on server 2003 with IIS not installed, I get the following when trying to process a request. "System.DllNotFoundException: Unable to load DLL (aspnet_isapi.dll)." Of course the dll is able to be found, it's still in the framework directory and for grins I even put it in my service's local directory. This is apparantly server 2003 not allowing asp.net to be run if IIS was not...
0
1485
by: tommie.nygren | last post by:
I am using Visual Studio.NET 2003 Enterprise Architect Edition (according to my IT guy... how do I actually check what version of it I am using?) and SQL Server Developer Edition (8.00.194 for you who care). In the documentation it says: To generate create scripts 1. In Server Explorer, right-click the database object for which you want to generate create scripts. This might be the entire database, a specific table, stored procedure,...
14
3032
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this problem.(Like should I install any new OS etc). Any help would be appreciated.
14
2651
by: Guillermo_Lopez | last post by:
Hello, Our company has developed several Access applications for our clients and we wish to expand to use a database server. We wish to use Access as the front end application and SQL Server 2005 as the back end Databes Server. Making a Server-Client application database. I'm very new to SQL Server so my concern is how the licensing works for a developer like us. I am aware that we can purchase the Developer edition for $49 USD. Our...
0
8739
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8652
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9234
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9089
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8983
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8940
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7831
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5907
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4412
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.