SQL Server Performance Forum – Threads Archive

Page Loading Problem

Hi, I am using tomcat 4.12 and jdk 1.4.0.. sql server 2000 is the back end. when we accessing our application contionusly for more than 4 days, each page takes time to load.. I was looked out both java and sql server usage. sometimes both usage were high. sometime it was decreased… once i restarted the tomcat and sql server then page loads normally. after few days same problem happens. is this because of tomcat problem or in sql server problem?

This is a pretty unusual configuration you’re running there. We definitely need more informations and I would ask parallel on a Tomcat community. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

Run the profiler and see if anything leads to Deadlocks Refer this also
http://www.mindsdoor.net/SQLAdmin/sp_nrInfo.html Madhivanan Failing to plan is Planning to fail

Hereby i am sending the server.xml for our application named sample <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" docBase="sample" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/sample" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="samplelogs." suffix=".txt" timestamp="false" verbosity="0"/> &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />arameter name="context.param.name" override="false" value="context.param.value"/> <Ejb home="com.wombat.empl.EmployeeRecordHome" name="ejb/EmplRecord" remote="com.wombat.empl.EmployeeRecord" type="Entity"/> <Environment name="maxExemptions" override="true" type="java.lang.Integer" value="15"/> <Resource auth="SERVLET" name="jdbc/EmployeeAppDb" scope="Shareable" type="javax.sql.DataSource"/> <Resource auth="Container" name="mail/Session" scope="Shareable" type="javax.mail.Session"/> <ResourceParams name="jdbc/EmployeeAppDb"> &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />arameter> <name>user</name> <value>sa</value> </parameter> &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />arameter> <name>driverName</name> <value>jdbc:HypersonicSQL<img src=’/community/emoticons/emotion-2.gif’ alt=’:d’ />atabase</value> </parameter> &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />arameter> <name&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />assword</name> <value></value> </parameter> &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />arameter> <name>driverClassName</name> <value>org.hsql.jdbcDriver</value> </parameter> </ResourceParams> <ResourceParams name="mail/Session"> &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />arameter> <name>mail.smtp.host</name> <value>localhost</value> </parameter> </ResourceParams> <ResourceLink global="simpleValue" name="linkToGlobalResource" type="java.lang.Integer"/> </Context> <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by FrankKalis This is a pretty unusual configuration you’re running there. We definitely need more informations and I would ask parallel on a Tomcat community. – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> <hr height="1" noshade id="quote"></blockquote id="quote">

Consider running a trace on the SQL Server to see what’s going on there. Check this site on how to set up a trace. Or see if these links will help:
http://msdn.microsoft.com/library/d…us/dnsqlmag01/html/TrackingDownEventClues.asp
http://www.winnetmag.com/SQLServer/Article/ArticleID/43014/43014.html
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/SQLTrcRpOb.asp Since I don’t use Tomcat I don’t know if there are similar profiling or monitoring feature, but I would check this, too. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

]]>