Forum Replies Created

Viewing 15 posts - 18,286 through 18,300 (of 19,560 total)

  • RE: requirements on multi instanses

    I am not sure I follow your question.

    Could you elaborate please?

    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

  • RE: Are the posted questions getting worse?

    Roy Ernest (1/8/2010)


    Yes Lynn, I knew that... 🙂

    I did not look at how many posts that the OP had. 600 + posts and still like that is a shocker....

    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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/8/2010)


    Roy Ernest (1/8/2010)


    Hens have teeth was really bad..I mean the OP was way over his head in that issue. He has no clue about SQL Server.

    But the the...

    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

  • RE: Are the posted questions getting worse?

    GilaMonster (1/8/2010)


    Roy Ernest (1/8/2010)


    Hens have teeth was really bad..I mean the OP was way over his head in that issue. He has no clue about SQL Server.

    600 posts later. Seems...

    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

  • RE: Account Lockout Threshold

    NP

    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

  • RE: requirements on multi instanses

    Krasavita (1/8/2010)


    We installed 1 more processor,but it is not showing that we have 2 now,what do we need to do Thank you

    Does the OS show that you have an additional...

    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

  • RE: Account Lockout Threshold

    Password policy is set by using the Active Directory Users and Computers tool if you're using Active Directory, or by using the Local Security Settings administrator tool if you're administering...

    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

  • RE: Database Tuning Adviser (DTA)

    DTA will throw out multiple indexes that it deems appropriate. It is recommended that you test the indexes to ensure they will work appropriately. You will not always...

    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

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (1/8/2010)


    And once again, I'm lost.

    Mission accomplished :w00t:

    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

  • RE: Being Supportive

    Paul Stafford (1/8/2010)


    The conversation was in the context of how an IT department should function as a team to help the users in a business. If we're...

    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

  • RE: requirements on multi instanses

    Krasavita (1/8/2010)


    Do I need to re boot after I changed max memory settings?

    I don't expect production to run queries developed in dev with parallelism. Can main instanse be disable and...

    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

  • RE: requirements on multi instanses

    Krasavita (1/8/2010)


    I stoped 4 instances that we are not using and changex max settings and now I have these:

    counter_nameinstance_namecntr_value

    Target Server Memory (KB) ...

    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

  • RE: Are the posted questions getting worse?

    Ok - so there were really ten instances for the hen with teeth.

    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

  • RE: requirements on multi instanses

    Krasavita (1/8/2010)


    Oh, I didn't change max memory for my maine instanse, do I need it? I only changed max memory for all 9 instansases

    Yes, you will need to change the...

    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

  • RE: Refresh on a view with schemabinding

    Lowell (1/8/2010)


    i didn't see this thread, and started building my response before Jason posted the cross post info.

    And you explained it quite nicely - twice even.:-)

    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 15 posts - 18,286 through 18,300 (of 19,560 total)