My Oracle Support Banner

P6 Database on SQL Server is Slow to Respond on Connect and SSMS Log Shows "Starting up database" Repeatedly (Doc ID 2678583.1)

Last updated on JUNE 09, 2020

Applies to:

Primavera P6 Professional Project Management - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When making connections to a P6 database that is created in SQL Server, performance is bad.  Also, if multiple P6 databases are on the same SQL Server instance, these other databases are constantly showing poor performance.

In the SQL Server Management Studio log files, the following message is repeated very frequently:

"Starting up database <database_name>"


EXPECTED BEHAVIOR

P6 databases should not perform in this manner on SQL Server.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.