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.
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.
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?
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.
Uninstall the evaluation servers. You're going to keep hitting issues around that.
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.
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 ??
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? ;-)
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.
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
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.
18 People are following this question.
