Solved Improve MS SQL performance

Microsoft Sql server 2008 enterprise wit...
July 31, 2012 at 15:27:23
Specs: Windows 2008 R2, 8/16 Gb
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?
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?

See More: Improve MS SQL performance

Report •

August 1, 2012 at 00:51:44
✔ Best Answer
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.

Report •

August 1, 2012 at 19:05:25
thanks for reply,
I decided to try to tune my db server and see if it'll make the difference.

Report •

Related Solutions

Ask Question