The whole of last year was a struggle because sql server was acting up. Basically it would not utilize resources to scale up properly and used to choke in certain queries.
Even though we optimized to the max, the condition remained the same forcing me to think whether there is anything more which could be done in SQL.
Not anymore!
After installing SP2, I see tremendous improvement in scalability and performance. The site is running very well, and I am happy to move ahead to focus on improving the content, rather than fighting with SQL just to survive!!
- previously deadlocks used to bring down the entire database, now it is handled properly like Oracle does.
- previously long running queries used to bring down the entire database, now that is handled in a much better way.
Even though we optimized to the max, the condition remained the same forcing me to think whether there is anything more which could be done in SQL.
Not anymore!
After installing SP2, I see tremendous improvement in scalability and performance. The site is running very well, and I am happy to move ahead to focus on improving the content, rather than fighting with SQL just to survive!!
- previously deadlocks used to bring down the entire database, now it is handled properly like Oracle does.
- previously long running queries used to bring down the entire database, now that is handled in a much better way.
No comments:
Post a Comment