Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    3

    Post Unanswered: Need to check a table for errors

    Hi - please excuse my newness to this. I have a database with several tables and one of them is causing my application to lag really bad. I figure there is either not enough space or something is just wrong in general and i don't know what. Does SQL Server have a shortcut or easy way to test a table in the database?

    Thanks =)

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    If it is only giving performance troubles, I bet it is a large table (either many columns, many rows, or both). Look into the index tuning wizard in Enterprise Manager.

  3. #3
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Need to check a table for errors

    Originally posted by Avernus
    Hi - please excuse my newness to this. I have a database with several tables and one of them is causing my application to lag really bad. I figure there is either not enough space or something is just wrong in general and i don't know what. Does SQL Server have a shortcut or easy way to test a table in the database?

    Thanks =)
    dbcc checktable(yourtable)?

  4. #4
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    3

    Re: Need to check a table for errors

    Originally posted by snail
    dbcc checktable(yourtable)?
    Ok will try that.


    I also forgot to mention that it has worked fine for a year and all the sudden is causing literally 5 minute lag periods.

    Thanks =)

  5. #5
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Need to check a table for errors

    Originally posted by Avernus
    Ok will try that.


    I also forgot to mention that it has worked fine for a year and all the sudden is causing literally 5 minute lag periods.

    Thanks =)
    Also you could check for fragmentation (it is good idea to do this sometimes):

    DBCC SHOWCONTIG

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    In Query Analyzer execute one of the queries your app issues after setting Show Execution Plan to ON (Ctrl+K.) The corresponding pane will show you how the Optimizer processed the request. Pay close attention to anything in RED there, as well as table/index scans.

  7. #7
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    3
    "Also you could check for fragmentation (it is good idea to do this sometimes):

    DBCC SHOWCONTIG"


    I get an error trying to run this alone. I read something about having to include an Object ID with this command. Can you show me an example of how that looks written out for one table? Thanks, I appreciate this bigtime =)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •