Post reply

Server randomly slows performance.

  • October 13, 2005 at 10:13 am

    #166463

    I have a quad processor 3.2 Ghz  with 4 gig of RAM of which SQL is configured for 3 gig or this RAM.  About once a week, we seem to get a period of time where Pages/Sec it averaging over 3000.  The is a OLTP database server with hundreds of current users.

    This server runs fine most days and their is no extraordinary load on it on the days it decides to become a slow piece of crap.  Any ideas?



    A.J.
    DBA with an attitude

  • October 13, 2005 at 12:45 pm

    #597189

    No need for a reply, this issue was figured out.  It was because one of our DBAs enabled 4 separate trace flags that Microsoft had asked us to enable to troubleshoot an Access Violation issue that we were getting.  MS did tell us it would have little or no impact on performance.   

    In case anyone cares, these trace flags were 2551, 8809, 815, 818

     

     



    A.J.
    DBA with an attitude

  • October 17, 2005 at 11:45 am

    #597707

    Just curious ... what did MS say that each of the trace flags did ???

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • October 18, 2005 at 6:04 pm

    #598110

    More than likely those were trace flags that dumped out more information in the SQLDumpxxx files that get created when the AVs occur and more than likely, only MSFT PSS can use that information.

    But if that was not the case, I am sure that all of would benefit from this information if you don't mind sharing it. Also, which version and which service pack were you running on ?

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

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