Post reply

Determining Peak\Off Peak Hours

  • June 22, 2016 at 12:54 am

    #314655

    Hi Experts,

    We have a new production server and we are trying to find a suitable timing to patch the server for that we need to find the Off Peak hours where the connections are at minimum. How can i achieve that.

    Please help

    TIA

  • June 22, 2016 at 1:09 am

    #1886151

    Hi,

    I think you need a monitoring tool, or you had to lock at the performance counters from performance monitor.

    Just collect them for 1 week, and you find your window for maintenance.

    Kind regards,

    Andreas

  • June 22, 2016 at 1:10 am

    #1886153

    If you want to concentrate on connections, monitor the performance counter SQLServer: General Statistics – User Connections. For a more sophisticated analysis, you might also include other counters such as SQLServer: SQL Statistics – Batch Requests/sec and Processor – % Processor Time. There's a lot of articles out there on the best performance counters for particular situations.

    John

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

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