Question: why sql server is slow?
Answer: Troubleshooting Slow Servers. Missing indexes, an inadequate storage I/O subsystem, or a slow network are only some of the possible reasons why a SQL Server database engine might slow down, which is why finding the true cause of a performance bottleneck is vital. ... Poor index design. Poorly designed database schema.