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 Thank you for your reply and the detailed additional feedback on how you were successful in resolving this issue. Your solution will benefit many other users, and we really value having you as a Microsoft customer.
\par
\par If you have any other questions or concerns, please do not hesitate to contact us. It is always our pleasure to be of assistance.
\par
\par Have a nice day!
\par
\par Sincerely,
\par
\par Dana Brash
\par Microsoft Online Partner Support
\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 Business-Critical Phone Support (BCPS) provides you with technical phone support at no charge during critical LAN outages or "business down" situations. This benefit is available 24 hours a day, 7 days a week to all Microsoft technology partners in the United States and Canada.
\par
\par This and other support options are available here:
\par BCPS: https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
\par Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
\par
\par If you are outside the United States, please visit our International Support page: http://support.microsoft.com/common/international.aspx.
\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: AcYjWMaO6LWY6icRQcaAMvxx7sYZdQ==
\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> <FF951FE6-1339-47D0-897A-19AC2081E5EB@xxxxxxxxxxxxx> <3NsehoX9FHA.1240@xxxxxxxxxxxxxxxxxxxxx> <37DF98D8-D33C-43A3-BD00-665A14602090@xxxxxxxxxxxxx> <o5zUpn0FGHA.224@xxxxxxxxxxxxxxxxxxxxx> <B1BF1D94-673B-48B8-B524-1FB04EC76F52@xxxxxxxxxxxxx> <SpWTvkwGGHA.1240@xxxxxxxxxxxxxxxxxxxxx>
\par Subject: RE: Project issues list load time
\par Date: Fri, 27 Jan 2006 07:46:02 -0800
\par Lines: 313
\par Message-ID: <FA48D854-9F15-4BB9-B801-3F696DAB0E6A@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:22962
\par X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par
\par I backed up the database then stopped the SQL service last night and
\par defragged the file system. Then I restarted SQL and ran a script to reindex
\par the whole database. Then I rebooted the server to clear out anything that
\par might be sitting in memory. It looks like these steps resolved the issue.
\par My WSS load times have dropped from 40-60 seconds to 2-6 seconds. I found
\par the index fragmentation using dbcc showcontig. I plan on scheduling this
\par once a month to prevent an further performace issues.
\par --
\par Jay, MCP
\par
\par
\par ""Dana Brash"" wrote:
\par
\par > Hi Jay,
\par >
\par > Actually, I've not tried simply re-indexing the database. Because of the
\par > numerous possible issues, I generally skip right to the known resolution
\par > and recreate the site. It's the fastest and most reliable resolution. As
\par > always, make sure you backup your databases before doing anything,
\par > including re-indexing them.
\par >
\par > I appreciate that you've mentioned the imporatance of this project, and I
\par > would recommend that if visibility is high and the system is mission
\par > critical. If the issue is urgent to your business, it is recommended that
\par > you contact Microsoft Customer Support Services (CSS) via telephone so that
\par > a dedicated Support Professional can help you resolve your issue in a more
\par > efficient manner. Please be advised that contacting phone support will be a
\par > charged call.
\par >
\par > To obtain the phone numbers for a specific technology request please take a
\par > look at the web site listed below.
\par > <http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS>
\par >
\par > If you are outside the US please see http://support.microsoft.com for
\par > regional support phone numbers.
\par >
\par > Sincerely,
\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: AcYa2u15NI8CqRJTTyumjwXiQxmaGw==
\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>
\par > <E#LvWU23FHA.2984@xxxxxxxxxxxxxxxxxxxxx>
\par > <FF951FE6-1339-47D0-897A-19AC2081E5EB@xxxxxxxxxxxxx>
\par > <3NsehoX9FHA.1240@xxxxxxxxxxxxxxxxxxxxx>
\par > <37DF98D8-D33C-43A3-BD00-665A14602090@xxxxxxxxxxxxx>
\par > <o5zUpn0FGHA.224@xxxxxxxxxxxxxxxxxxxxx>
\par > Subject: RE: Project issues list load time
\par > Date: Mon, 16 Jan 2006 12:25:01 -0800
\par > Lines: 247
\par > Message-ID: <B1BF1D94-673B-48B8-B524-1FB04EC76F52@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:22934
\par > X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par >
\par > Actully we are planning on do a re-index of the Db to see if that speeds up
\par > the sites. We want to try this before going through the hassle of removing
\par > and reimporting in critical WSS sites for multi-million dollar projects.
\par > Have you had any success reidexing the WSS content Db to resolve speed
\par > issues?
\par > --
\par > Jay, MCP
\par >
\par >
\par > ""Dana Brash"" wrote:
\par >
\par > > Hi Jay,
\par > >
\par > > Just want to say Hi, and I was wondering how everything is going. If
\par > > anything is unclear, please let me know. It is my pleasure to be of
\par > > assistance.
\par > >
\par > > Hope this helps!
\par > >
\par > > Sincerely,
\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
\par > rights.
\par > >
\par > >
\par > > --------------------
\par > > Thread-Topic: Project issues list load time
\par > > thread-index: AcYSNYxmM0nqlKSNTQGkQARJv0OF9g==
\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>
\par > > <E#LvWU23FHA.2984@xxxxxxxxxxxxxxxxxxxxx>
\par > > <FF951FE6-1339-47D0-897A-19AC2081E5EB@xxxxxxxxxxxxx>
\par > > <3NsehoX9FHA.1240@xxxxxxxxxxxxxxxxxxxxx>
\par > > Subject: RE: Project issues list load time
\par > > Date: Thu, 5 Jan 2006 12:21:02 -0800
\par > > Lines: 171
\par > > Message-ID: <37DF98D8-D33C-43A3-BD00-665A14602090@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!TK2MSFTNGXA03.phx.gbl
\par > > Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sharepoint.teamservices:22904
\par > > X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par > >
\par > > Ok I will try the delete/restore approach and see what happens.
\par > > --
\par > > Jay, MCP
\par > >
\par > >
\par > > ""Dana Brash"" wrote:
\par > >
\par > > > Hi Jay,
\par > > >
\par > > > Nice to hear back from you.
\par > > >
\par > > > If only certain sites have this problem, then you should only
\par > > > remove/restore those specific sites.
\par > > >
\par > > > There are a number of root causes that may only be determined though
\par > > > forensic research involving the event, iis and transaction logs from
\par > the
\par > > > 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
\par > 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
\par > > rights.
\par > > >
\par > > >
\par > > > --------------------
\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>
\par > > > <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
\par > 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
\par > restoring
\par > > > them?
\par > > >
\par > > > We add one to two projects weekly to the server so the issue is not in
\par > > the
\par > > > creation of new sites but in the sites for certain projects. I found
\par > > that
\par > > > the ones affect seem to have a fairly large number of Issues in the
\par > list.
\par > >
\par > > > However there are some other projects with large Issues list that
\par > aren't
\par > > > affected. In your experience what is the general cause of this. I
\par > would
\par > > > say
\par > > > that if there is some record limit that is impacting performace it
\par > 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
\par > > microsoft.public.project.server
\par > > > > newsgroups. As the Issues list is specific to Project Server, this
\par > > would
\par > > > > generally want to get posted in the Project NGs, but I'm happy to
\par > work
\par > > > with
\par > > > > you on the problem here.
\par > > > >
\par > > > > From your description, it sounds like you've eliminated PWA and
\par > network
\par > > > > issues from the equation, and you've isolated it to just the issues
\par > > list
\par > > > > running locally on the WSS server, accessed through the Project
\par > > Workspace
\par > > > > URL directly.
\par > > > >
\par > > > > It seems also that this is not a universal behavior, but is isolated
\par > to
\par > > > > specific project workspaces' issues lists. Have you tested
\par > publishing
\par > > a
\par > > > > new project, letting the workspace get automatically created or
\par > > manually
\par > > > > creating a workspace for it (depending on your settings) then adding
\par > an
\par > > > > Issue to the new workspace's Issues list? Do you experience the same
\par > > > delay
\par > > > > in behavior here?
\par > > > >
\par > > > > As this problem is limited to specific sites, the fastest resolution
\par > is
\par > > > to
\par > > > > backup the sites and restore them using stsadm.exe. This will
\par > > overwrite
\par > > > > all the information in the site and should improve the performance.
\par > > > Please
\par > > > > refer to the WSS Administrator's guide for instructions on using
\par > stsadm
\par > > > > backup and restore.
\par > > > >
\par > > > > Windows SharePoint Services Administrator's Guide
\par > > > >
\par > > >
\par > >
\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
\par > > 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
\par > > > 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
\par > > 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
\par \pard
\par
\par }