January 17, 2020 at 10:03 pm
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
January 18, 2020 at 10:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 20, 2020 at 6:09 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply