SQL Server Performance

Server Statistics

Discussion in 'Analysis Services/Data Warehousing' started by jonathanB, Jan 23, 2007.

  1. jonathanB New Member

    Can you give me scripts on how to get the following info?

    capacity metrics
    -server hd capacity
    -db total size / db free-space
    -server hd size versus db size
    -db growth rate
    -db file location
    -db transaction

    performance metrics
    -sql server cpu utilization
    -sql server memory utilization
    -sql server network utilization
    -sql server user connections
    -db log growth
    -db txns/sec
    -db %log use

    ---- Thanks in advance ------
  2. satya Moderator

Share This Page