Hi Moh thanks for the reply Yes the table does have a clustered index and has the following stats: avg_fragmentation% = 2.5 Page_count = 10372 This...
Hi there Sorry but I don't believe what you have written to be correct. The DMV sys.dm_db_index_physical_stats column avg_fragmentation_in_percent...
Hi all prior to an index rebuild I had the following stats avg_fragmentation%fragment_countavg_fragment_size_in_pagespage_count...
HI thanks - I found this to be a function thats replacing 0 with null and have filtered it from my tuning template.
Hi all I have created a rebuild maintenance task using offline and as a test only running against one table that has around 12000 rows and currently...
Ok thanks, in the end I found the function to be a simple replace of 0 to null for which gets called a lot of times. I have filtered out this...
Hi there - I recently ran a trace to be used by the DTA. The file grew incredibly quickly and in the trace I can see masses of the following all...
Ah I see - thanks for clearing that up. SQL Agent did account for a few of the longer durations, so filtering that out should help.
HI thanks for the reply. Specifically I was reading this article: http://www.sql-server-performance.com/articles/per/performance_audit_part8_p1.aspx...
HI there - I am following the guide on using profiler to audit performance issues, and in there it advised to filter out System events. Can anyone...
Separate names with a comma.
