SQL Server running very slow (Tips) Check the statistics, index fragmentation.  In anycase, if you store image in Database , then the performance will hit. If you have removed all the images from the db and then also its slow then , it may be because of Fragmentation,statistcs are not updated and also indexes are outdated. Run (a) sp_updatestats (b) DBCC DBREINDEX (its a offline process and it will lock the tables) (c) check the space used by the database. you may need to shrink 
Leggi tutto il post...