Sql server Express 2017 and ssms

  • kangarolf

    Hall of Fame

    Points: 3363

    Hi all,

    I've never used mssql express before but we had a small intranet project that it fits for.

    Tables are small and indexed.

    Whenever ssms is open all the queries run slow, both inside ssms and external queries. As soon as I close ssms all the queries are near enough instant.

    Database is accessed from ssms via windows authentication and from the .net sql 11 driver from the intranet.

    Has anyone experienced this or knows of any obvious things to check?

    Thanks in advance.

    Rolf

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • alevyinroc

    Grasshopper

    Points: 14

    I've seen a few occasions where Intellisense caused a bit of a slowdown because it was trying to scan through the schema to get table & field names (for example).

    If you switch off Intellisense in SSMS, does the issue persist?

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

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