Post reply

Slow performance

  • September 2, 2009 at 1:13 pm

    #1048389

    Hi,

    You can perf dash board to find what is going on your SQL Server when you will find that there is CPU or Memory spike is there

    Please find link to download it

    http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

    Regards,

    Nirav

  • September 2, 2009 at 6:42 pm

    #1048504

    Thanks Gail for prividing the links. Much useful.

    However, can you please let me know -

    --whether any standard metrics (predefined std value) is available to judge the perfmon counter values to understand whether the values are large or small?

    Thanks.

  • September 3, 2009 at 1:14 am

    #1048550

    GilaMonster (9/1/2009)

    I've seen a SQL Server brought to its knees by an admin copying a large backup file off the server.

    My favourite is the over eager virus scanner.


    Clear Sky SQL
    My Blog[/url]

  • September 3, 2009 at 1:37 am

    #1048553

    Dave Ballantyne (9/3/2009)

    GilaMonster (9/1/2009)

    I've seen a SQL Server brought to its knees by an admin copying a large backup file off the server.

    My favourite is the over eager virus scanner.

    Im with Dave on this... Make sure you exclude mdf, ldf, ndf... Also I exclude .bak and .trn

  • September 3, 2009 at 1:52 am

    #1048556

    Check to see if you have any scheduled jobs running at the time as well.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • September 3, 2009 at 2:26 am

    #1048573

    sql_lock (9/3/2009)

    Dave Ballantyne (9/3/2009)

    GilaMonster (9/1/2009)

    I've seen a SQL Server brought to its knees by an admin copying a large backup file off the server.

    My favourite is the over eager virus scanner.

    Im with Dave on this... Make sure you exclude mdf, ldf, ndf... Also I exclude .bak and .trn

    Don't forget errorlog.* and .trc.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 16 through 20 (of 20 total)

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