| Author |
Topic |
|
sr_erick
Starting Member
6 Posts |
 Posted - 2004-02-06 : 12:35:46
|
| How does MSDE compare in speed to a full blown $5k version of SQL server? Is there any performance loss at all?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-06 : 12:39:45
|
| The engine is the same, so the performance is the same. With MSDE, you don't get the GUI tools. You also can't use Reporting Services with MSDE. MSDE can't be used on Windows Data Center. Yada, yada, yada. There are a lot of things that MSDE can't do. Performance though should be the same.Tara |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-06 : 14:23:23
|
| Well, performance will be the same up to about 5-10 users, at which point MSDE will "slow down" automatically. I think they say "5 concurrent queries" is the point at which it starts to slow. If you don't have users banging on the server, you can get a lot more physical users on this "5 user" system. With MSDE, just get in and out as quickly as possible.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-02-06 : 14:57:45
|
| you can download the evaluation edition of sql server 2000 (it's free) and install the client tools against your MSDE installation. I'm not sure if the client tools expire, though, or not ....- Jeff |
|
|
|
sbt1
Yak Posting Veteran
89 Posts |
Posted - 2004-02-06 : 15:54:52
|
| We have about 10 users here, and no one ever has performance issues. I use a Dell high-end workstation. Just make sure you have at least a 7200RPM drive, it makes a huge difference. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-06 : 16:01:31
|
| Yep, RAM, DISK, and CPU are what makes a SQL Server fast (in that order pretty much).Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2004-02-06 : 17:14:15
|
| I also have a MSDE db on W2K Pro supporting maybe 8-10 workstations and two db apps. MSDE has performed well in this environment.======Doug G====== |
|
|
|
sr_erick
Starting Member
6 Posts |
Posted - 2004-02-09 : 19:29:52
|
| Ok, this is good to know. I am planning on building a new server for my website on which I run snitz. ( http://www.snowmobilefanatics.com ) Was planning on something like a 2.6 ghz rig with a couple 7200 rpm drives and a gig of ram or so. This winter I have been averaging 100-150 users online at a time. I can expect it to double next snowmobile season. I think snitz only makes a few connections to the db. I will probably be runnins some SP's as well. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-09 : 20:21:56
|
| I think Gratz has worked some magic with this version of Snitz to make it faster.Give this article a read.http://www.sqlteam.com/item.asp?ItemID=6891Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
sr_erick
Starting Member
6 Posts |
Posted - 2004-02-09 : 21:13:35
|
| Cool I am checking out that link now. Looks like a lot of good stuff. |
|
|
|
DavidRhodes
Starting Member
40 Posts |
Posted - 2004-03-04 : 14:17:44
|
| Ah, it's the Snitz lot.sr_erick, i'm current testing my site (www.uk-mkivs.net) on MSDE so i'll let you know the outcome |
|
|
|
sr_erick
Starting Member
6 Posts |
Posted - 2004-03-22 : 20:29:47
|
| Cool, how it that going so far? |
|
|
|
euan_garden
Microsoft SQL Server Product Team
34 Posts |
Posted - 2004-03-24 : 00:46:35
|
And that would be breaking the license agreement...quote:
Originally posted by jsmith8858
you can download the evaluation edition of sql server 2000 (it's free) and install the client tools against your MSDE installation. I'm not sure if the client tools expire, though, or not ....- Jeff
|
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-24 : 19:36:17
|
quote:
Originally posted by euan_garden
And that would be breaking the license agreement...
Hey Euan, that's good to know. And welcome! It's always good to have a knowledgeable MS guy around.P.S. Great to chat with you at PASS last year, hope to see you in Orlando!--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
DavidRhodes
Starting Member
40 Posts |
Posted - 2004-03-25 : 04:41:45
|
quote:
Originally posted by sr_erick
Cool, how it that going so far?
It's been running on MSDE for about 3 weeks now. It only starts to slow down with 80+ users online at once |
|
|
|
sr_erick
Starting Member
6 Posts |
Posted - 2004-03-25 : 15:36:24
|
| Hmm, I will have to look into it and do more testing. I need to be supporting at least 150 - 200 users online at a time next season. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-25 : 15:45:33
|
| 150-200 users! I'd seriously look at Standard Edition of SQL Server.Tara |
|
|
|
sr_erick
Starting Member
6 Posts |
Posted - 2004-03-26 : 18:22:55
|
| Are you sure? I don't really want to spend a whole $5k on a database server. I am sure MSDE can handle it, I wouldn't see why not. |
|
|
|
sbt1
Yak Posting Veteran
89 Posts |
Posted - 2004-03-29 : 09:46:03
|
| The key is: get in and get out quick.Connect, do what you have to do and disconnect immediately; that's how we make MSDE work well. |
|
|
|
|
MSDE Speed