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.
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?
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 ??
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] Disk Counters: ![alt text] 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) : /storage/temp/957-\countersalert.jpg : /storage/temp/958-\counter222.jpg