PDQ, not realistic for large networks?

Comments

8 comments

  • Christian Bacher

    First, it's not my negative vote.

    Second, i think no one can help you, because no one knows your enviroment. Sure you mentioned a few thinks but every enviroment is individual and much more than this (and it is huge!) (16.2 was terrible slow because agent issues, 16.3 runs much better and stable now)

    But what i can say is, PDQ dosn't runs better because you double the cpu or ram. For a large enviroment like yours its sounds more like a DB question, i think SQLite it's not the right DB for this scenario.

    But you should try a SSD upgrade, maybe you can counteract the DB speed issues.

    ~Chris

    0
    Comment actions Permalink
  • Robert Basil

    I agree with you 100%. I also feel that it is an SQLite issue, but when I brought this up to PDQ support they said that their database structure should have no problems with a network of our size. That's why I was hoping to find any tips from possibly another customer using PDQ with a network of our size.

    0
    Comment actions Permalink
  • Chris James

    We agree with Christian's suggestion to try an SSD. Having a single spinning disk attempting to read and write to a database will quickly become a bottleneck. While SQLite is highly optimized for read operations, lesser priority read operations get put to the back of the queue while the database is being used for other tasks. Writing at that scale does present some issues, but we believe it shouldn't be an issue in most cases on the suitable hardware. We have had other customers with environments as large or larger make use of Inventory successfully. It does take some time to tweak the settings and plan your scanning/deployments to not bog down your network and server.

    0
    Comment actions Permalink
  • Benoit Heylens

    Maybe it is time for us, BIG company' sysadmins, to ask for a "real" DB that can handle better large-scale environments 😉 ?

    I am managing 40 sites, 1600+ pcs and 350+ servers for 3.000+ people and things start to get a bit sluggish when I try to accomplish too many things.

    That and the makingof different PDQ admin profiles (with read-only perms) would be awesome.

    1
    Comment actions Permalink
  • Robert Basil

    Chrisj,

    I'd be more than happy to try an SSD, BUT since this is not an option with our current Gen9 hardware this would require us to purchase a new server as everything we have that is not on a Gen9 run's on a VM (which is on a cluster full of Gen9's as well). There is no SSD option for our model of Gen9's.

    One thing to remember... The server running PDQ Inventory is TWICE the Server that we have currently running Manage Engine's Desktop Central (and it runs flawlessly using msSQL). DC is currently running both Windows and Third Party updates for our 25,000 endpoints and also keeps about 400 servers up to date. We just want to use PDQ Inventory because it seems to do a better job with it's reporting options.

    So... we run Manage Engine's Desktop Central we are fine with a spinning disk, but if we want to use PDQ Inventory it requires an SSD?

    Like Ben said above, when (if ever) can we expect PDQ to move to a real database option for it's larger customers (I'd be willing to pay extra for msSQL or mySQL support) so we don't have to purchase a server with an SSD to be able to use your software?

    PLEASE give us an option to use something other than SQLite You can call it the "realSQL Enterprise" version.

    Signed: Robert "Love your software, but your choice of a free / cheap database is hurting your larger customers" Basil

    1
    Comment actions Permalink
  • Christian Bacher

    Hi Robert,

    i know it sounds crazy but why you don't try somthing unconventional.

    • Grab a normal PC with a Intel i5/i7, 16-32gb Ram and a SSD

    • Put a LWL Networkcard in for better network performance or launch the test with the 1gb onboard NIC

    • Install Windows and PDQ Inventory and look how it runs

    If it runs smooth you can decide ....continue to use the i7 for Inventory ....Buy a new Server with a SSD

    or wait für a full supportet SQL DB 😉

    ~Chris

    0
    Comment actions Permalink
  • Tiele Declercq

    Does anyone know IF realSQL support is coming? Does PDQ have some feature voting mechanism?

    2
    Comment actions Permalink
  • plazar

    I have close to 60,000 end points and do see the console occasionally freeze, a full sql support is something we will need  

    0
    Comment actions Permalink

Please sign in to leave a comment.