SQL Server Performance

why the difference in DTS?

Discussion in 'General DBA Questions' started by sunsanvin, Sep 8, 2006.

  1. sunsanvin New Member

    i've one database like 'x' and now i've exported the data to a newly created database 'y'

    but in this y database i got much memory like around 30 mb.
    why this happend?


    sorry if this is a small question.


    thankyou friends

    vinod kumar mallolu
    sunsanvin, Sep 8, 2006
    #2

  2. patel_mayur New Member

    Do you have the same table structure on both the databases 'x' & 'y' ?



    ------------------------
    Knowledge is not Power !!!
    But When its acted upon then its Power !!!
    patel_mayur, Sep 8, 2006
    #2

  3. Adriaan New Member

    What do you mean by memory here: "in this y database i got much memory like around 30 mb."

    No question is too small.
    Adriaan, Sep 8, 2006
    #2

  4. satya Moderator

    Confirm the database sizes for x and y by running sp_spaceused @updateusage='true'#

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Sep 8, 2006
    #2

  5. dineshasanka Moderator

    quote:

    but in this y database i got much memory like around 30 mb.


    is it disk space or memory


    quote:
    sorry if this is a small question.


    indeed it is a small question need more info

    ----------------------------------------

    dineshasanka, Sep 8, 2006
    #2

Share This Page