Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Best Practices - SQL Configuration

Getting ready to setup a new SQL server for Orion/Netflow and I was wondering if SW or any members had and good information on setting up SQL to perform its best with Orion/Netflow. I'm not SQL expert so any advice would be great. Thanks.

Find more posts tagged with

Accepted answers

All comments

FormerMember

We recommend RAID 1.0 and to use Disk Controllers with battery-backed up write-back cache.

msdn.microsoft.com/.../aa217083(SQL.80).aspx

jeff.stewart

Thanks Denny, got the HW setup how you all recoommend. On to the SQL now.

wwiley

I would like to know this as well. We are having some serious performance issues with our SQL server and it seems to be directly correlated to NetFlow 3.0. When NetFlow is running, our SQL server sees a 40% hike in CPU utilization. I have a case open in regards to it now.