SQL Server installation duration concerns

Question

During the installation of SCCM baseline 2403 on Windows Server 2022 with SQL Server 2019, the process takes nearly 2 hours at the step "Setting up the SQL Server database."

Is this duration typical for such installations? Could there be any configuration issues causing this delay?

Answer 1

I cannot definitively answer your question, since I so rarely install CM from scratch; but I can say in my experience doing upgrades, it depends upon the size of the DB to be upgraded. Since you seem to indicate that this is a brand-new installation, no CM clients at all, I suspect that my previous experience is not relevant in this scenario.

IMO, though--does it finish? If it finishes, I'd simply call that a win, overall, lol.

If this is your repetitive job, something you do multiple times a month (setup and configure CM on new servers), it is possible to powershell the entire setup; with minimal inputs (like license keys and such); I know of several consulting firms which have that in their arsenal. For inspiration, look at the various blogs regarding 'automating a lab setup', which can point you in the right direction for automating the install.

It is possible that perhaps you have mis-configured a pre-requisite, making the install take longer than 'normal' (again, keeping in mind that I personally do not know what normal is, when it's server 2022, sql 2019); there are of course other factors that could be in play: speed of your disks, memory (total, and allocation that you have assigned to SQL, other configurations I cannot think of as I type).

Answer 2

Hi, @woo hada

Thank you for posting in Microsoft Q&A forum.

The installation duration of nearly 2 hours for setting up the SQL Server database during the SCCM installation does seem longer than typical, there are a few factors that could contribute to such delays:

1. SQL Server Configuration: Ensure that the SQL Server instance is configured correctly. For example, using non-default installation directories can sometimes lead to longer setup times if not managed properly.
2. System Performance: The overall performance of the server, including CPU, memory, and disk speed, can significantly impact installation times.
3. Database Size and Complexity: If the database being set up is particularly large or complex, this could also extend the installation duration.
4. Concurrent Processes: Other processes running on the server during installation may affect the time it takes to complete the setup.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".