IIS site works slow.

Hi,
Pls guide me in solving the below issue..

Our site sometimes is working too slow and sometimes it works fine,Its is java with sqlserver as backend.
Its in OLTP for banking ..web enabled.
Server Config is as under

Db Server. + Appl Server (Javaw)
----------
Db Size is : 6 gb
Server : Compaq Proliant ML350 G2
CPU : Intel PIII 1.133 GHz * 2
Ram : 2 GB (512*4)
3 * 36.4 GB 10K U3 HP
1.174 TB (6 x 146.8 GB 1² with standard internal hot plug drive cage + (2 x 146.8 GB 1² ) with optional ML3xx Internal Two Bay Hot Plug SCSI Drive Cage)

Log and Data files are on same hdd : Raid Level 5..

Web server : Same config with JRun and IIS.(also some schedules running on which hits db after every 10 mins in jave for email etc)

We are unable to trace the issues...site sometimes is dead..and sometimes works fine.

I check db proc's and indexes..it is not proper and sometimes one or two processes are getting blocked(but this happen in 3-4 days)...Usuage of tempdb is also high..but we had schedule our processes which truncates tempdb time to time..I had advised some indexes + optimzied most of the procedures..(this is in test server)

---
and after all we had installed OS + IIS of web server..WE HAD CHECKD ONE THING..WHEN SITE IS SLOW ITS WORKING WITH JRUN(DIFFT PORT) BUT WITH IIS ITS DEAD SLOW...
They are uusing xml with Jsp and java...
--
as Per perf counter of db server: Cpu usage is low,full scan / sec(sometimes its high around 6+),pages / sec =2 or 3/recompile / sec(always 0.00123...etc))


pls help me ..in solving the following issues.

1) We r not able to figure out whether db is slow or is there any db server issues...(optimzied queries and indexes are still on test server)
2) is there any web server issues..wot things we need to check with IIS/Jrun or java..
3) If there is any deadlock or blocking session on one procedure..will it hamper the performance of entire site or only web pages or processes related with the tables used in procedures becomes locked and slow...
4) Is it advisable to restart sql server..this thing clients DBA are doing more often whenver sites becomes slow...or may be webserver ..and after this they found site works fine.


Pls help me in finding solution or forward to concerned expertise persons.
WE ARE TRYING TO FIGURE OUT PROBLEM FROM LAST 10 DAYS BUT FAILED...

timcof
Mon Nov 10 04:43:39 CST 2003

I would highly suggest opening a support case with the vendor of your db server, if you believe it is blocking in some fashion. There are way too many
things here to try and post a solution. You can try running IISstate from www.iisfaq.com and posting a log back on a new thread.

Thank you. I hope this information is helpful.

Tim Coffey [MSFT]

This posting is provided ?AS IS? with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft Corporation. All rights reserved.
--------------------
| Thread-Topic: IIS site works slow.
| thread-index: AcOX8Li8OPk/68+ISgusT7rpRR2ogg==
| X-Tomcat-NG: microsoft.public.inetserver.iis
| From: =?Utf-8?B?c2FuamF5?= <anonymous@discussions.microsoft.com>
| Subject: IIS site works slow.
| Date: Tue, 21 Oct 2003 09:31:04 -0700
| Lines: 41
| Message-ID: <FD3363CC-64A4-4657-BAC8-36B45BEFB4A3@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.inetserver.iis
| NNTP-Posting-Host: TK2MSFTCMTY1 10.40.1.180
| Path: cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.iis:280587
| X-Tomcat-NG: microsoft.public.inetserver.iis
|
| Hi,

Pls guide me in solving the below issue..



Our site sometimes is working too slow and sometimes it works fine,Its is java with sqlserver as backend.

Its in OLTP for banking ..web enabled.

Server Config is as under



Db Server. + Appl Server (Javaw)

----------

Db Size is : 6 gb

Server : Compaq Proliant ML350 G2

CPU : Intel PIII 1.133 GHz * 2

Ram : 2 GB (512*4)

3 * 36.4 GB 10K U3 HP

1.174 TB (6 x 146.8 GB 1² with standard internal hot plug drive cage + (2 x 146.8 GB 1² ) with optional ML3xx Internal Two Bay Hot Plug SCSI Drive Cage)



Log and Data files are on same hdd : Raid Level 5..



Web server : Same config with JRun and IIS.(also some schedules running on which hits db after every 10 mins in jave for email etc)



We are unable to trace the issues...site sometimes is dead..and sometimes works fine.



I check db proc's and indexes..it is not proper and sometimes one or two processes are getting blocked(but this happen in 3-4 days)...Usuage of tempdb is
also high..but we had schedule our processes which truncates tempdb time to time..I had advised some indexes + optimzied most of the procedures..(this is
in test server)



---

and after all we had installed OS + IIS of web server..WE HAD CHECKD ONE THING..WHEN SITE IS SLOW ITS WORKING WITH JRUN(DIFFT PORT)
BUT WITH IIS ITS DEAD SLOW...

They are uusing xml with Jsp and java...

--

as Per perf counter of db server: Cpu usage is low,full scan / sec(sometimes its high around 6+),pages / sec =2 or 3/recompile / sec(always 0.00123...etc))





pls help me ..in solving the following issues.



1) We r not able to figure out whether db is slow or is there any db server issues...(optimzied queries and indexes are still on test server)

2) is there any web server issues..wot things we need to check with IIS/Jrun or java..

3) If there is any deadlock or blocking session on one procedure..will it hamper the performance of entire site or only web pages or processes related with
the tables used in procedures becomes locked and slow...

4) Is it advisable to restart sql server..this thing clients DBA are doing more often whenver sites becomes slow...or may be webserver ..and after this they
found site works fine.





Pls help me in finding solution or forward to concerned expertise persons.

WE ARE TRYING TO FIGURE OUT PROBLEM FROM LAST 10 DAYS BUT FAILED...
|