How SSD hard drive affected speed of your website (asp.net/linq/ms sql database)

I have a small database (<1G) But we have a lot of complex logiс in website and client complains on render time, which is 3-5 seconds. We are not google, and thousands of users a day is our dream, so size is not a problem, but speed is important. Can anybody share with experience with SSD drives for ASP.NET (MVC)/LINQ/MS SQL based application ? How you performance increased?

UPDATE: this whitepaper states that it will be 20 times faster. http://www.texmemsys.com/files/f000174.pdf

Solution 1:

I would add my comment to an earlier answer, but I don't have enough reputation ... so here goes ...

Buy more RAM. Lots more RAM. If you have 4GB, go to 16GB or 32GB. Even 32GB or RAM will likely be cheaper than GOOD SSD. Most SSD drives are no better than hard-drives, with the expensive Intel drives being the notable exception (there are other SSDs that are even faster, but those are far more expensive).

If your database is only 1GB, SQL Server will cache almost the entire thing in memory if you add enough memory. The only exception is if your process is writing a lot of data. If you have 1,000 INSERT transactions that need to happen for each user action a lot of memory won't help much, and then an SSD drive MIGHT be useful ... but I suspect that is not the case. In any read operation memory will always improve performance much more than hard drives.

Solution 2:

Have you actually traced where your problem lies? Is it in the database query? Is it processing the query on the server side? Content rendering? Transmission of the rendered content? There's many area's that can bottleneck performance on a multi-tier web application, and to do any meaningful performance improvement, you need to analyze what's slowing things down.