Avatar billede niemeyer Nybegynder
12. juni 2003 - 22:48 Der er 3 kommentarer og
1 løsning

MSDE - et spørgsmål om performance

Folks,

I need some extra eyes on an issue that puzzles me, i.e. the use of MSDE as the db engine for webapplications. I'm currently renting a full MS SQL 2000 license for my dedicated server (a couple of commercial ones but mostly sites in development) because I was led to believe that MSDE would underperform grossly when Internet users started to access the data. (I use SP's when I can and mostly run asp.net driven apps using output caching when suitable).

I discovered a 4 month old discussion thread in another forum where the author claimed to being able to (using some test software) output nearly 70 datadriven pages/second from an AMD 1.7 webserver with MSDE installed (using the SA account).
He then ran the same tests using the SQL 2000 server and fetched around 110.

Bottomline is that I'm not near neither of these numbers (not even at peaks) for my websites. I'm quite happy with the functionality of SQL2000 and I know that MSDE has its shortcomings but would it be corrent to assume that I could serve hundreds of simultaneous users requesting different pages on websites running on my server using the same SA/asp.net account?

Maybe I've missed something in the equation, but I'm anyway looking forward to having some expert opinions on the subject.

Thanks,
Niels (Brussels)


PS: Jeg undskylder at indlægget er på engelsk - men jeg prøver at finde ud af om andre har erfaringer med MSDE som db provider for high volume websites.
Avatar billede terry Ekspert
13. juni 2003 - 18:15 #1
Hi Niels in Brussels!
As far as I know MSDE is optimized for about 5 connects. This doesnt mean that no more than five connections can be made at once, it just measn that performance will deteriorate with further connections. So as long as you only have a handfull of connections open at one time then I would expect to see similar performance to a full version of SQL 2000. I'm not quite sure what you mean with "output nearly 70 datadriven pages/second" this doesnt indicate (to me) how many connections are used. So what I am getting at, if it sonly one connection then DO NOT expect to be able to serve hundreds of simultaneous connections with the same performance.
Avatar billede niemeyer Nybegynder
13. juni 2003 - 19:29 #2
Thanks, Terry, for the input. After reconsidering the matter I think I will keep my SQL license (260 euros/month) and speed up the web developement instead ;). The original thread featuring the guy with the 70 pages/second can be found here: http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=153644 - and yesterday I got some nice response from SQLTeam.com (http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=26962)

Thanks,
Niels
Avatar billede terry Ekspert
13. juni 2003 - 20:38 #3
Hi again Niels and thanks for the points :o)
260 euros/month sounds like a lot to me. I use http://www.buydomains.dk which has SQL Server too and although it states version 7.0, I have been told that it is 2000. They also have .NET support.
Must admit I am not using it as much as I would like but I find them to be very prof. With these prices I wouldnt even concider MSDE :o)

MSDE also has a max dB size of 2 GB, but then that is still a lot of data and there is NOTHING stopping you having more than one dB.

mvh
Terry
Avatar billede niemeyer Nybegynder
14. juni 2003 - 10:29 #4
It is a lot, but better than paying $20k flat out (the price the last time I looked). I considered shared SQL hosting as well (could get around that much cheaper), but somehow I like the idea of full control over the server (when it comes to xml, import/export, replication, backup etc).

// Niels
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester