Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
giovanni.mascia
Starting Member
1 Post |
 Posted - 2008-09-04 : 10:32:26
|
| I have a webapp in Asp.net 1.1 with SqlServer 2005 Express Edition.It's a typical small website with 1.000 registered users and 100 articles (most textual) published.This thing is on a Pentium 4 single-processor machine with 512mb of RAM which hosts both the SQL and the IIS.The site has only 600 unique visits per day.The problem is, it's getting really really slow and I cannot figure out why. I made a list of thing to improve performance:- Using a DB connection pool- Upgrade from SQL Express to the standard edition- Using Asp.net cache to serve faster most popular contents- Upgrade the RAM- Moving SQL on another machine- Get more bandwithWhat do you think?With those little numbers I thought that even a porly designed app (without caching, connection pools, etc.) and with a basic hardware could work.Thans for your helpGiovanni |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-04 : 12:27:59
|
| what OS ? 2003 server ?memory seems low to me. |
 |
|
|
preethi
Starting Member
11 Posts |
Posted - 2008-09-04 : 22:48:16
|
| You have not specified the disk configuration. Can you explain how manhy disks you have, how they are configured, their speed and which drive is used to store databases?Can you open Performance (Monitor) under administrative tools (or you can simply type PerfMon.exe in run utility.) and check the Disk Buffer Cache hit ratio, Memory pages/Sec, Disk Queue Length and Processor time % can you over a period of time so that we can analyze the data to see what is wrong.On a side line, the best place for this topic would be SQL Server Administration.Cheers,Preethiviraj KulasinghamMCITP: DBA |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-05 : 02:14:39
|
| SEe thishttp://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx |
|
|
|
preethi
Starting Member
11 Posts |
Posted - 2008-09-06 : 12:29:52
|
| You mentioned that "it" is getting slower. What do you mean by "it" ? User response time or SQL Server Query processing time. Total time will definitly increase if any of these increase.Cheers,Preethiviraj KulasinghamMCITP: DBA |
|
|
|
preethi
Starting Member
11 Posts |
Posted - 2008-09-06 : 12:29:53
|
| You mentioned that "it" is getting slower. What do you mean by "it" ? User response time or SQL Server Query processing time. Total time will definitly increase if any of these increase.Cheers,Preethiviraj KulasinghamMCITP: DBA |
|
|
|
|
|
|
How to increase performance