nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Does Solarwinds support SQL DB on SAN storage

Dfarinsky

Hello,

This is my first posting and I'm new to both Solarwinds and SQL. We are in the process of building the SQL server and I need to know if Solarwinds support the SQL database on a SAN?

Thanks!

Find more posts tagged with

separate_db_server

sql

san

Accepted answers

njoylif

I'm running netflow, orion, and NCM on the same DB, as well as some other app's DBs. it is 4 proc/8 core, 32 GB RAM (only using 8-10) and cpu usage is pretty low. I am connected to SAN, and we did run into problems a while ago, but it was resolved by simply configuring the SQL DB memory to utilize AWE.

Test this and you will probably see marked improvements.

All comments

FormerMember

Sure does. So long as the SQL server is concerned, the disk the DB's sit on is local so Solarwinds could care less.

Dfarinsky

Thanks! This is my first install and we are putting the SQL DB on a dedicated server and the question about local disks or SAN disk was onoe issue. Also we are stuck at this time using VMWare server for the polling platform...

jeff.stewart

Keep your SQL off your Orion boxes like you have planned. Also, no VM for the SQL server, but it is fine to run the polling engines on VM. You're in the right place to ask these questions. Good luck!

Debbi

Was told recently this is still a no-no by SW. ??? -Debbi

jkeberle

Using a VM for your polling server will work as long as you have a very minimal ammount of Elements. You will find that Orion will quickly swamp your VM and your entire VM Host (if allowed) if you greatly increase the ammount of elements that you are monitoring. If you stay under 500 or so elements and you have a relatively new host for your VM you should be good.

I agree with Solarwinds however that this should be a no-no due to time slicing and other issues with VMs.

Dfarinsky

Thanks for the reply!

warbird

Hello again. I wanted to follow up on this. I have moved our SQL db to a SAN and things are working extremely well. Granted, it is a very 'beefy' SAN but still, the performance is amazingly better. The only problems I can see from doing this is if you overload your SAN. In other words, it is hardware dependent and also dependent upon your layout/situation.

I am even running NTA now, which was unheard of before. They are looking at a strange memory error in NTA but once that is resolved, we should be good to go.

Thanks again for asking this question and for all the suggestions/answers!