Post reply

Analysis and statistics

  • February 16, 2015 at 3:18 am

    #297835

    Hello all,

    I am a newbie in SQL Server, so I need your help !.

    I would to have analytics software to know if some queries are not properly writing or to know which request are the most called etc..

    Maybe we can do everything with the management studio but I'm sot sure.

    Thank you very much in advance.

  • February 16, 2015 at 9:08 am

    #1777850

    use sys.dm_exec_query_plan to find the execution counts from restart, the area you asked is performance tuning ot improvement which is a vast area and it will come in experience only. just read about all DMV's and start on your own.

    Regards
    Durai Nagarajan

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

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