Installing a clustered SQL 2012 instance is extremely slow

  • Wonder if anyone has experience installing SQL 2012 on an existing Windows 2008 R2 cluster with several SQL 2008 R2 clustered instances already installed.

    Installation takes over 4h! GUI wait between screens is up to 10 minutes. When checking the installation logs I can see setup verifying and re-verifying all kinds of things (disks, names...) related to the instances already present.

    Never experienced this with 2008R2. I know SQL 2008R2 clustered install has a "delay" issue when using mount points (HF available btw)but this time it's really frustrating

    Maybe I'll try using the cmdline and a config file. Any other suggestions?

  • Is any other process running on server in parallel. I hope you have the instalables placed on local drive rather than on network. Hows the cpu usage and memory utilisation on server look like..

  • hi,

    installing on the passive node. Nothing running whatsoever. I always reboot before starting any upgrade or installation (call me paranoid :))

    CPU, network util, memory => ok, the system is really idle.

  • Is the problem solved?

    I've just encounter the same issue

    Cluster is Windows Server 2012 R2

    SQL 2012 /w SP1

    There are warnings about single network adapter, but other are all fine

    Until the step to enter service accounts details, after I enter the DB engine service account, and click the to the other box to enter the Agent service account name, I need to wait 4-5 minutes before I can type anything, then after I entered both passwords of the accounts and clicked next, I need to waits for 15+ minutes.

    At the page to configure driver to store data and log, each click between options need to wait for 4-5 minutes

    We then stopped here. Then we tried to install SQL 2008 R2, very smooth to finish.

    any hints for this?

  • Hi Andrew,

    no, not solved 🙁

    I thought I was the only one experiencing this issue... The only difference I see is you're running a cluster based on Win 2012. So we can rule out the OS version.

    I'll be doing some tests in the near future. If I find anything I'll post it here.

    Regards

    Thierry

  • you have to update statistics on all tables with full scan after a version upgrade, or restore of a database from a lower version to a higher;

    the statistics are treated differently and the new optimizer needs them to be updated.

    a quick script like this can help:

    DECLARE @Exec VARCHAR(MAX)

    SELECT @Exec = ''

    SELECT @Exec = 'UPDATE STATISTICS '

    + QUOTENAME(schema_name(schema_id))

    + '.'

    + quotename(name)

    + ' WITH FULLSCAN ; '

    + CHAR(13) + CHAR(10)

    + @Exec

    FROM sys.tables ORDER BY name DESC

    PRINT LEN(@Exec)

    PRINT @Exec

    EXEC(@Exec)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Lowell,

    this thread is about installing a clustered SQL instance, not about querying...

    Chrz

    Thierry

  • Hm.

    This sounds familiar to a SQL install problem i once had with a large (16 CPU) HP server.

    I ended up disabling all but 1 quadcore CPU until the initial install was done.

    Maybe this will help?

    grtz,

    Theo

  • Thx for the tip Theo. I'll try this out next time I need to install a fresh instance.

  • thierry.vandurme (10/24/2013)


    Wonder if anyone has experience installing SQL 2012 on an existing Windows 2008 R2 cluster with several SQL 2008 R2 clustered instances already installed.

    Installation takes over 4h! GUI wait between screens is up to 10 minutes. When checking the installation logs I can see setup verifying and re-verifying all kinds of things (disks, names...) related to the instances already present.

    Never experienced this with 2008R2. I know SQL 2008R2 clustered install has a "delay" issue when using mount points (HF available btw)but this time it's really frustrating

    Maybe I'll try using the cmdline and a config file. Any other suggestions?

    The install will perform a full cluster validation as does an SP too. With multiple nodes and instances already installed it could take a short while.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Hi Perry,

    the difference between installing an extra SQL 2008 R2 instance (about 1h) or an extra SQL 2012 instance (about 4h) is out of proportion though.

    Chrz

    Thierry

  • Hi thierry

    Sorry that I misunderstood the OS

    it is Windows Server 2008 R2 /w SP1 cluster

    so it is the same version as yours

    and FYI

    I have previously installed a SQL 2012 (without SP1) cluster on a Windows Server 2012 (not R2) cluster and didn't have any problem

  • thierry.vandurme (12/30/2013)


    Hi Perry,

    the difference between installing an extra SQL 2008 R2 instance (about 1h) or an extra SQL 2012 instance (about 4h) is out of proportion though.

    Chrz

    Thierry

    are downloading any updates during the installer?

    If so uncheck the box and see if it's any quicker.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • ok, thx for the update Andrew

  • Perry, tried with and without updates, same issue unfortunately...

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply