Need help with tool recommendation and monitoring

[kreinafine2]

Greetings,



Just to let you know, i'm not a DBA. I'm a SA. The issue is that our new DBA is spiraling down a hole fast and is becoming almost paralyzed with issues arising.

Before our new DBA came on board a few months ago, we had a tool called Solarwinds DPA that was monitoring our main database servers/databases. It seemed to work pretty good, but we were out of support. The new DBA came on and said basically we NEED this tool called dbForge to replace it. Well..they presented the case to management and got it. Long story short is that now we are having issues with our main/biggest database server and this dbForge is showing everything as fine. I asked our DBA about historical data to show long running queries, IO, etc.. to see the trouble spots when they are happening, and they said that dbForge is basically close to real-time and doesn't provide historical data. So we were not happy about this.

My question is if you guys can recommend a good tool that would let us analyze the databases using historical data to show everything that has been happening for a set amount of time or such? What do you guys use? We may look at DPA again, but if there is better out there I would love to know. Also, maybe the DBA is wrong with dbForge and historical data? I took a look around and from what I can tell they are right in that it doesn't. Could be wrong though.

My second question is on Windows performance monitoring. I am going to setup a performance monitor on another server to monitor this database server. What should I all include to get a good overall picture. Also, I know SqlServer will try and take all available RAM. Is there a way we can tell from perfmon or such, what it is really using or no?



Thanks

_____________________________________

my issue has been solved!!

______________________________________

[alexa]

We recommend you to review dbForge Studio for SQL Server https://www.devart.com/dbforge/sql/studio/download.html