June 21, 2013 at 1:25 am
Hi,
We are using Sql server 2008 R2 Express. We have clustered index with incremental key for our almost all tables. We noticed our queries is executing slow. So we needed to optimize query working in server.We do de-fragment indexes with high fragmentation monthly.Fill factor for indexes are set to 100.I monitored Access Methods\Page Splits/sec counter and average value is around 1.Is there any need to modify Fill factor setting? Auto create statistics and Auto update statistics set to true.Is there any need to update statistics manually? If so how often i need to update statistics? Is there any reasons for query slowing down?
Thank you
June 21, 2013 at 1:31 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2013 at 4:31 am
GilaMonster (6/21/2013)
http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/
Thanks for reply
So i have to update statistics regularly for large tables right?
June 21, 2013 at 4:35 am
Maybe, maybe not. Depends on the tables, the data patterns and the queries that run.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply