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 |
|
adamtech9367
Starting Member
2 Posts |
 Posted - 2008-11-08 : 12:18:18
|
| I have a .net application that runs great for a few days and then it greatly slows down. When I first start sql server my search page takes about 4 seconds to do a search. After the server runs for a few days the same search page running the same search take almost 40 seconds. I'm running dual Intel Xeon 3.0Ghz processors with 4 GB RAM/Mirred SCSI drives. Every two days I go into the task manager and restart sqlservr.exe and the website runs great again. Before I restart the process I always check my system resources and nothing seems out of place. When I run the performance monitor my Sql Server Buffer Cache hit ration is around 100%, % Processor time is under 5%, Memory:Available Bytes is 100%, %Disk time is under 5%. I'm not sure how to trouble shoot this problem. This server is running ms sql 2005, iis for three lightly used .net sites and hMail server (sql backend). Thanks in advance for any advice. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-08 : 23:41:22
|
| Have you applied Recent Service packs and patches to SQL Server?Also looks like Sql Server is not getting its memory it expected. Look at Memory Page splits/sec, Page life expectancy and procedure cache for SP. Run Profiler with Performance monitor and use Import Performance data in Profiler to nail down the issue. |
 |
|
|
adamtech9367
Starting Member
2 Posts |
Posted - 2008-11-09 : 17:45:49
|
| sodeep, thanks for the reply. My sql server is current with all of the service packs/update. Can you post a few more specifics on what acceptable values you would consider for (Memory Page splits/sec, Page life expectancy and procedure cache for SP). When I restart the sqlservr.exe the process is usually using about 1.2 - 1.5 GB ram and task manager show over 2.5 GB ram available. Can you also explain what you meant by "Import Performance data in Profiler"? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-09 : 17:56:10
|
quote:
Originally posted by adamtech9367
sodeep, thanks for the reply. My sql server is current with all of the service packs/update. Can you post a few more specifics on what acceptable values you would consider for (Memory Page splits/sec, Page life expectancy and procedure cache for SP). See this:http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SQL%20Server.htmWhen I restart the sqlservr.exe the process is usually using about 1.2 - 1.5 GB ram and task manager show over 2.5 GB ram available. Can you also explain what you meant by "Import Performance data in Profiler"?http://www.mssqltips.com/tip.asp?tip=1212
|
|
|
|
|
|
|
application slows down after a few days