RE: What all performance reports would you like to have in the SQL server?

From: Vikram Jayaram [MS] (vikramj_at_online.microsoft.com)
Date: 07/22/04


Date: Thu, 22 Jul 2004 20:15:08 GMT


Nilesh,

Greetings, and thanks for the fast reply.

By statistics, I didnt mean performance counter statistics. I meant SQL
statistics for indexes (see UPDATE STATISTICS for information, on Books
Online.)

Thanks!

Vikram Jayaram
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.



Relevant Pages

  • Re: Ms SQL server db options for performance issues after db corruption
    ... We try to investigate what caused the SQL performance degradation. ... We supsect that the HW failure in disk array caused db corruption. ... using the SET statement to enable the SHOWPLAN, STATISTICS IO, STATISTICS ... to execute the command SET ...
    (microsoft.public.sqlserver.server)
  • Re: Ms SQL server db options for performance issues after db corruption
    ... We try to investigate what caused the SQL performance degradation. ... We supsect that the HW failure in disk array caused db corruption. ... using the SET statement to enable the SHOWPLAN, STATISTICS IO, STATISTICS ... to execute the command SET ...
    (microsoft.public.sqlserver.tools)
  • Re: Ms SQL server db options for performance issues after db corruption
    ... We try to investigate what caused the SQL performance degradation. ... We supsect that the HW failure in disk array caused db corruption. ... using the SET statement to enable the SHOWPLAN, STATISTICS IO, STATISTICS ... to execute the command SET ...
    (microsoft.public.sqlserver.programming)
  • Re: Ms SQL server db options for performance issues after db corruption
    ... We try to investigate what caused the SQL performance degradation. ... We supsect that the HW failure in disk array caused db corruption. ... using the SET statement to enable the SHOWPLAN, STATISTICS IO, STATISTICS ... to execute the command SET ...
    (microsoft.public.sqlserver.setup)
  • RE: Performance on stored procedure vary a lot
    ... I still don't understand why the SQL server obviously chooses ... a "worse" execution plan for the first stored proc, ... > Make sure that you have good indexes on the tables, Auto Update Statistics ...
    (microsoft.public.sqlserver.programming)