question

Troy_2012 avatar image
Troy_2012 asked

Upgrde from 2008R2 to SQL Server 2012

Dear all, We have already installed evaluation instances of SQL Server 2008 R2 on multiple servers with Mirror technique, now our instances are expired and we bought the licenses for SQL SERVER 2012, what is the best practice to our servers 1- uninstall all the sql servers and then install the new sql server 2012 with licenses. or 2-Upgrade the sql sever 2008R2 instances to SQL server2012 with licenses.
sql-server-2008-r2sql-server-2012upgrademirroring
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you everyone... tomorrow I will make my decision
0 Likes 0 ·
For all answers that are helpful, please indicate this by clicking on the thumbs up next to those answers. If any one answer solved your problem, please indicate that by clicking on the check mark next to that answer.
0 Likes 0 ·
Tim avatar image
Tim answered
I always prefer a clean install of SQL Server verses and in place upgrade. If you are installing on virtual servers I would ask for a new virtual and install SQL 2012 instead of an uninstall of 2008R2 or an upgrade of 2008R2. Microsoft allows for the in place upgrade and that process works well for many, however I personally prefer the cleaner approach to rule out any lingering old registry settings, old dll's, etc. Are you wishing to retain anything you created with the eval versions?
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You can easily script out the user objects and run those scripts against the new 2012 install. As for mirroring, I am not sure even if you did an in place upgrade that mirroring would upgrade and still work. It might be one of those things you have to reconfigure regardless. From experience with trying in place upgrades from 2000 to 2005, 2005 to 2008, you are much better off doing a clean install. Less worries going forward that anything old is causing you issues.
1 Like 1 ·
No,we don't have anything to retain, But I don't like to do the configuration again to the network with the domain controllers and mirror technique and the permission to the users.
0 Likes 0 ·
Ok,what is the best way to clean the installation of the old sqlserver,because I don't want to format the windows,and sometimes some fatures still in the server even though it uninstall
0 Likes 0 ·
If you can't wipe and reload the server then an uninstall is the best option. I know there are register cleaner apps out there but I think they do more harm than good. Just go with an uninstall of 2008R2 Eval and install your 2012.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Uninstall the evaluation servers. You're going to keep hitting issues around that.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Regardless of eval or regular licensed edition and upgrading. I will always advocate clean installs vs. upgrading. Obviously you and your organization must decide the best path forward.
1 Like 1 ·
Could you please give some example about the issues that will appear?
0 Likes 0 ·
If you do an inplace upgrade of an expired evaluation, I've seen and heard about licensing issues popping up at the time of upgrade or even after upgrading. Evaluation servers are good for testing, but I wouldn't put a final configuration on them and upgrade them.
0 Likes 0 ·
Troy_2012 avatar image
Troy_2012 answered
Dear, our servers have one week to expire , so now the suggestion are different : 1- how to install the licenses. on these servers .. as I mentioned the company bought the sql server 2012 can I use it to upgrade the instance(sqlserver 2008r2) from evaluation to licenses.If yes how can I do that ??
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Look on it as a test exercise too - use it to test the documentation you wrote when building the first system to see that it can be used to build the new one. You *did* document this, right? ;-)
2 Likes 2 ·
My suggestion, and I'm pretty sure @Tim, won't change. I wouldn't recommend upgrading from the eval to a non-eval and I wouldn't recommend an in-place upgrade to 2012. You'll have a much better experience, if more work, getting 2012 installed from scratch.
1 Like 1 ·
I'll absolutely second what @Grant & @Tim are saying. Start from scratch & it will have a much better outcome for you versus upgrading in place. Just my .02 on it though. ;-)
0 Likes 0 ·
Yes, still 100% in agreement that an uninstall and clean install of 2012 is the route to go. Might be more initial work, but is well worth it in the long run.
0 Likes 0 ·
Troy_2012 avatar image
Troy_2012 answered
Dear, I did the following steps:- 1-uninstall the SQL Server 2008R2. 2-Install SQLServer 2012. 3-when I open ths SSMS the SQL asked me there was an old configuration do yuo want to import it , They said Yes (I wasn't agree on this step),it's import the users in domain controller in sql securty. 4-attached the user databases.I checked the compatibility level (100 SQL Server2008).I didn't change anything. 5-I run the DBCC check to all the databases. 6- setup the mirror technique on the database user(CRRDDB). But when they stared to use the SW to input the data, the operating was very slow(before that it was very fast),and the users sign out becz the timeout for the session that used in SW. I create many counters to read the performance of the sql server and I found :- **\Process(*)\% Processor Time : Min=0 Max=77 Avg=2** **% Privileged Time: Min=0 Max=27 Avg=0** **\Processor(*)\% Processor Time: Min=0 Max=6 Avg=1** **\System\Processor Queue Length:: Min=0 Max=2 Avg=0** **System High Context Switching:** ![alt text][1] Disk Counters: ![alt text][2] I checked that the administrate running the kaspersky antivirus on the db servers, so I asked him to stop it.after this step the server better but n't as fast as it was in the past with sql server 2008r2, Any suggestion ? Our Servers have 32G Ram,2 Processorer (10 core for each CPU) [1]: /storage/temp/957-\countersalert.jpg [2]: /storage/temp/958-\counter222.jpg

\countersalert.jpg (131.8 KiB)
\counter222.jpg (69.2 KiB)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

All statistics on all tables must be rebuilt after an upgrade, so initially, if you don't do that manually, it's pretty normal to see slow performance. But, over time that should go away. If it's not, then something else is going on. I would suggest looking to the wait statistics and queues to understand what's going on. Simply looking at CPU & Disk usage doesn't tell you anything about the performance.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.