Have you ever removed a SQL Server database, and checked the box to remove the backup…
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.