Need a little help. How can I design a report that will basically outline a baseline performance for our Orion DB? Any SQL guru's out there can help me on this one? I need this to have a better idea where our performance weak points are. Any help and guidance to build this report would be great. Or if you have one you use and wouldn't mind sharing please send it my way.
Better yet if this can be accomplished through a SolarWinds report even better. I'm new to the company I work for and have currently only limited access to sql myself. So I can't run anything that would require any kind of elevation on sql otherwise it won't let me run it.
Seoncdly, Speaking again to SQL guru's out there. What are key parameters or config's within SQL I should focus on that provides the best performance benefit for SolarWinds? For example we recently set parallelism which was set to zero. Set up a couple other parameters which where all defaults. Can anyone with a rock solid fast DB share some insights how you managed to get your sql to perform right?
We have a big SQL project on going to improve SolarWinds DB. But it's requiring proof in order to get the approvals we need to put through the changes we need to put through. And stats that management currently has does not warrant a change being needed. So we need to provide correct information that will show otherwise.
Could really use any SQL help I can get. The more through and detailed help the better. Thanks in advance.
A little about our setup. We are small relatively speaking. around 8000 nodes and one poller. We do have an HA pool 8 licensed modules an additional web server and a pool for the additional pollers currently sitting idle.
SQL has 8 vCPU's. Due to SQL core license SQL team will not go above this as they don't have the license and tell me it'll cost over 100k to get additional cores to the license which is an automatic rejection currently.
60 Gig's of ram.
One LUN and all disks on this same lun. (We do have an approved change in a few weeks to fix this up).
Any other information you need just let me know.