Post reply

SQL Server 2008 R2 slow after a week

  • November 24, 2011 at 12:09 pm

    #252547

    Hi all,

    I have a SQL 2008R2 server with several databases attending different systems and applications, including a small Totvs ERP, a Websense Server, etc.

    The server runs fine for 5 days then starts to get slow and as time passes, slower and slower until eventually it stop answering the ERP applications.

    What could be happening and where should I look?

    Hardware resources looks fine....memory, disk, network...

    Any help is apprecited.

    Mario

  • November 24, 2011 at 3:01 pm

    #1412803

    There's simply not enough information...

    What exactly do you mean by "getting slow"?

    You'll need to figure out if there are specific queries getting slower and where those queries get the data from.

    It might be an issue of the response time of the "different systems", a grow of data volume,...

    You could start with looking at the standard reports at the instance level (e.g. MemoryConsumption or the performance metrics).


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • November 24, 2011 at 3:36 pm

    #1412808

    Could you also please provide some information on the maintenance task you are executing on the Server? Thanks in advance!



    My blog

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

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