Post reply

database size

  • October 20, 2011 at 8:03 am

    #250316

    what would be the size of the database in real time in sql server and size of the data ware house.

    your answers would be appreciated.

    Thanks

    Pavithra

  • October 20, 2011 at 8:06 am

    #1397383

    exec sp_spaceused

  • October 20, 2011 at 8:07 am

    #1397384

    Don't understand the question. Are you looking for a script to calculate the size of a database?

    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

  • October 20, 2011 at 8:07 am

    #1397385

    YES or It Depends is the answer. Without more details it will be difficult to even guesstimate.

    -Roy

  • October 20, 2011 at 8:15 am

    #1397395

    not looking for the script to know the size of the data base. but i just want to know in general what would be the size of the data base in real time(at work environment).

    thanks

    Pavithra

  • October 20, 2011 at 8:15 am

    #1397397

    not looking for the script to know the size of the data base. but i just want to know in general what would be the size of the data base in real time(at work environment).

    thanks

    Pavithra

  • October 20, 2011 at 8:17 am

    #1397400

    Whatever data you have in it + free space in the files + logs.

    there's not real answer to your question.

  • October 20, 2011 at 8:19 am

    #1397401

    The answer is still It Depends. With no detail of what you are doing in your warehouse and what your OLTP DB does and store, it will be difficult to guess.

    Just my 2 cents

    -Roy

  • October 20, 2011 at 8:28 am

    #1397411

    Roy Ernest (10/20/2011)

    The answer is still It Depends. With no detail of what you are doing in your warehouse and what your OLTP DB does and store, it will be difficult to guess.

    Just my 2 cents

    Impossible.

  • October 20, 2011 at 8:35 am

    #1397419

    pavithrareddyc (10/20/2011)

    not looking for the script to know the size of the data base. but i just want to know in general what would be the size of the data base in real time(at work environment).

    Equivalent question: "How long is a piece of string?"

    Absolutely impossible to meaningfully answer.

    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

  • October 27, 2011 at 9:22 am

    #1400239

    lol, gila monster!

  • October 27, 2011 at 9:41 am

    #1400251

    pavithrareddyc (10/20/2011)

    not looking for the script to know the size of the data base. but i just want to know in general what would be the size of the data base in real time(at work environment).

    mmmhhh... about this size (points to an object which you cannot see) 😀

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 12 posts - 1 through 11 (of 11 total)

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