How to get these details in sqlserver

  • HI all,

    1. CPU and Memory Utilization for Last 15 days of DB server and Application server

    2. Top Costly Query by Average IO during pick our.

    3. Top Costly Query by Average CPU during pick our.

    4. Top 40 Tables size and its indexs name.

    5. All 40 tables indexes fragmentation % value.

    6. Update Stats Status Log for database a1 & a2.

    7. Buffer Cache Hit Ratio Output Graph for Last 15 days of DB server.

    Thanks
    Naga.Rohitkumar

  • interview questions?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • 1 and 7 - google "performance monitor"

    2 and 3, google "query plan cache stats" or "SQL profiler"

    4 google "catalog views"

    5 google "index fragmentation DMV"

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply