April 18, 2003 at 11:19 am
I have a project which has to be developed using SQL Server as the database server. But buying SQL Server 2000 does not fit into the budget of my client. So I suggested them to use MSDE 2000.
So I just wanted to know what is the level of drawback in performance if I use MSDE and how can I calculate the difference in performance? Are there any tools available specifically to measure performance.
Paras Shah
Evision Technologies
Mumbai, India
Paras Shah
Evision Technologies
Mumbai, India
April 18, 2003 at 12:35 pm
I seem to recall that Microsoft's information says that the MSDE database has a maximum size of 2GB.
-SQLBill
April 18, 2003 at 12:39 pm
April 18, 2003 at 1:44 pm
Any issues with speed. If I have 100 users connected to MSDE and 100 users connected to SQL Server then whats the performance differemce?
quote:
Check out this site:http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp
-SQLBill
Paras Shah
Evision Technologies
Mumbai, India
Paras Shah
Evision Technologies
Mumbai, India
April 21, 2003 at 4:22 am
You do have to keep in mind the 5 concurrent operations fact. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_0mhx.asp
and a bit more here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_9gz4.asp which explains the performance decreases over 5 concurrent operations based on the total load.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply