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 |
|
goblyn27
Starting Member
39 Posts |
 Posted - 2002-03-01 : 14:18:25
|
| First let me apologize since this is a tiny bit off the SQL topic specifically, but so far the people on these message boards have never let me down when it came to SQL questions so I thought I'd try my luck with this. I work for a Web Design firm and one of our clients, whose website we maintain, has a server problem. Sometimes the website will be god awfully slow and take minutes for a page to load. I'll pop onto the box using Terminal Services and it'll show the CPU idling along at 0 - 4% and the memory being used by the SQL Server and IIS are well within exceptable ranges (kinda low in fact.) I'm pretty sure that it is not something in the code I've written because the site we are working on hasn't launched yet and the only people that know about it are in my company, yet this problem seems to happen usually in the morning before any one else has come in. I think it may be something in the previous website or maybe something that is in use by the other website owned by our clients which is hosted on this same box (tho they don't have the administrator access to it that I do.)My quandry is this. Everytime it happens, the most I can do is reboot the server and hope that whatever it is that is locking up IIS will be taken care of by this. Usually it will, but sometimes it becomes an issue again within moments of rebooting. I'm a programmer and not much of a sysadmin, so I don't really know how to tell what is going on on the box when this happens.Any advice would be greatly appreciated. Please email or post here if you have any details you need me to clear up. Thnks in advance...--peter langepeter@apollointeractive.com"DuuuDe!! I suck!" |
|
|
goblyn27
Starting Member
39 Posts |
Posted - 2002-03-01 : 14:29:06
|
| I should add that the slowness even happens on ASP pages without database connections in them, so Im pretty darn sure that its not a problem with scripts connecting to the Database and taking too long to make their queries."DuuuDe!! I suck!" |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-03-01 : 14:37:23
|
| What OS / version of IIS is the webserver running?What speed cpu(s)?How Much ram?Is SQL Server on that same box?Is this slowness on the same pages all the time?The slowness goes away after the morning time?What time do backups occur?DO backups occur?Ok, that should be enough questions to get you started.Also, here's a good site to start at. I think you either have some stuff not configured right on the server, or your ASP pages just need some optimization.http://www.learnasp.com/learn/speedmore.aspMichael michaelp@televox.com |
|
|
|
goblyn27
Starting Member
39 Posts |
Posted - 2002-03-01 : 15:08:03
|
| Lets see,Ram 2 GigsCPU: Dual PII 800Yes SQL Server is on the same box.The problem usually occurs int he mornings, but has happened at varying times with lesser frequency. the problem does go away temporarily after time. Its not just ASP pages with code but even our index page which contains no asp script except for include files for specific HTML elements that are reused on the site. Lastly, the problem is a recent occurance (last two months or so) but the configuration of the server has remained static for a much longer time.In this instance, I can say with 100% certainty that it is not optimization issues in the ASP code on our site, and I dont think its simple asp optimization issues with any of the sites we do not maintain though I cannot be certain one way or another without something clue to follow from the OS."DuuuDe!! I suck!" |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-03-01 : 15:15:42
|
| I think your last paragraph really says it. If you feel pretty good about your sites, it's probably one of the other sites or some OTHER thing that servers does from tiem to time that you don't know about.Check out this link. I think you need to look at perfmon to see what is going on. I think someone else is calling a DLL that is slowing the whole thing down from time to time.http://www.microsoft.com/serviceproviders/whitepapers/tuningiis.aspMichael |
|
|
|
goblyn27
Starting Member
39 Posts |
Posted - 2002-03-01 : 15:56:26
|
| Yeah, I think it is something like that but Im just looking for a way to confirm. Thanks for posting that article link. I've printed it out and as soon as Im done cussing under my breath at my boss for making a programmer be a sysadmin, I'll be reading that very closely.Some days it really sucks being the only Windows guy in a Linux heavy company."DuuuDe!! I suck!" |
|
|
|
|
|
|
|
|
Server Performance