SQL server performance – my favourite quote

Oopps! Upgrade your browser pretty please.Oopps! Upgrade your browser pretty please.

My favourite quote when it comes to SQL server performance is:

”a bad SQL server query sent by the application can consume all the hardware resources avaliable, no matter how much you have” – Grant Fritchey, SQL server 2008 Query performance distilled.

With that said, adding more hardware is waste of money if you don’t focus on SQL server performance when you write your T-SQL code or design your database. In some cases it may be easy to fix with an index or simple rewrite, but in many cases it is a time consuming process. Our SQL server consultants are very experienced in finding and eliminating performance bottlenecks, feel free to contact us if you need some help.