question

IZHAKDAVID-4062 avatar image
0 Votes"
IZHAKDAVID-4062 asked DSPatrick answered

experiencing significant performance issues with Project Server 2019.

We are experiencing significant performance issues with Project Server 2019.
One of our primary suspects is an internal permission system Microsoft has implemented that defines the list of Projects a user can access.
During times of performance deeps we are seeing very slow performance of INSERT statements to a custom type created by Microsoft:
CREATE TYPE UniqueGuidArray AS TABLE (
[Item] [Uniqueidentifier] NOT NULL,
PRIMARY KEY CLUSTERED
(
[Item] ASC
)WITH (IGNORE_DUP_KEY = OFF )
)
GO

These INSERT statements can number up to several thousand statements and are performed one by one (by Microsoft). We've seen it taking over 1 min at some cases.
Since this is a Type created by Microsoft as a part of the product and is used in over 40 different procedures,
We cannot alter the code itself (in favor of other solutions like using a table) and are looking for any solution
That can improve performance of the type itself without altering the subsequent procedures.



not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Office Project is not currently supported here on QnA. The product group for Project actively monitors questions over at
https://techcommunity.microsoft.com/t5/project/ct-p/Project

--please don't forget to Accept as answer if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.