SQL Server performance is a hot topic these days, especially if you're leveraging your SQL Server for a high performance NMS. This can become even more critical when you add applications like NetFlow which tend to carry a significant I/O burden.
In some organizations you can rely on the DBA team to own/maintain/optimize the database servers for you. Unfortunaely, for many of us this isn't an option either because we dont' have a DBA team or because it's such a political mess trying to work with them. This causes us to have to implement and maintain our own database servers to support our apps.
The thing is, most of us network engineers don't know diddly about database servers. So, with that in mind, here are a few tips for optimizing your SQL Server:
Head Geek's Top 5 Tips for Improving SQL Performance
#5 - Add more RAM. Doesn't really matter how much you have, adding more will almost always help. Be sure that your SQL instance and OS are capable of consuming the additional RAM and if not make it so.
#4 - Just say "no" to RAID 5. It's great for application servers but horrible for database servers where I/O performance is important.
#3 - Place the data and log files (.mdf and .ldf) on separate logical drives and separate channels or controllers.
#2 - Unless your SAN is optimized for high I/O vs. large I/O stick with a locally attached disk arrary.
#1 - Buy disk controllers with battery backed-up write-back cache. The more the better, but at least 256MB.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.