July 31st, 2012, 05:50 PM
Improve MS SQL Performance
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?
August 1st, 2012, 04:29 AM
I would always make sure I run with the newest update.
But I still have my doubt that alone will solve you problem.
What kind of web application do you test? how did you test it?
When do you notice the performance degree? what is "at some point"?
Have you looked at the system itself (e.g. for sufficient RAM) or the queries you use.
Last edited by MrFujin; August 1st, 2012 at 04:34 AM.
August 1st, 2012, 09:16 PM
Thanks for your reply.
Originally Posted by MrFujin
I decided to spend more time in analyzing and tuning my existing db.
I'll run perfmon and etc to narrow down the issue.