SQL Server Performance

Search Results

Search Again
  1. Kwisatz78

    Reading stats after rebuilding an Index

    Thread by: Kwisatz78, Aug 28, 2009, 10 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    Hi all prior to an index rebuild I had the following stats avg_fragmentation%fragment_countavg_fragment_size_in_pagespage_count...
  2. Kwisatz78

    Rebuild Maintenance Task

    Thread by: Kwisatz78, Aug 28, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions
    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...
  3. Kwisatz78

    Lots of Function calls in tuning template

    Thread by: Kwisatz78, Aug 27, 2009, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    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...
  4. Kwisatz78

    Tuning template returning lots of function calls

    Thread by: Kwisatz78, Aug 27, 2009, 2 replies, in forum: SQL Server 2008 Performance Tuning for DBAs
    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...
  5. Kwisatz78

    Quick profiler question

    Thread by: Kwisatz78, Aug 25, 2009, 5 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    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...
Showing results 1 to 5 of 5
Search Again