If you are one of the thousands of users of our SolarWinds Products, or one the users of thousands of other products that use SQL for the back-end database, you already know that the importance of SQL performance cannot be overstated. Any application that interfaces with a database is only as fast as the database it uses. The good news for Microsoft SQL users is that there are a lot things you can do to make sure your SQL Server is a screaming machine. Here are some of my recommendations:
Just implementing 3 or 4 of these will have a huge impact on your SQL performance and the application using SQL for data storage.
For more tips, take a look at this Technical Reference on Managing Orion Performance.