Users timing out when logging onto PWA

[Timothy Kidd]

Does anyone have any insight into this issue?
We have a 8 processor server used as a database server for project server
and we are using 3 IIS server for PWA front end.

This morning we experience an issue where users were unable to loggin
successfully; they would get timeout errors (all users). Other symthoms:
- Disk IO was at minimum (very little activity)
- Network bandwidth was not really used (almost no activity
- had about 220 process open in the database
- database itself had minimal locks/sec (around 200 pages lock request
consistently)
- overall cpu utilization was between 14%-18% but very consistent (not normal)
- very little updates or insert was being performed
- unable to use the management tool of SQL Server enterprise manager
(timesout)
- although i can use the query analyser (slow response but useable)

ANy help would be greatly appreciated

 

[Mike Glen]

Hi Timothy,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

 

[kix1956]

I know that you've been advised to post to another newsgroup, but I'll
see if I can offer any help with regards to your post. I would suggest
that you establish whether the delay is owed to the server hosting
Project Server and SQL or whether the delay is outboard of the server
on the network. One way to to this would be to establish another
virtual directory or site on the server to act as a test. Doesn't have
to be Project Server obviously, just some HTML will do. If that renders
on your browser, the likelihood of the network causing the delay is
reduced, and would point to the server, if that page too is slow to
render, I'd start suspecting a slowdown on the network. Another
alternative would be to use ipconfig, and ping the server and see what
the trunaround time is. From your description is doesn't sound as if
the server is out of gas by any means. Another thought is storage. You
didn't mention storage utilization. Could it be the starved for
storage. That could certainly slow down the operation of the storage,
although it wouldn't explain a sudden drop in storage. A suggestion
related to your post. Its always a good idea to indentify the window
O/S i.e. 2000, 2003, and the version of Project Server, and SQL server,
just in case it might be related to a software issue, or someone knows
of a utility that may be of help. Good luck, and I'd follow Mike's
advice and use the other newsgroup, you'll post will have more
visibility.