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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-30 : 08:41:55
|
| Vaibhav Kamath writes "I have a web-based application written in SQL Server, VB 6 (COM) and ASPOver a period of time (1 week) the application tends to slow down (not drastic) at which point I start/stop SQL Server, kill dllhost. This betters the performance.I have looked at the followingProfiler, to see if there are any SPs that are taking a long timeCPU usageMemory usageNetwork Bandwidth UtilizationWe use SQL XML, hence looked at the SQL XML queue lengthSome more parameters in Performance Monitor, like Disk Read / Write timesalso on the Application Server (ASP) followed the sameI did not find any peaks or anything that is eating up resources most of the resource usages are between 20 to 40% rangeIs there something I have missed?Can we say with the above information that SQL Server is fine (no tuning required) and it has to be COM or the front-end code that is messed up?My understanding is that a slow down is caused due to lack of resources, but in this case the CPU and memory usages are way below the 50% mark.I have read some of the performance tuning tips on this site but before I try some of those I want to know a way to identify where the problem is. Right now I am fighting a battle with an unknown enemy.Thanks,Vaibhav" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Server Performance 