[SQL 2012] Upgrade the Sql server 2005 Instance to Sql Server 2012. |
- Upgrade the Sql server 2005 Instance to Sql Server 2012.
- SQL Server Agent 2012 - Slow on startup and closure
- Hotfix Fails with "Could not write value SupportFiles to key..."
| Upgrade the Sql server 2005 Instance to Sql Server 2012. Posted: 01 Apr 2013 11:46 PM PDT Hi,can we run the SQL Server 2012 at Production Instance or is it still in the testing phase.Can we upgrade the SQL Server 2005 Instance Directly to SQL Server 2012 Instance.What are the points we need to take care at the time of upgradation.Is anything in the Code(SP/UDF/View Script), we need to change which is not supported in SQL Server 2012.Can we deploye the same SSIS 2005 Packages to SSIS 2012 Packges. Is anything changed in the SSIS 2012 from SSIS 2005.Thanks & RegardsNitin Varshney. |
| SQL Server Agent 2012 - Slow on startup and closure Posted: 01 Apr 2013 09:29 PM PDT Dear SQL users, Since couple of weeks we've been working with [b]SQL Server 2012[/b] (Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Standard Edition (64-bit) (Build 7601: Service Pack 1). We still have our old production centre which works on SQL Server 2005. The problem lies within the SQL Server Agent, all Agent settings are similar to our good working 2005 environment. A simple job with single t-sql step 'select @@version' takes over [b]40 seconds [/b]in 2012 and < 1 second in 2005 environment. Running the query in 2012 query window it has the same (expected) performance of < 1 sec.What is it that makes the 2012 Agent so slow? Interesting is that the job step takes 6 seconds and the total job takes 40 seconds.[b]Any ideas??[/b]Thanks in advance, Gr. Erik |
| Hotfix Fails with "Could not write value SupportFiles to key..." Posted: 01 Apr 2013 07:16 AM PDT I tried to apply a hotfix on my PC to fix a bug ([url]http://support.microsoft.com/?kbid=2793634[/url]). It failed with errors such as "Could not write value SupportFiles to key \Products\F3170BC80EFCD544CB2B35485668E0A1\Features. Verify that you have sufficient access to that key, or contact your support personnel". I am a local admin on my PC. Any ideas? My computer is running Windows 7 Professional SP1. I currently have SQL Server 2012 SP1 installed (11.0.3000).Thanks! |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment