| Author |
Topic |
|
DIWebMaster
Starting Member
4 Posts |
 Posted - 2005-03-13 : 11:35:34
|
Hello Everyone, I'm brand new to the site and I hope that someone will have the answers that I'm looking for.I’m a part time web administrator doing content updates on a website and some minor ASP programming. We have a Windows 2000 Server running IIS. On an separate server (which is a shared) we have a SQL Server database running that has members names, email address, and articles for the web site.Our website dynamically generates content based on the users area code, which they enter at the "index" page. Its nothing more than ASP pages with database calls.Everything was working great, fast and trouble free until we had a Server issue that caused us to reformat the Windows 2000 Server and reinstall IIS and our website content. Nothing on the SQL Server was touched, just the 2000 Server Box.Since the reload we have noticed a HUGE slow down in performance when the user first enters there area code, thus making the database call and piping the data to a content page.Since the IIS box was the only thing that changed I’m guessing its something with respect to that. I thought it was an ODBC issue, but everything is working correctly, just very very slow.I know this is kind of broad, but would anyone have any suggestions on what it might be? Do you think its a SQL Server issue (separate server) or the something with the Windows 2000 Server running IIS?I’m not a DBA, but I do know basic SELECT calls and things of that nature. Any help is greatly appreciated.Thanks for taking the time to read.- FredCliff Notes1. We have 2 servers for our webpage, One Windows 2000 Server ONLY running IIS, and the other, a shared server running SQL Server.2. We had an issue that forced us to reload our IIS server- Windows 2000 Server (NOT from an IMAGE of the hard drive  ).3. Now that everything is reloaded we have a MAJOR slow down when trying to display data from the database to a web page.4. I don’t know if its on the Windows 2000 Server side (IIS Machine) or the shared server (database). Please keep in mind that my logic states the ONLY thing that has changed was the IIS Server, not the SQL Server. I’m out of ideas, HELP.  |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-13 : 13:15:54
|
Several things to look at:1. What do the performance counters look like on both servers?--Do you have any network latency on either side?--Do you have any process, memory, or disk queue length problems on either side?2. Have you looked at the IIS, SQL Server, and event viewer logs to see if there are any issues?This isn't much help, but you aren't giving us much to go on.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
DIWebMaster
Starting Member
4 Posts |
Posted - 2005-03-13 : 13:48:31
|
| Thanks for the reply.I just logged into the Windows 2000 Server and looked through the event logs and nothing seemed strange to me. The Performance counters showed nothing and when I looked at the Task Manager, theres only 6 things running, roughly 145 MB in RAM, the IIS Server has 1 Gig of RAM.Per the hosting company I cannot get access to the Server where the database is running, but I can log into the database using SQL Enterprise Manager. Am I able to access logs that way, or do I need Terminal Access for that?I know I'm not giving much to go on, but I'm really shaking my head on this one. The hosting company acknowledges the slow down, but that's about it. I wonder if it could have something to do with the new hard drive that was installed, they told me it was the same type as the others. From what they have told me, the hard drive configuration is a RAID Mirror.Maybe there could be a latency setting for the hard drive in the RAID Controller?If I think of anything else, I will post it.Thanks- Fred |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-13 : 13:56:58
|
| How long ago was this hard drive installed? It can take a LONG time for the RAID arrays to finish rebuilding when you lose a drive. Depending on how big the RAID array is, what the speed of the drives is, etc. you will experience a significant slowdown during this time period.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2005-03-13 : 22:57:08
|
| Make sure you also get MDAC 2.8 from microsoft and get that installed.Quality Web Hosting & Designhttp://www.eznthosting.com |
|
|
|
DIWebMaster
Starting Member
4 Posts |
Posted - 2005-03-14 : 02:49:22
|
| The hard drive was installed 2-3 weeks ago, could it take that long to rebuild the RAID mirror, that seems very odd.I just installed MDAC 2.8 and the associated security update - still the slow down. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-14 : 11:41:12
|
| Do you know exactly what SQL generates the latency? If not, try stepping through the code to find out.Is this the same version of IIS as was used on the previous IIS server?Have you tried installing Query Analyzer on the IIS server and running the SQL manually? Is it fast or slow? |
|
|
|
DIWebMaster
Starting Member
4 Posts |
Posted - 2005-03-14 : 16:57:45
|
| Yes, its the VB Script (ASP Code) that makes the database callsYes, same IISIm not sure how to install Query Analyzer, but does this link explain how to set it up?[url]http://www.madirish.net/tech.php?section=10&article=88[/url]Our SQL Server is locted on a "share" and the hosting company will not give me Terminal Access. The only thing I can use is Client Admin tools. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-14 : 17:29:41
|
| Is the ASP code slowing it down or the response from the SQL server?Query Analyzer is a client tool. If this is your SQL server, then you should have the software. If you have been contracted, you may need to obtain a copy of the client tools from your customer. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-15 : 03:51:06
|
| Have you got things like name resolution set up properly on the IIS box?Is the IIS box using the same client libraries as before to connect?I very much doubt that this is a SQL issue, more likely there's a bit of configuration on your IIS box that is ever so slightly different.-------Moo. :) |
|
|
|
|
SQL Server Slow down with IIS, any ideas?