Reasons For Slowness in SQL Server 2008 R2 Express Edition We are observing intermittent slowness in our SQL Server. We ran sp_who2, sp_who3 stored procedures for checking CPU/IO usage but did not see any spikes/abnormal values. What else could be the possible reasons for slowness. What other reports we can take from SQL Server to analyze the issue?
We are using SQL Server 2008 R2 Express.
Without some examples of queries you're experiencing the slowness with, and their execution plans there's not much we have to go off of.
Other good monitoring tools you can use to try to capture something is sp_WhoIsActive and sp_Blitz. You can also check the most commonly occuring Wait Stats to see if there's anything abnormal there.