Connecting and working with SQL server in SSMS without WMI is extremely slow.

  • SystemlordAnubis

    Old Hand

    Points: 364

    Hi All,

    I have a slightly weird situation; on one PC that is domain connected, opening SSMS and connecting and working in the server is fast and responsive.  Through this PC, there is ICS (internet connection sharing) enabled to expand this connection to other PC's in the local network (this ICS is required, I can't get away from that unfortunately)...

    For all other PC's on the local network, they don't have WMI capability to the server (they're not domain connected) and they have the little blue question mark on the server icon once connected.

    However, connecting to the server and working with the server is extremely slow; it can take up to a few minutes for objects to load or queries to run, but performing the same actions on the domain connected PC is fine.

    I can only deduce that the slowness has something to do with ICS (however this should just be passing traffic) but given WMI isn't working, I'm wondering if this could be part of the issue.

    The SMSS version I've tested is both 18.6 and 18.4

    Has anyone encountred any issues like this before - but more importantly, does anyone know how to resolve?

    Thanks

    Anubis.

  • SystemlordAnubis

    Old Hand

    Points: 364

    Hi All,

    The issue has been resolved due to a routing configuration problem in the local network behind the PC with ICS; after correcting the routing, all PC's respond normally.

    Thanks

    Anubis.

  • Grant Fritchey

    SSC Guru

    Points: 396716

    Happy you found the answer to the issue.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply