SQL Server Performance

query preformance

Discussion in 'SQL Server 2008 General DBA Questions' started by test, Jan 1, 2010.

  1. test New Member

    Hi All,
    I am using SQLServer 2005.
    my SQLServer system ram is 2 GB.
    It is taking time to insert even 1 record .
    what to do ?
    thanks
  2. Luis Martin Moderator

    Welcome to the forums!
    About the question (about 2005 in 2008 section):
    Think.
  3. FrankKalis Moderator

    [quote user="test"]
    Hi All,
    I am using SQLServer 2005.
    my SQLServer system ram is 2 GB.
    It is taking time to insert even 1 record .
    what to do ?
    [/quote]
    Can you please provide more information? Such as the table schema, the query you're using and what exactly it means when you say "taking time"?
  4. preethi Member

    [quote user="FrankKalis"]Can you please provide more information? Such as the table schema, the query you're using and what exactly it means when you say "taking time"?[/quote]
    Just to clarify, when providing table schema you need to tell about the clustered and non clustered indexes as well.
    How many rows that table currently have?
  5. Luis Martin Moderator

    Frank, Dinesh and Preethi, the guy name is "test" and, after 26 days, is not a real question.
  6. FrankKalis Moderator

    My reply was 2 days after the question... [:)]
  7. Luis Martin Moderator

    <p>[quote user="FrankKalis"]</p><p>My reply was 2 days after the question... <img src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif" alt="Smile"><br></p><p>[/quote]&nbsp;</p><p>You are the sunshine of my life..lalalalala[:D] <br></p>
  8. preethi Member

    [quote user="Luis Martin"] Frank, Dinesh and Preethi, the guy name is "test" and, after 26 days, is not a real question.[/quote]
    hmmm...I need to learn more things regarding posts. Thank you for the feedback.
    .
  9. FrankKalis Moderator

    Don't worry. Happens to me as well that I don't look at the post date.
  10. Luis Martin Moderator

    [quote user="preethi"]
    [quote user="Luis Martin"] Frank, Dinesh and Preethi, the guy name is "test" and, after 26 days, is not a real question.[/quote]
    hmmm...I need to learn more things regarding posts. Thank you for the feedback.
    .[/quote]
    I try to wrote something funny and, because my lack of English, all of you take it seriously. Sorry about that.[:$]
  11. preethi Member

    Oh no. I was reminded of something important: "Pay more attention to details".
    Thank you for pointing that.
  12. dineshasanka Moderator

    Memory is not the only issue when it comes to performance. There are many things you need to look at.
    is it happening every time or at specific time.
    Can you share us the insert script you are trying to execute

Share This Page