Every time I have used MSDE, I have found it eats the CPU like a starved animal whenever you put any intensive load on it. It also has a limited number of simultanious connections too. I would presume every page on your site does not hit the database.
Snake -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 05 August 2006 00:54 To: CF-Talk Subject: Re: CF/.NET/SQL Express Server Install Question I just built a sql server running MSDE 2000 for a client. They get a few tens of thousands of sessions per day and I am absolutely amazed at how well the server is handling the load. I opted NOT to go with SQL Server Express because I didn't see the point, frankly. SSE uses tons of extra resources, (.NET 2.0 for starters), warns me that my server is below the base spec and didn't want to work with Enterprise Manager. MSDE on the otherhand is a resource nibbler by comparison. After a day of getting hammered the service is only eating about 235mb, with resource spikes that look like little bumps, never going above about 20%, and momentary ticks at that. Just a thought... If you are combining stuff onto one server make sure you really need the resource hog versus what may be a fully functional alternative. -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
