Post reply

SQL Memory usage

  • March 1, 2012 at 4:29 am

    #257633

    Hi there,

    I have extracted SCOm reports to find out whether one of our servers is performing optimally. I have noticed that The Memory:Pages/sec is more than 20 at certain times of the day. The Buffer Cache Hit Ratio also has a dip at certain time. How can I check which queries or processes on the server is demanding more memory at certain times of the day. Please advise.

    Regards

    IC

  • March 6, 2012 at 5:59 am

    #1455237

    best thing would be to invest in something like sqlsentry to monitor your system.

    If you don't have the budget then running a server-side trace and possibly collect some perfmon counters (if SCOM doesn't collect all you want) so you can see what is actually being ran at that time when memory usage is increased.

    If its a specific time everyday then check for scheduled jobs or processes that run at that time.

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

  • March 6, 2012 at 6:07 am

    #1455242

    thanks

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

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