RE: Project issues list load time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hi Jay,
\par
\par Nice to hear back from you.
\par
\par If only certain sites have this problem, then you should only remove/restore those specific sites.
\par
\par There are a number of root causes that may only be determined though forensic research involving the event, iis and transaction logs from the system. Rebuilding the sites is the fastest resolution.
\par
\par Best,
\par Dana
\par
\par
\par Dana Brash [MSFT]
\par
\par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
\par ====================================================
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par
\par \pard\li720 --------------------
\par Thread-Topic: Project issues list load time
\par thread-index: AcX1IkekvQKKZSk+TwOK6CWpU+kqew==
\par X-WBNR-Posting-Host: 204.4.13.72
\par From: =?Utf-8?B?SmF5?= <fjm@xxxxxxxxxxxxxx>
\par References: <C50653DC-3097-4026-9AE1-DF42271CF7AA@xxxxxxxxxxxxx> <E#LvWU23FHA.2984@xxxxxxxxxxxxxxxxxxxxx>
\par Subject: RE: Project issues list load time
\par Date: Tue, 29 Nov 2005 12:20:02 -0800
\par Lines: 104
\par Message-ID: <FF951FE6-1339-47D0-897A-19AC2081E5EB@xxxxxxxxxxxxx>
\par MIME-Version: 1.0
\par Content-Type: text/plain;
\par \tab charset="Utf-8"
\par Content-Transfer-Encoding: 7bit
\par X-Newsreader: Microsoft CDO for Windows 2000
\par Content-Class: urn:content-classes:message
\par Importance: normal
\par Priority: normal
\par X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
\par Newsgroups: microsoft.public.sharepoint.teamservices
\par NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
\par Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
\par Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sharepoint.teamservices:22809
\par X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par
\par Are you speaking about delting just the offending sites and then using
\par stsadmin to restore just those sites or removing all sites and restoring them?
\par
\par We add one to two projects weekly to the server so the issue is not in the
\par creation of new sites but in the sites for certain projects. I found that
\par the ones affect seem to have a fairly large number of Issues in the list.
\par However there are some other projects with large Issues list that aren't
\par affected. In your experience what is the general cause of this. I would say
\par that if there is some record limit that is impacting performace it should
\par occur with all large Issues lists not just certain ones.
\par --
\par Jay, MCP
\par
\par
\par ""Dana Brash"" wrote:
\par
\par > Hi Jay,
\par >
\par > I understand from your other post that you have been unsuccessful in
\par > finding the microsoft.public.project and microsoft.public.project.server
\par > newsgroups. As the Issues list is specific to Project Server, this would
\par > generally want to get posted in the Project NGs, but I'm happy to work with
\par > you on the problem here.
\par >
\par > From your description, it sounds like you've eliminated PWA and network
\par > issues from the equation, and you've isolated it to just the issues list
\par > running locally on the WSS server, accessed through the Project Workspace
\par > URL directly.
\par >
\par > It seems also that this is not a universal behavior, but is isolated to
\par > specific project workspaces' issues lists. Have you tested publishing a
\par > new project, letting the workspace get automatically created or manually
\par > creating a workspace for it (depending on your settings) then adding an
\par > Issue to the new workspace's Issues list? Do you experience the same delay
\par > in behavior here?
\par >
\par > As this problem is limited to specific sites, the fastest resolution is to
\par > backup the sites and restore them using stsadm.exe. This will overwrite
\par > all the information in the site and should improve the performance. Please
\par > refer to the WSS Administrator's guide for instructions on using stsadm
\par > backup and restore.
\par >
\par > Windows SharePoint Services Administrator's Guide
\par > http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-
\par > a6a4-3e33fa13d230&DisplayLang=en
\par >
\par > Please let me know if restoring the sites doesn't resolve the issue.
\par >
\par > Best regards,
\par > Dana
\par >
\par > Dana Brash [MSFT]
\par >
\par > When responding to posts, please "Reply to Group" via your newsreader so
\par > that others may learn and benefit from your issue.
\par > =====================================================
\par > This posting is provided "AS IS" with no warranties, and confers no rights.
\par >
\par >
\par > --------------------
\par > Thread-Topic: Project issues list load time
\par > thread-index: AcXe9MvqWxuCFllVQkmxqquLuOIQzg==
\par > X-WBNR-Posting-Host: 204.4.13.72
\par > From: =?Utf-8?B?SmF5?= <fjm@xxxxxxxxxxxxxx>
\par > Subject: Project issues list load time
\par > Date: Tue, 1 Nov 2005 06:59:02 -0800
\par > Lines: 19
\par > Message-ID: <C50653DC-3097-4026-9AE1-DF42271CF7AA@xxxxxxxxxxxxx>
\par > MIME-Version: 1.0
\par > Content-Type: text/plain;
\par > \tab charset="Utf-8"
\par > Content-Transfer-Encoding: 7bit
\par > X-Newsreader: Microsoft CDO for Windows 2000
\par > Content-Class: urn:content-classes:message
\par > Importance: normal
\par > Priority: normal
\par > X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
\par > Newsgroups: microsoft.public.sharepoint.teamservices
\par > NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
\par > Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
\par > Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sharepoint.teamservices:3518
\par > X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par >
\par > This is the Third time I've posted this.
\par > On certain projects the Issues page takes 60-80 seconds to load the issue
\par > then another 60-80 secs after you click the edit button before you can edit
\par > the issue.
\par >
\par >
\par > It doesn't matter whether you display the "Issues Page" inside PWA or
\par > whether you go directly to the WSS link the response is the same. In fact
\par > i've RD'd into the physical server and viewed them right from the browser
\par > in
\par > the console with the same results... so it's not a network related issue.
\par >
\par > BTW all servers (Project Server, SQL and WSS) reside on the same physical
\par > server.
\par >
\par > I posted this on the non-managed groups over a month ago with no results.
\par >
\par >
\par > --
\par > Jay, MCP
\par >
\par \pard
\par
\par }