Post reply

DB Run slow

  • November 17, 2009 at 11:52 pm

    #142997

    Hi

    My database Run slow ,yesterday it runs normally all index are created correctly

    what might be the problem?

    1.)with out using profiler how to check where is problem

    2.)with using profiler how to check where is problem

    Database size is 5GB

    Thanks

    Parthi

    Thanks
    Parthi

  • November 18, 2009 at 12:23 am

    #1080708

    Some general issues for Query performing slow so the database were No indexes, table scans, missing or out of date statistics, blocking, excess recompilations of stored procedures, procedures and triggers without SET NOCOUNT ON, poorly written query with unnecessarily complicated joins, too much normalization, excess usage of cursors and temporary tables.

    You can use Profiler to find out ;

    Which queries taking longer time for excution..

    Blocking Problem..

    Index usages or unused indexes..

    Refer books online..regarding profiler usage

    Rd,

    Deepali

  • November 18, 2009 at 12:26 am

    #1080710

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

  • November 18, 2009 at 12:27 am

    #1080711

    download performance dashboard & install it if u r using sql server 2005

    this will directly give u the query which is taking longer time & also provides index script for the same if required.

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

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

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