susja July 31, 2012 at 15:27:23 Specs: Windows 2008 R2, 8/16 Gb
Hello, I'm using MS SQL 2008 SP3 as a back end in my performance testing of my web application. At some point performance degraded and analyses pointed that the bottleneck is my database. I have to improve performance and I'm thinking either 1. update MS SQL 2008 SP with cumulative packs or 2. upgrade it to MS SQL 2008 R2. Could you please advice if I should expect improve of performance by option 1 or option 2? Thanks P.S. Well ... one more question came to my mind: in case I decide to upgrade to 2008 R2 ... will it migrate/upgrade my existing databases as well?
I doubt that updating the software will address the underlying problem, whatever it is. Google "ms sql 2008 performance tuning" for information on how to analyse and improve the performance of your SQL Server.
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.