SSC Databases

  • Someone asked, so a few stats for you as of this post:

    Auth db (signon stuff)

    1GB data

    900MB log

    about 80% full on data space

    Main DB (content, tracking, votes, QOD, etc.)

    15GB data

    9GB log

    About 85% full on data

    Forums

    4.5GB data

    400MB FT

    1.5GB log

    75% full

    CS (blogs)

    870MB data

    1.1GB logs (too large)

    40% full

  • Thanks Steve.

    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

  • Thanks for the Info!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Nice to know! one more question: is your sa account enabled and what is the password? 😛

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Henrico Bekker (4/29/2010)


    Nice to know! one more question: is your sa account enabled and what is the password? 😛

    It is not documented by Steve, so I guess he doesn't have this info! - LOL :w00t::hehe::w00t::hehe::cool:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Dugi (4/30/2010)


    Henrico Bekker (4/29/2010)


    Nice to know! one more question: is your sa account enabled and what is the password? 😛

    It is not documented by Steve, so I guess he doesn't have this info! - LOL :w00t::hehe::w00t::hehe::cool:

    Default password = blank:-D:-D:-D

    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

  • CirquedeSQLeil (4/30/2010)


    Dugi (4/30/2010)


    Henrico Bekker (4/29/2010)


    Nice to know! one more question: is your sa account enabled and what is the password? 😛

    It is not documented by Steve, so I guess he doesn't have this info! - LOL :w00t::hehe::w00t::hehe::cool:

    Default password = blank:-D:-D:-D

    ..hey Hacker is here ...SOS SOS .... hahahhahahaa 😎 😉 😀 :hehe: :w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Dugi (4/30/2010)


    CirquedeSQLeil (4/30/2010)


    Dugi (4/30/2010)


    Henrico Bekker (4/29/2010)


    Nice to know! one more question: is your sa account enabled and what is the password? 😛

    It is not documented by Steve, so I guess he doesn't have this info! - LOL :w00t::hehe::w00t::hehe::cool:

    Default password = blank:-D:-D:-D

    ..hey Hacker is here ...SOS SOS .... hahahhahahaa 😎 😉 😀 :hehe: :w00t:

    LOL

    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

  • Hmm, I don't know the sa pwd, but I Can check and see if it's blank. The server is at 127.0.0.1 if anyone wants to help 😉

  • Steve Jones - Editor (4/30/2010)


    Hmm, I don't know the sa pwd, but I Can check and see if it's blank. The server is at 127.0.0.1 if anyone wants to help 😉

    LOL. Amazingly you have the same database names as me - oh wait...:-D;-)

    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