RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

SQL Server running very slow (Tips)

 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...
Categoria: Sql Server ALL
domenica, 29 apr 2007 Ore. 18.28

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003