Post reply

how can i get , It would be great if you can provide us the below details too

  • October 29, 2014 at 10:41 pm

    #397584

    Hi all

    how can i get , It would be great if you can provide us the below details too

    Database

    • DB Memory Usage

    • DB Buffer Manager Statistics

    • DB Connection Statistics

    • DB Cache Details

    • DB Access Method Details

    • Database Details

    • DB Scheduled Jobs

    what are the things i need to do to find out the above details in a particular SQL instance.

    Thanks

    Naga.RohitKumar

    Thanks
    Naga.Rohitkumar

  • October 30, 2014 at 1:47 am

    #1755692

    Most of that information can be found in the DMVs. (dynamic management views)

    Here's a free eBook:

    Performance Tuning with SQL Server Dynamic Management Views

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 30, 2014 at 1:50 am

    #1755694

    HI ,

    Can you please, mention what are those DMVs which and can be used and what dmv for what area in the list i menitoned

    Thanks
    Naga.Rohitkumar

  • October 30, 2014 at 2:01 am

    #1755701

    naga.rohitkumar (10/30/2014)

    HI ,

    Can you please, mention what are those DMVs which and can be used and what dmv for what area in the list i menitoned

    Did you read the book?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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