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.