Post reply

DATABASE ISSUE

  • August 13, 2010 at 1:01 am

    #387574

    Hi All,

    Appications are running slowly, If any query's or sp, will take much more time to execute?

    how can i arrest this issue? i have attached my dabatase details..

    I would really appreciate.. if any body helpme...

    Thanks

    Balaji.G

  • August 13, 2010 at 1:10 am

    #1206431

    What have you done to try to find the issue?

    Are you getting any error messages?

    Are you getting deadlocks?

    Are queries timing out?

    Have you checked the index fragmentation?

    Have you checked to ensure stats are up to date?

    Have you checked for blocking?

    Is your disk space in good shape?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 13, 2010 at 1:26 am

    #1206441

    while execute the query or sp, some times timeout expired came.

    I have checked the fragmentation.. Some of the objects are heavily fragmented

    Most of the objects are not upto date.

    More Space available

    There is no blocking

    What i feel is, Shall i do the below activities

    1. shrink a database

    2. rebuild an index for all objects

    3. update the statistics for all objects

    Is it ok.. or else give me a suggestion

  • August 13, 2010 at 1:30 am

    #1206446

    balaji.ganga (8/13/2010)

    What i feel is, Shall i do the below activities

    1. shrink a database

    2. rebuild an index for all objects

    3. update the statistics for all objects

    Is it ok.. or else give me a suggestion

    1. NO - do not shrink your database. That would not help for this case.

    2. I would rebuild indexes, but it is not necessary for all indexes. Only rebuild the indexes that are necessary

    3. Yes - update stats and also a dbcc updateusage could provide some good mileage.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 13, 2010 at 1:35 am

    #1206448

    If interested please read http://strictlysql.blogspot.com/2010/02/database-server-is-slow-can-you-please.html%5B/url%5D

    Regards,
    Raj

    http://Strictlysql.blogspot.com

  • August 13, 2010 at 1:43 am

    #1206453

    Some of the unnecessary objects are available in our database.

    So that only i would delete those objects and shrink a database

    Some of the objects are heap.There is no constraint. I would suggest to development team to create a constraint for those objects

    Is it right ?

  • August 13, 2010 at 1:51 am

    #1206457

    balaji.ganga (8/13/2010)

    Some of the unnecessary objects are available in our database.

    So that only i would delete those objects and shrink a database

    Some of the objects are heap.There is no constraint. I would suggest to development team to create a constraint for those objects

    Is it right ?

    If you are absolutely certain that the objects do not belong in the database - I would work on getting them removed. This does not require a shrink of the database though.

    If the objects are heaps, you should investigate if a clustered index is appropriate for those tables and create a clustered index. A clustered index does not imply constraint though and a constraint does not imply an index.

    Once you create the clustered index, do not remove it (if you are doing it explicitly for defrag purposes ). Create appropriate clustered indexes that will persist in the database structure and be usable.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 13, 2010 at 1:52 am

    #1206458

    Removing unwanted objects is a good thing, but thats less likely to be the reason for your problem. Do a thorough analysis of the problem.

    Start checking from Task manager , perfmon ,DMVs to find which aspect of your server has problems.

    Regards,
    Raj

    http://Strictlysql.blogspot.com

  • August 13, 2010 at 3:08 am

    #1206476

    Thanks for all your valuable comments

    Regards

    Balaji.G

  • August 13, 2010 at 10:14 am

    #1206775

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 10 posts - 1 through 9 (of 9 total)

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