RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

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 the db, incase there is drastic difference in actual data stored and the physical size of the file

Note : Store the image filename in the database instead of the image itself.

(d) move indexes on separate filegroups

 

Refer these links:

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19594

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19595

Categoria: Sql Server ALL
domenica, 29 apr 2007 Ore. 18.28

Messaggi collegati


Statistiche
  • Views Home Page: 452.110
  • Views Posts: 864.745
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003