October 24, 2013 at 3:01 am
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?
October 26, 2013 at 7:54 am
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..
October 27, 2013 at 3:21 am
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.
December 24, 2013 at 1:07 am
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?
December 24, 2013 at 2:32 am
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
December 24, 2013 at 5:20 am
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
December 24, 2013 at 7:56 am
Lowell,
this thread is about installing a clustered SQL instance, not about querying...
Chrz
Thierry
December 24, 2013 at 8:03 am
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
December 27, 2013 at 5:44 am
Thx for the tip Theo. I'll try this out next time I need to install a fresh instance.
December 29, 2013 at 1:22 pm
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" 😉
December 30, 2013 at 12:59 am
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
December 30, 2013 at 1:05 am
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
December 30, 2013 at 1:32 am
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" 😉
December 30, 2013 at 1:58 am
ok, thx for the update Andrew
December 30, 2013 at 1:58 am
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