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!
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.
Sure does. So long as the SQL server is concerned, the disk the DB's sit on is local so Solarwinds could care less.
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...
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!
Was told recently this is still a no-no by SW. ??? -Debbi
Thanks for the reply!
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!
